Frequently Asked Questions
Table already exists?
-
Table already exists?
Posted on May 21, 2004
Written by
Sasha (view more by Sasha)
Filed under FAQ, PHPFanBase: Troubles, Scripts
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.