OoO En ce doux début de matinée du mercredi 16 février 2011, vers 08:09, Laurens Blankers <laur...@blankersfamily.com> disait :
>> Did you get an error while upgrading? The contactgroups table is
>> present in the upgrade table. Another user said that the upgrade failed
>> because of user_identities_index was already present. It seems that you
>> have the same problem. Could you look at this file:
>> /usr/share/dbconfig-common/data/roundcube/upgrade/mysql/0.5-1
>>
>> Search for "user_identities_index" and execute all the lines which are
>> after this one. I think this should fix your installation.
> Thanks for the fast reply.
> I didn't notice any obvious error messages during the upgrade, but it is
> possible I overlooked them. Executing the commands as you suggested does
> indeed solve the problem.
> Except for a few details: When I compared the table in my database to
> the install script in dbconfig-common I noticed that the tables
> identities, cache, messages, and contacts are missing the "ON DELETE
> CASCADE ON UPDATE CASCADE" on the foreign key constraint.
> This isn't a problem for me, but it may be on sites with a large number
> of users.
In the 0.5-1 upgrade file, there is some ALTER TABLE ... FOREIGN KEY
... ON DELETE CASCADE ON UPDATE CASCADE. I think the whole file was
played in a transaction which rolled back. Could you execute them as
well and see if this fixed your issue?
In the mean time, I will move away the ADD INDEX into another location.
--
panic("CPU too expensive - making holiday in the ANDES!");
2.2.16 /usr/src/linux/arch/mips/kernel/traps.c
pgpzZlGQWvpfV.pgp
Description: PGP signature
