Errors and Solutions · Blog

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 By Gremelin Posted on July 31, 2007

Comments

( Posted)
Request a Quote
Please feel free to Request a Quote at any time.

By requesting a quote you allow us to adjust pricing for your product on a per-project basis. Note that most of the prices on our pricing page are just our "common" pricing and can vary on a per project basis. It will also allow us to add any per project discounts where we see fit (non-profit organizations, affiliations, etc).

If your "type" of project isn't listed in our menu's to the left, please Request a Quote; we can do much more than what is listed however building pages for it all would take a great while.
Hosting
We utilize BlueHost and StableHost for the hosting of our all of our Virtual Private Servers, the go to hosts that we recommend to every one of our clients, friends, and family. For more Web Hosting recommendations, please see our Recommended Hosts page!

StableHost Web Hosting
Buy Us a Coffee