On Fri, 15 Oct 2010 17:56:12 +0100, Viktor Balogh wrote:
Hi,
but when i run SQL/mysql.upgrade.sql as root, it show the error like this:
root#: mysql roundcubedb < mysql.upgrade.sql ERROR 1091 (42000) at line 7: Can't DROP 'idx'; check that column/key exists
What shall i do now?
I've ran into the same error just like you. You shouldn't import the whole contents of the mysql.update.sql file, but only the sections which are relevant to you. See the comment statements in the file:
# grep -e "^--" mysql.update.sql -- RoundCube Webmail update script for MySQL databases -- Updates from version 0.1-stable -- Updates from version 0.1.1 -- Updates from version 0.2-alpha -- Updates from version 0.2-beta (InnoDB required) -- Updates from version 0.3-stable -- Updates from version 0.3.1 -- Updates from version 0.4-beta #
Regards, Viktor
Yes, i cut down the upgrade script to only have 0.4-beta to below. i can run the mysql.upgrade.sql script now. no any error.
but i still can not save the "Display Name", and the error message still like before.
List info: http://lists.roundcube.net/dev/ BT/aba52c80