[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 Jan Schneider <jan at horde.org> ---------
>    Date: Thu, 15 Aug 2013 10:50:45 +0200
>    From: Jan Schneider <jan at horde.org>
> Subject: Re: [horde] Error when upgrading databases from HGWE 1.2.11  
> to HGWE 5.1.1
>      To: horde at lists.horde.org
>
>
>> 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.
>
>
> You mean, I can ignore the 2nd one (Horde_history schema upgrade? )

Yes.
>
>>
>>> 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/
>>
>> -- 
>> Horde mailing list
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>
>
> ----- End message from Jan Schneider <jan at horde.org> -----
>
>
> -- 
>           Regards
>            Anant
>
> ------------------------------------------------------------------------------
> Confidentiality Notice: This e-mail message, including any  
> attachments, is for
> the sole use of the intended recipient(s) and may contain confidential and
> privileged information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the intended recipient, please
> contact the sender by reply e-mail and destroy all copies of the original
> message.
> ------------------------------------------------------------------------------


-- 
Jan Schneider
The Horde Project
http://www.horde.org/