Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#33 Error on install

closed
easygo
None
5
2009-03-04
2009-02-03
Anonymous
No

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

Discussion

  • easygo
    easygo
    2009-02-04

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

    Regards

     
  • easygo
    easygo
    2009-02-04

    • assigned_to: nobody --> net4seven
     
  • 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
    easygo
    2009-02-05

    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.

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

    Thanks a lot!!

     
    • status: open --> closed