[horde] horde-db-migrate error

Mon Apr 11 13:12:01 UTC 2011

Thanks to ronan from another thread. That problem found a solution:

mysql> update kronolith_events set event_creator_id=lower(event_
creator_id);

some users logged in a long time ago, and ldap is case insensitive. So some
records were added using a capital and generating a duplicate key error.
Don't know what could be the fix is uids are sensitive..

Dom

2011/4/11 LALOT Dominique <dom.lalot at gmail.com>

> Hello,
>
> I'm following that thread because the errors are related. I followed the
> update of the script. I'm still having errors. I am also unabled to migrate
> kronolith.
>
> 2011-04-11T14:29:18+02:00 DEBUG: HORDE [horde] SQL  (0,0003s)
>         SELECT user_id, user_name FROM `rampage_users` WHERE user_name IN
>           ('toto') [pid 32594 on line 783 of
> "/usr/share/php/Horde/Db/Adapter/Base.php"]
> 2011-04-11T14:29:18+02:00 NOTICE: HORDE [horde] PHP ERROR: Undefined index:
> toto [pid 32594 on line 75 of
> "/var/www/horde/content/lib/Users/Manager.php"]
> 2011-04-11T14:29:18+02:00 DEBUG: 1. Horde_Db_Migration_Migrator->up()
> /var/www/horde/admin/config/index.php:83
> 2. Horde_Db_Migration_Migrator->_doMigrate()
> /usr/share/php/Horde/Db/Migration/Migrator.php:102
> 3. Horde_Db_Migration_Base->migrate()
> /usr/share/php/Horde/Db/Migration/Migrator.php:182
> 4. KronolithUpgradeCategoriesToTags->up()
> /usr/share/php/Horde/Db/Migration/Base.php:121
> 5. Content_Tagger->tag()
> /var/www/horde/kronolith/migration/18_kronolith_upgrade_categoriestotags.php:44
> 6. Content_Users_Manager->ensureUsers()
> /var/www/horde/content/lib/Tagger.php:117
> 7. Horde::errorHandler() /var/www/horde/content/lib/Users/Manager.php:75
>
> 2011-04-11T14:29:18+02:00 ERR: HORDE [horde] SQL QUERY FAILED:
> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'toto'
> for key 'rampage_users_user_name'
>         INSERT INTO `rampage_users` (user_name) VALUES ('toto') [pid 32594
> on line 792 of "/usr/share/php/Horde/Db/Adapter/Base.php"]
> 2011-04-11T14:29:18+02:00 DEBUG: HORDE [horde] SQL
>         INSERT INTO `rampage_users` (user_name) VALUES ('toto') [pid 32594
> on line 783 of "/usr/share/php/Horde/Db/Adapter/Base.php"]
> 2011-04-11T14:29:18+02:00 DEBUG: HORDE [horde] SQLSTATE[23000]: Integrity
> constraint violation: 1062 Duplicate entry 'toto' for key
> 'rampage_users_user_name' [pid 32594 on line 27 of
> "/usr/share/php/Horde/Core/Notification/Handler/Decorator/Hordelog.php"]
>
> Dom
>
>
>
> 2011/4/9 Simon Brereton <simon.brereton at dada.net>
>
>> > From: horde-bounces at lists.horde.org [mailto:horde-
>> > bounces at lists.horde.org] On Behalf Of Simon Brereton
>> > > From: horde-bounces at lists.horde.org [mailto:horde-
>> > > bounces at lists.horde.org] On Behalf Of Michael Rubinsky Quoting
>> > Simon
>> > > Brereton <simon.brereton at dada.net>:
>> > >
>> > > > Hi
>> > > >
>> > > > So, I installed the final H4 as a fresh install and set it up
>> > from
>> > > > scratch with a new (empty) db.
>> > <SNIP>
>> > > > The log says only:
>> > > >
>> > > > 2011-04-08T22:34:59+01:00 ERR: HORDE [horde] Share name
>> > > > user at mydomain.com not found [pid 18239 on line 179 of
>> > > > "/usr/share/php/Horde/Share/Sql.php"]
>> > > > 2011-04-08T22:34:59+01:00 NOTICE: HORDE [horde] PHP ERROR:
>> > > Undefined
>> > > > variable: cal [pid 18239 on line 53 of
>> > > >
>> > >
>> > "/usr/share/horde4/kronolith/migration/18_kronolith_upgrade_categorie
>> > > s
>> > > > totags.php"]
>> > > >
>> > > > Any  ideas?
>> > >
>> > > There are two issues here:
>> > >
>> > > The first issue is that for some reason the share that represents a
>> > > calendar that a particular event belongs to is not being found.
>> >
>> > Ja, not too worried about that one.  It was my user and probably an
>> > experiment.
>> >
>> > > The second issue is the real showstopper as far as finishing the
>> > > migrations is concerned. Code that should only be executed when the
>> > > share is found *is* being run when the share is not found.
>> > >
>> > > The second issue has already been fixed in the code - as I
>> > responded
>> > > in the previous thread that you referenced. I also provided a link
>> > > that shows the changes.
>> >
>> > I remembered you fixing it - that was part of the rationale behind
>> > the totally fresh install :)  So, is there something I need to do
>> > now?  I don't know anything about git.  Is there some way to download
>> > the new file, or should I attempt to do it manually?
>>
>> Okay, backed-up the file and added in the lines from
>> http://git.horde.org/horde-git/-/commit/caa4e05913b86054407bf7dbd4e885ec0cd0d7f8and removed the lines in red, and ran the script from the command line again
>> and success.  Refreshing the panel and everything is now green!
>>
>> Thanks!
>>
>> Simon
>>
>> --
>> Horde mailing list
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>>
>
>
>
> --
> Dominique LALOT
> Ingénieur Systèmes et Réseaux
> http://annuaire.univmed.fr/showuser.php?uid=lalot
>

-- 
Dominique LALOT
Ingénieur Systèmes et Réseaux
http://annuaire.univmed.fr/showuser.php?uid=lalot