Wow, this is getting strange.
I believe (and hope) that problem with patch file is separate from MySQL shutting down by itself. And what does MySQL server logs (not JBoss) say, what was the reason of shut down?
As for locale problem, let us give it a try with these:
1. As MySQL root user
* Create a new database
CREATE DATABASE lams_test DEFAULT CHARACTER SET utf8;
USE lams_test;
* Create a table with the same structure
CREATE TABLE lams_supported_locale (
locale_id INTEGER NOT NULL AUTO_INCREMENT
, language_iso_code VARCHAR(2) NOT NULL
, country_iso_code VARCHAR(2)
, description VARCHAR(255) NOT NULL
, direction VARCHAR(3) NOT NULL
, fckeditor_code VARCHAR(10)
, PRIMARY KEY (locale_id)
)ENGINE=InnoDB;
* Try to manually load the patch
mysql -u root -p<ROOT_PASSWORD> lams_test < patch02040009.sql
* Let us know what the server said
2. Can you attach output of MySQL command
SHOW VARIABLES;
Maybe there is no encoding handshake between client and server.
3. Can you download HEAD of LAMS from CVS instead of lams2_4 tag and give it a try? Maybe it is an error that has been already fixed, we just need to find when.
Posted by Marcin Cieslak
