Author Topic: problem upgrading mysql database from 0.3-stable to 0.4-stable  (Read 2088 times)

Offline esplinter

  • Newbie
  • *
  • Posts: 2
problem upgrading mysql database from 0.3-stable to 0.4-stable
« on: September 08, 2010, 03:00:21 PM »
hi,

I have tried to upgrade from 0.3-stable to 0.4-stable but I am getting problems to upgrade my mysql database.

As explained in the docs I have applied the four mysql queries needed to upgrade from 0.3-stable to 0.4-stable described in the file "SQL/mysql.update.sql". All the mysql queries finished ok but when I run the update.sh script I still get the error "WARNING: Database schema needs to be updated!"

I couldnĀ“t find the reason. In case it is useful for debugging I attach my database schema before upgrade (0.3) and after upgrading it to 0.4. I have taken this databases schemas using "

Code: [Select]

mysqldump --no-data --tables -uroot -p roundcubewebmail >> schema_03.sql


when applying diff to this files this is what I am getting:

Code: [Select]

[root][raphael][/tmp]$ colordiff db_schema_03_before_upgrade.txt db_schema_04_after_upgrade.txt
56a57
>   KEY `user_contacts_index` (`user_id`,`email`),
111a113
>   KEY `index_index` (`user_id`,`cache_key`,`idx`),
113c115
< ) ENGINE=InnoDB AUTO_INCREMENT=260 DEFAULT CHARSET=utf8;
---
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
128c130
<   `vars` text NOT NULL,
---
>   `vars` mediumtext NOT NULL,


many thanks for any help.