authors table check on MySQL info section

Posted: Sat May 28, 2005 11:24 pm

Great script as usual, i found one minor glitch that could relate to only a particular setup but in any case the MySQL info page would show an error about not being able to read the authors db table, in my case for it to work i had to edit the info_mysql.php file, specifically line 76 which i changed from:

Code:

$query = "SELECT * from ".$dbname.".".$prefix."_authors";

to:

Code:

$query = "SELECT * from ".$prefix."_authors";

thought i would post it in case anyone else had the same problem.

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Strange. it should work in all instances. How about

Code:

$query = "SELECT * from `".$dbname."`.".$prefix."_authors";

If not, what kind of an error is being thrown?

Posted: Sun May 29, 2005 10:36 am

The last one worked.