Database only viewable by forum administratorThis error generally is only shown to "non admin's", as the admin's should always see the full error (hence the error message); if for whatever reason you're getting this error and are an admin (perhaps you're logged out) there are a couple of options.
If you have CP Access and Error Logging EnabledCP -> Tools & Info -> Logs -> View SQL Errors Tab
Select the log you would like to view, this will show you exactly what the logged errors with MySQL are, so that you can determine if you're having a server or script problem.
If you don't have CP Access or Error Logging EnabledEdit the libs/mysql.inc.php file, at about line you'll see:
// IF YOU SET THE VARIABLE BELOW TO 1 IT WILL SHOW THE SQL ERRORS TO ALL
// USERS. USEFUL IF YOU CANNOT LOG IN AND NEED TO SEE THE SQL ERRORS
$showerror = 0;
Change this to
// IF YOU SET THE VARIABLE BELOW TO 1 IT WILL SHOW THE SQL ERRORS TO ALL
// USERS. USEFUL IF YOU CANNOT LOG IN AND NEED TO SEE THE SQL ERRORS
$showerror = 1;
And upload the file back to your server; any error logs at this point will be in plain text and will not provide the DB Errors Admin Only message as above. We highly advise changing this back once your error is determined and fixed for security/consistency sake.
To enable MySQL Error Logging from within UBB.ThreadsThis is fairly easy to do, first you'll need to create a directory to house your logs, and you'll need to make it writable by your webserver (chmodded 777 in *nix environments).
For this example, we'll assume that the FULL PATH to this directory is /home/ubbcentral.com/logging/ (or c:/htdocs/ubbcentral.com/logging/)
Visit the Logging page in your control panel (CP -> Master Settings -> Primary Settings -> Logging Tab) and insert the full path to the logging directory you have created, and tick the "Log MySQL Errors" checkbox; be sure to "test" the directory to ensure it passes the check (to ensure the webserver can write to it).
Now, when an error is encountered, it will be written to an error log.
What to do with errors?Well, this depends, if it's a UBB error, then you'll want to post it here as a support or bug thread. If it's a server error (such as your server killing the connection to the mysql server, that's more an issue for your webhost).
Previous Topic
Index
