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

[ANANT S ATHAVALE]

----- 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? )


>
>> 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.
------------------------------------------------------------------------------