[Pkg-roundcube-maintainers] Bug#610725: roundcube 0.5-1 upgrade from 0.3.1-6
vb at radiolan.sk
Sat Jan 22 17:48:45 UTC 2011
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
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<vb at radiolan.sk> disait :
>> I tried following steps but for user roundcube seams to not be working.
> mysql> show table status
>> source /usr/share/dbconfig-common/data/roundcube/upgrade/mysql/0.5-1
>> show innodb status
> Sorry, the actual stuff that you need to type is :
> source /usr/share/dbconfig-common/data/roundcube/upgrade/mysql/0.5-1
> show innodb status;
>> 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.
More information about the Pkg-roundcube-maintainers