Errors and Solutions

This thread will take on various possible error messages and their solutions on a case basis.

Database only viewable by forum administrator
This 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 Enabled
CP -> 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 Enabled
Edit the libs/mysql.inc.php file, at about line you'll see:
Code
// 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
Code
// 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.Threads
This 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).
Posted on July 31st, 2007

Comments

( Posted)
For the best viewing experience please update your browser to Chrome, Firefox, or Opera