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 -- Visit my panoramic photoblog! http://vrphoto.hu Spherical panoramas by Viktor Balogh _______________________________________________ List info: http://lists.roundcube.net/dev/ BT/8f4f07cd
