[horde] Upgrading database from H3 to H5

[Nicolás Valera]

On 11/17/2012 06:49 AM, Jan Schneider wrote:
>
> Zitat von Nicolás Valera <nvalera at gmail.com>:
>
>> On 11/16/2012 03:43 PM, Jan Schneider wrote:
>>>
>>> Zitat von Michael M Slusarz <slusarz at horde.org>:
>>>
>>>> Quoting nvalera at gmail.com:
>>>>
>>>>> Hi, is there any way to upgrade my H3 database to H5?
>>>>> Thanks in advance!
>>>>> Nicolas.
>>>>> Pd. Sorry about my english
>>>>
>>>> You need to upgrade to H4 first.
>>>>
>>>> michael
>>>>
>>>> ___________________________________
>>>> Michael Slusarz [slusarz at horde.org]
>>>
>>> Actually no, you can directly upgrade to H5, but you need to follow the
>>> H4 + H5 upgrading steps in the UPGRADING docs.
>>
>> Thanks for the quick answers!
>> i trying to install the H4 though pear but i cant, can anyone tell me
>> how?
>> i have a new/fresh install debian server with only a copy off the h3
>> database.
>> Thanks again!
>
> Like I said, you can upgrade to H5 immediately.

Sorry, but i tried that and it doesn't work for me.

step by step:

apt-get install lighttpd mysql-server ...

mysql -p < horde-dumpfile.sql

pear channel-discover pear.horde.org
pear install horde/horde_role
pear run-scripts horde/horde_role
pear install -a -B horde/webmail

  webmail-install

Writing main configuration file... done.

Creating and updating database tables...
====================

Fatal Error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'task_creator' in 
'field list'
In /usr/share/php/Horde/Db/Adapter/Base.php on line 551

  1. Horde_Core_Bundle->migrateDb() /usr/bin/webmail-install:32
  2. Horde_Db_Migration_Migrator->up() 
/usr/share/php/Horde/Core/Bundle.php:107
  3. Horde_Db_Migration_Migrator->_doMigrate() 
/usr/share/php/Horde/Db/Migration/Migrator.php:102
  4. Horde_Db_Migration_Base->migrate() 
/usr/share/php/Horde/Db/Migration/Migrator.php:182
  5. NagUpgradeCategoriesToTags->up() 
/usr/share/php/Horde/Db/Migration/Base.php:121
  6. NagUpgradeCategoriesToTags->select() 
/var/www/horde/nag/migration/10_nag_upgrade_categoriestotags.php:48
  7. Horde_Db_Migration_Base->__call() 
/var/www/horde/nag/migration/10_nag_upgrade_categoriestotags.php:48
  8. call_user_func_array() /usr/share/php/Horde/Db/Migration/Base.php:86
  9. Horde_Db_Adapter_Base->select()
10. Horde_Db_Adapter_Base->execute() 
/usr/share/php/Horde/Db/Adapter/Base.php:405
11. Horde_Core_Bundle->migrateDb() /usr/bin/webmail-install:32
12. Horde_Db_Migration_Migrator->up() 
/usr/share/php/Horde/Core/Bundle.php:107
13. Horde_Db_Migration_Migrator->_doMigrate() 
/usr/share/php/Horde/Db/Migration/Migrator.php:102
14. Horde_Db_Migration_Base->migrate() 
/usr/share/php/Horde/Db/Migration/Migrator.php:182
15. NagUpgradeCategoriesToTags->up() 
/usr/share/php/Horde/Db/Migration/Base.php:121
16. NagUpgradeCategoriesToTags->select() 
/var/www/horde/nag/migration/10_nag_upgrade_categoriestotags.php:48
17. Horde_Db_Migration_Base->__call() 
/var/www/horde/nag/migration/10_nag_upgrade_categoriestotags.php:48
18. call_user_func_array() /usr/share/php/Horde/Db/Migration/Base.php:86
19. Horde_Db_Adapter_Base->select()
20. Horde_Db_Adapter_Base->execute() 
/usr/share/php/Horde/Db/Adapter/Base.php:405
21. PDO->query() /usr/share/php/Horde/Db/Adapter/Base.php:551

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


i don't care if i lose my config, i just need to maintain the turba database