Frequently Asked Questions
Create.php error?
-
Create.php error?
Posted on May 21, 2004
Written by
Sasha (view more by Sasha)
Filed under FA-PHPHosting: Troubles, FAQ, Flinx: Troubles, PHPCalendar, PHPCurrently, PHPFanBase: Troubles, PHPQuotes, Scripts
I get an error similar to this when I run create.php: “You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use.”
You most likely used a number as your table name. MySQL table names cannot consist of only numbers and cannot begin with numbers, so try adding a letter to it in config.php, and then run create.php again.
It’s also possible that you used a MySQL reserved word as the table name. This is not allowed either. A list of reserved words can be found here (scroll down).