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 "
mysqldump --no-data --tables -uroot -p roundcubewebmail >> schema_03.sql
when applying diff to this files this is what I am getting:
[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.