thanks ... that was it ...
i just make mysqldump with --no-create-info --no-create-db
--skip-add-drop-table, then remove completly roundcube 0.3.1-6, drop db
, drop user, install 0.3.1-6 again and import only values from sql dump.
and finaly upgrade to 0.5-2 works without error
once again thank for help
best regards
vlado
On 01/22/2011 05:32 PM, Vincent Bernat wrote:
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.
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
