#33 Error on install

[Anonymous]

I downloaded the AjaxChat for integration with a SMF forum. I unzipped and uploaded the files to a directory in my forum's root directory and then ran install.php. I received the following error:

Query: CREATE TABLE ajax_chat_online ( userID INT(11) NOT NULL, userName VARCHAR(64) NOT NULL, userRole INT(1) NOT NULL, channel INT(11) NOT NULL, dateTime DATETIME NOT NULL, ip VARBINARY(16) NOT NULL ) DEFAULT CHARSET=utf8 COLLATE=utf8_bin; Error-Report: 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 CHARSET=utf8 COLLATE=utf8_bin' at line 8 Error-Code: 1064

Thanks,

Gary
admin@worcreef.org

[easygo]

What's your MySQL version, and how about an update?

Regards

[Nobody/Anonymous]

I am hosting my site through 1and1.com. According to the site's MySQL admin page they are running MySQL version 4.0.

I have also posted this question on the SMF help boards, but so far have not been able to get it to work.

Gary

[easygo]

OK the current installer needs MySQL 4.1.3 or higher.

Either contact 1and1.com to get an MySQL update, or open chat/chat.sql
in your text editor and just find/replace all instances of

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

with

);

Hope this helps.

[Nobody/Anonymous]

That appears to have worked!! I got the "Database tables created successfully - please delete this file (install.php)." message.

Thanks a lot!!