Mysql Error

Posted: Fri May 11, 2007 8:25 am

I am having problems trying to set up a test site for the new version. I get to the setup page just fine. My config file is good to go. It is just the core tables that will not load. This is the error I get below. Please help. This is the version of mysql that my host uses.-> MySQL version 4.1.21-standard I also wanted to add that i cannot even do a manual upload of the core sql file. I get this error. Very strange it will load everything except the core tables.???

Code:

Error





SQL query:





DROP TABLE IF EXISTS $prefix.`_authors` ;





MySQL said: Documentation


#1142 - DROP command denied to user 'hvbndcgz'@'localhost' for table '_authors'

Code:

 The exact error message that your MySQL server reported is:


MySQL Error # 4 = 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 1

Site Admin Joined: Jun 04, 2004 Posts: 6433

The SQL message says it all - it's trying to delete the _authors table, but the database user isn't authorized to do that. You can either delete / rename the tables in question or give the user access to the drop command.

registered · Posted: Tue Dec 11, 2007 8:26 am

I'm getting the same error in mysql and in the installsql.php file below.

Fatal error: Call to undefined function gzfile() in /house/me/public_html/..../INSTALLATION/installSQL.php on line 290

I have full permissions to my database.

I have tried to add manually. I still get rejected and cannot create, edit, drop the tables.

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

Your error is not the same. The original user was being denied the permission to DROP a table (DROP command denied to user). Although the end result is the same, you are erring out on a missing function (Call to undefined function gzfile()). This probably means your host has not compiled PHP with the ZLIB functions. Save this script to zlibchk.php, ftp it to your server, and run it. It will either display Yes or No. Yes means it is loaded and means there is still a problem. No means your host does not have it compiled in PHP. You will need to request that they recompile PHP with the ZLIB option. Zlib support in PHP is not enabled by default. You will need to configure PHP --with-zlib[=DIR]

You could also try dynamic loading the zlib.so file using the php function dl('zlib.so');

Code:

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.1//EN">


<html>


<head>


<title></title>


</head>


<body>


<?= extension_loaded('zlib') ? '<b><font color="green">Yes</font></b>' : '<b><font color="red">No</font></b>';?>


</body>


</html>

Posted: Tue Dec 11, 2007 10:38 am

Usually the database user is set up in cPanel or vDeck or another "panel" type program that your host provides. You need to go in there and check out the privileges that user hvbndcgz has to that database. You want it to have all privileges and it apparently doesn't. gzfile is a standard PHP function. You can find it in the PHP manual. If it's not working you need to contact your host.

edit: live and learn. see Raven's reply on gzfile and ignore mine Smile