Previous Thread
Next Thread
Print Thread
Hop To
Errors and Solutions #193558 07/31/2007 8:14 PM
Joined: Jun 2006
Posts: 15,851
Gizmo Offline OP
UBB.threads Developer
OP Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,851
This thread will take on various possible error messages and their solutions on a case basis.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Express Hosting
Re: Errors and Solutions [Re: Gizmo] #193559 07/31/2007 8:28 PM
Joined: Jun 2006
Posts: 15,851
Gizmo Offline OP
UBB.threads Developer
OP Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,851
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).


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
visual accessibility issues.v7.7.3
by Ruben - 08/21/2019 1:50 PM
Holy grail to fix compatibility bewteen browsers
by Ruben - 08/20/2019 4:25 PM
File Manager and Image Uploads
by Ty Griffin - 08/19/2019 4:48 PM
Minimum Post Character Count
by M4TT - 08/19/2019 1:58 PM
[FIXED for 7.7.4] Strange Merge Issue
by Baldeagle - 08/16/2019 3:37 PM
Who's Online Now
2 registered members (JAISP, Daryl Fawcett), 52 guests, and 254 spiders.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Photos
Stones
Amusing Terain Scenics
Sky places
Work spaces
Powered by UBB.threads™ PHP Forum Software 7.7.3