Frequently Asked Questions: script questions: phpfanbase troubles: page: 3
-
1
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).
May 21, 2004 | 
By Sasha | 
Filed under FA-PHPHosting: Troubles, FAQ, Flinx: Troubles, PHPCalendar, PHPCurrently, PHPFanBase: Troubles, PHPQuotes, Scripts
-
2
I get the following error when running create.php: “Table ‘fanlisting_u’ already exists”.
This means exactly what it says. There already is a table with that name in your database. As instructed in config.php, you need to give the tables for each FL a unique name. You cannot use the same name more than once. So, instead of leaving them at fanlisting and fanlisting_u, try renaming them to subject and subject_u, and substitute the word subject for something that applies only to your fanlisting. For example, if you ran the Brad Pitt fanlisting, you could name them bradpitt and bradpitt_u. These names need to be unique, otherwise you get this error.
If you gave them unique names and you?¢‚Ǩ‚Ñ¢re still getting this error, it means this is not the first time you?¢‚Ǩ‚Ñ¢re running this file. If you have already installed the script and you want to re-install it, you need to log into phpMyAdmin and delete the tables before re-installing it. Or alternatively, name the tables in config.php something else again.
May 21, 2004 |
By Sasha |
Filed under FAQ, PHPFanBase: Troubles, Scripts
-
3
I just put all my members in batchmembers.php and tried to run it, but I get 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 ” at line ##”.
This means you made a mistake somewhere in your file when adding the members to it. Most likely, you either forgot a comma ( , ) or apostrophe ( ‘ ) somewhere, you used an apostrophe in a member name or favorite and forgot to put a backslash ( \ ) in front of it to escape it, or you forgot to change the comma after the last member to a semi-colon ( ; ).
Check your file very very carefully, and try running it again.
May 21, 2004 |
By Sasha |
Filed under FAQ, PHPFanBase: Troubles, Scripts
-
4
I just put all my members in batchmembers.php and tried to run it, but I get the following error: “Column count doesn’t match value count at row 1″.
This means you forgot to put a certain field in somewhere in your batch members file. Every line for each member should have 9 sets of “‘..’,” if you enabled favorites, and 8 if you didn’t. Double check your lines to make sure you didn’t forget a set of ”, somewhere, or accidentally deleted a ‘.
This error will also occur if you use the wrong part of the script – don’t use the part for a favorite field if you don’t have one and vice versa.
May 21, 2004 |
By Sasha |
Filed under FAQ, PHPFanBase: Troubles, Scripts
-
5
I keep getting the following error: “Warning: Cannot add header information – headers already sent…”!
This is usually caused by either your header.inc file or your config.php file. Try deleting all white lines (spaces, blank lines, etc.) and HTML code from header.inc. In config.php, make sure there are no white lines, spaces or HTML code before and after the opening <? and ?>. If that doesn’t work, try uploading the original, unedited config.php (with your MySQL information in it though!), header.inc and footer.inc that came with the script. If that doesn’t work either, post a message at the Forums. We’ll try to help you solve this as best as we can.
May 21, 2004 |
By Sasha |
Filed under FA-PHPHosting: Troubles, FAQ, Flinx: Troubles, PHPCalendar, PHPCurrently, PHPFanBase: Troubles, PHPQuotes, Scripts
