I got MySQL errrors on step 2 of 3 of Vanilla installation

Pifman

I just had my hosting company setup a MySQL database, so please take note that I'm only trying to figure out the problem - and don't really understand MySQL myself. Anything posted in this thread I'll relay to the guy who set it up. Thanks.

While I was installing Vanilla, I entered in all the MySQL details on step 2 of 3 such as Server, Database Name, Username and Password. It gave me an error that read:

We came across some problems while setting up Vanilla...

An error occurred while we were attempting to create the database tables. MySQL reported the following error:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARACTER SET utf8' at line 1

QUERY: CREATE TABLE `LUM_Category` (`CategoryID` int(2) NOT NULL auto_increment,`Name` varchar(100) NOT NULL default '',`Description` text NULL,`Priority` int(11) NOT NULL default '0',PRIMARY KEY (`CategoryID`)) DEFAULT CHARACTER SET utf8;

I sent the error message to my hosting guy and he replied:

That is strange. The version of MySQL we're running is 4.0.24, and the minimum required version for Vanilla is supposed to be 3.23: http://getvanilla.com/#ServerRequirements

I don’t see any bug reports or FAQs regarding this problem, maybe you could try posting on their help discussion and see if one of the developers would reply?

I managed to get the query to work in a test database by removing the word “DEFAULT”:

CREATE TABLE `LUM_Category` (`CategoryID` int(2) NOT NULL auto_increment,`Name` varchar(100) NOT NULL default '',`Description` text NULL,`Priority` int(11) NOT NULL default '0',PRIMARY KEY (`CategoryID`)) CHARACTER SET utf8;

Any ideas on how to get this resolved would be very appreciated, thanks.

x00

mysql 4.0 had some very odd behaviours, I managed to use unexpected bugs to my advantage because it doesn't support certain things. 4.1 is more stable ant the one that is documented. If you look at the docs for 4.1 CREATE TABLE syntax: http://dev.mysql.com/doc/refman/4.1/en/create-table.html it has DEFAULT I would actually recommend MySQL 5+ though. MySQL is basically no longer supporting before then except for security critical issues.

Dinoboff

Sorry Pifman about that, I will post the patch in a few minute.

You are welcome to open an issue there: http://code.google.com/p/lussumo-vanilla/issues/list

issue #3

Dinoboff

Try to replace setup/mysql.sql with: http://dl.getdropbox.com/u/83967/vanilla/mysql.sql

Pifman

Thanks for all the fast feedback so far guys. I'll look into your suggestions and get back to you ASAP.