[horde] Error when upgrading databases from HGWE 1.2.11 to HGWE 5.1.1

[Jan Schneider]

Zitat von ANANT S ATHAVALE <asa at isac.gov.in>:

> ----- Message from ANANT S ATHAVALE <asa at isac.gov.in> ---------
>    Date: Thu, 15 Aug 2013 08:44:52 +0530
>    From: ANANT S ATHAVALE <asa at isac.gov.in>
> Subject: [horde] Error when upgrading databases from HGWE 1.2.11 to  
> HGWE 5.1.1
>      To: horde at lists.horde.org
>
>
>> Dear All,
>>
>> I have started working on HGWE 5.1.1.  My previous set up is HGWE  
>> 1.2.11.  All tables have got updated except
>>
>> 1. nag
>>
>> Error is:
>>
>> [  INFO  ] Current nag schema version: 9
>> Migrating to NagUpgradeCategoriesToTags (10)
>>
>> QUERY FAILED: Duplicate entry 'XXXXXX at isac.gov.in' for key  
>> 'rampage_users_user_name'
>>
>> INSERT INTO `rampage_users` (user_name) VALUES ('XXXXXX at isac.gov.in')
>>
>> 2. horde_history
>>
>> Error is:
>>
>> [  INFO  ] Current Horde_History schema version: 4
>> Migrating to HordeHistoryRemoveCompositeIndex (5)
>> == 5 HordeHistoryRemoveCompositeIndex: migrating  
>> ==============================
>> -- removeIndex('horde_histories', 'history_modseq')
>> QUERY FAILED: Can't DROP 'index_horde_histories_on_history_modseq';  
>> check that column/key exists
>>
>> DROP INDEX `index_horde_histories_on_history_modseq` ON `horde_histories`
>>
>>
>> Please guide to resolve these two issues.
>>
>> -- 
>>          Regards
>>           Anant
>>
>
> I have now been able to resolve the first issue, by deleting the  
> records in nag_tasks w.r.t. that XXXXXX at isac.gov.in.  but, for  
> second one I don't have a clue.

You can ignore that.

> Where can see the complete schema of horde database (if I have to  
> create a new one) ?  Earlier the schema used to be available in  
> scripts/sql directory.  Now, with pear install, there is no such  
> directory.  I want to compare the schema with existing schema.

There is no such schema.
-- 
Jan Schneider
The Horde Project
http://www.horde.org/