hello, On 10/5/07, G T Smith <grahamsmith@gandalfsemporium.homelinux.com> wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
SuSE 10.2
Did an update today including MySQL security updates.
Found MySQL had failed to reload for some reason. Restarted MySQL and got a a duplicate column error message when an attempt to update the mysql database tables was applied. (unfortunately, error message went before I could take notes and nothing in logs). Nothing seems to broken but unable to repeat error (I suspect because the database schema update has now been flagged as applied).
Because there is an issue with funambol I am running MySQL with case sensitivity disabled...
As I do not think this is a change applied at the MySQL end (the mysql schema is reasonably consistent across platforms and if this is a case of two columns differing by case this it would generate problems on Windows) I am not sure whether the update has been applied a second time for some reason (then I need not worry) or there has been a change and I should have two columns lexically differing only on case or replaced.
Has anyone noticed anything similar?
yes, I have something similar. After I did the update from 10.2 to 10.3 mysql doesn't work. It seems that the databases and the tables are ok, the mysql is starting, but when I tried wordpress, mambo, mysql.log tells me that mysql restarted during a SELECT. I tried this SELECT command also in mysql command line, also in phpmyadmin, but I got the same error and mysqld restarted. I don't know how to fix that. thanks, -- === Ioan Vancea http://www.vioan.ro -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org