Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
3 registered members (Ruben, Gizmo, M4TT), 61 guests, and 253 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
TGCsanderson
TGCsanderson
Hackelton U.K.
Posts: 67
Joined: September 2007
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 14
FREAK 11
M4TT 10
mmkk 5
Ruben 5
isaac 4
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
Errors and Solutions #193558
07/31/07 07:14 PM
07/31/07 07:14 PM
Joined: Jun 2006
Posts: 16,784
Portland, OR; USA
Gizmo Online tapedshut OP
UBB.threads Developer
Gizmo  Online Tapedshut OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,784
Portland, OR; USA
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.
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
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: Errors and Solutions [Re: Gizmo] #193559
07/31/07 07:28 PM
07/31/07 07:28 PM
Joined: Jun 2006
Posts: 16,784
Portland, OR; USA
Gizmo Online tapedshut OP
UBB.threads Developer
Gizmo  Online Tapedshut OP
UBB.threads Developer
Joined: Jun 2006
Posts: 16,784
Portland, OR; USA
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.
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!

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Shout Box Sound Effect
by M4TT. 11/29/17 08:28 PM
Ad island
by TGCsanderson. 11/25/17 06:41 PM
Taking to long to connect to DB
by AstroCat. 11/24/17 12:34 PM
I want to update forum but can't find license
by dimaninc. 11/23/17 10:51 AM
Forum Statistics
Forums36
Topics35,014
Posts190,532
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)