SimplePortal

Support => Install and Upgrade => Topic started by: poy on October 03, 2009, 12:00:36 PM

Title: Database error... You have an error in your SQL syntax
Post by: poy on October 03, 2009, 12:00:36 PM

I'm getting this error after trying to do a fresh install of SimplePortal 2.3 on a fresh SMF 1.1.10  :(

Database 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 'CONVERT TO CHARACTER SET utf8' at line 2
File: /.../Packages/temp/install1-1.php
Line: 468

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.10, while your database is at version 1.1.9. The above error might possibly go away if you execute the latest version of upgrade.php.

I didn't had this problem before with my other website

Thank you

Title: Re: Database error... You have an error in your SQL syntax
Post by: poy on October 03, 2009, 09:01:52 PM

If you're getting this exact problem, don't install your smf forum through fantastico...

Do the manual install...It worked for me :nervous-happy:

Title: Re: Database error... You have an error in your SQL syntax
Post by: Nathaniel on October 04, 2009, 01:10:43 AM

Glad to hear that you got it working. :)

Marked as solved.