[horde] Database upgrade scripts

[Carlos Cristóbal Sabroe Yde]

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

  1. Horde_Core_Db_Migration->getMigrator() /usr/bin/horde-db-migrate:138
  2. Horde_Db_Migration_Migrator->__construct() 
/usr/share/php5/PEAR/Horde/Core/Db/Migration.php:95
  3. Horde_Db_Migration_Migrator->_initializeSchemaInformation() 
/usr/share/php5/PEAR/Horde/Db/Migration/Migrator.php:77
  4. Horde_Db_Adapter_Base_TableDefinition->end() 
/usr/share/php5/PEAR/Horde/Db/Migration/Migrator.php:281
  5. Horde_Db_Adapter_Mysql_Schema->endTable() 
/usr/share/php5/PEAR/Horde/Db/Adapter/Base/TableDefinition.php:200
  6. Horde_Db_Adapter_Base_Schema->endTable() 
/usr/share/php5/PEAR/Horde/Db/Adapter/Mysql/Schema.php:265
  7. Horde_Db_Adapter_Mysql_Schema->execute() 
/usr/share/php5/PEAR/Horde/Db/Adapter/Base/Schema.php:548
  8. Horde_Db_Adapter_Base_Schema->__call() 
/usr/share/php5/PEAR/Horde/Db/Adapter/Base/Schema.php:548
  9. call_user_func_array() 
/usr/share/php5/PEAR/Horde/Db/Adapter/Base/Schema.php:166
10. Horde_Db_Adapter_Base->execute()
11. Horde_Core_Db_Migration->getMigrator() /usr/bin/horde-db-migrate:138
12. Horde_Db_Migration_Migrator->__construct() 
/usr/share/php5/PEAR/Horde/Core/Db/Migration.php:95
13. Horde_Db_Migration_Migrator->_initializeSchemaInformation() 
/usr/share/php5/PEAR/Horde/Db/Migration/Migrator.php:77
14. Horde_Db_Adapter_Base_TableDefinition->end() 
/usr/share/php5/PEAR/Horde/Db/Migration/Migrator.php:281
15. Horde_Db_Adapter_Mysql_Schema->endTable() 
/usr/share/php5/PEAR/Horde/Db/Adapter/Base/TableDefinition.php:200
16. Horde_Db_Adapter_Base_Schema->endTable() 
/usr/share/php5/PEAR/Horde/Db/Adapter/Mysql/Schema.php:265
17. Horde_Db_Adapter_Mysql_Schema->execute() 
/usr/share/php5/PEAR/Horde/Db/Adapter/Base/Schema.php:548
18. Horde_Db_Adapter_Base_Schema->__call() 
/usr/share/php5/PEAR/Horde/Db/Adapter/Base/Schema.php:548
19. call_user_func_array() 
/usr/share/php5/PEAR/Horde/Db/Adapter/Base/Schema.php:166
20. Horde_Db_Adapter_Base->execute()
21. PDO->query() /usr/share/php5/PEAR/Horde/Db/Adapter/Base.php:551

====================

Can anyone help me to upgrade?
Thanks

-- 
Cristóbal