[horde] horde-db-migrate error

[LALOT Dominique]

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