Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Try Vanilla Forums Cloud product
Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.

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

edited April 2009 in Vanilla 1.0 Help
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.

Comments

Sign In or Register to comment.