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/8f4f07cd
