[horde] Database upgrade scripts

[Vilius Šumskas]

> El 15/03/13 16:47, Vilius S(umskas escribió:
> > Sveiki,
> >
> >> El 15/03/13 08:29, Vilius S(umskas       escribió:
> >>
> >>
> >> Hi, I'm running a Horde Groupware Webmail Edition 1.2.9 and have tested
> >> successfully an upgrade to the new version 5.0.4.
> >> I'm almost ready to put it in the production site, but need to upgrade
> >> the database (MySQL) again.
> >> Where can I find just the database upgrade scripts to re-apply them?
> >> Thanks a lot
> >>
> >>
> >> In the same place you've found them before?
> >
> >>
> >>       Err.... no.
> >>
> >>       I did a fresh install of hgwe 5 using the "webmail-install"
> >> script     using my existing mysql credentials. I don't know what that script
> did internally.
> >>       I'm planning to to get an updated version of the mysql
> >> database and     re-apply the db upgrade scripts.
> >>
> > If I understood you right "horde-db-migrate" will do the job.
> >
> Thanks Vilius.
> 
> Just for testing purposes I've restored the original hgwe 1.2.9 db we
> have in production and ran the script to upgrade to 5.0.4. I get this error:
> 
> horde-db-migrate
> [  INFO  ] Migrating DB up.
> 
> ====================
> 
> Error irrecuperable:
> SQLSTATE[42S01]: Base table or view already exists: 1050 Table
> '`horde2010_db`.`imp_schema_info`' already exists
> En /usr/share/php5/PEAR/Horde/Db/Adapter/Base.php en lnea 551

Your "original db" is not so original, because imp_schema_info should not exist in HGWE 1.2.9.

-- 
    Vilius