OoO Vers la fin de l'après-midi du samedi 22 janvier 2011, vers 16:23, bubulak <v...@radiolan.sk> disait :
> I tried following steps but for user roundcube seams to not be working. mysql> show table status > BEGIN > source /usr/share/dbconfig-common/data/roundcube/upgrade/mysql/0.5-1 > show innodb status > ROLLBACK > ; Sorry, the actual stuff that you need to type is : BEGIN; source /usr/share/dbconfig-common/data/roundcube/upgrade/mysql/0.5-1 show innodb status; ROLLBACK; > ALTER TABLE `messages` DROP FOREIGN KEY `user_id_fk_messages` > Cannot find a constraint with the given id user_id_fk_messages. The upgrade file seems to have been half played. Or maybe the foreign key never existed. Do you remember what is the first version of roundcube that you did install? Is it 0.3.1 or an earlier version? To solve your problem, the easiest way would be to play 0.5-1 upgrade file by hand into the mysql interpreter. Ignore any error that you could get in the process. -- I WILL NOT TRADE PANTS WITH OTHERS I WILL NOT TRADE PANTS WITH OTHERS I WILL NOT TRADE PANTS WITH OTHERS -+- Bart Simpson on chalkboard in episode 7F05
pgppGwdB4GuXz.pgp
Description: PGP signature
