Previous Thread
Next Thread
Print Thread
Hop To
Joined: Oct 2007
Posts: 92
L
journeyman
journeyman
L Offline
Joined: Oct 2007
Posts: 92
When I try to go to my forum, following error apears.
Database error only visible to forum administrators
What to do? Please help frown

url: click

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
This error is mentioned numerous times with the search option; quite simply, edit libs/mysql.inc.php, change the "showerror" line from a 0 to a 1, upload file; it will now show the error to anyone who can see it.

You'll want to change this back when you're finished however, as it could identify db names and other data your users don't really need...


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.
Do you need Forum Install or Upgrade Services?
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!
Joined: Jun 2006
Posts: 3,837
I
Ian Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
Your site seems to be okay now - any further issues, let us know smile

Joined: Oct 2007
Posts: 92
L
journeyman
journeyman
L Offline
Joined: Oct 2007
Posts: 92
The site has been unavailable every day since then, only early in the morning.

Going to make a puppy face and ask blaaskaak again to take a look at it blush


Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
If you follow Gizmo's steps or turn on MySQL Error logging in the control panel you can at least figure out exactly what's going on. Once we know the actual error we should be able to give proper advice.

Joined: Oct 2007
Posts: 92
L
journeyman
journeyman
L Offline
Joined: Oct 2007
Posts: 92
MySQL Error logging apparently was already turned on.
This is the error producing between 5 and 7 am:
Script: - Line: Unable to connect to the database! - Too many connections

Joined: Jun 2006
Posts: 3,837
I
Ian Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
Are you on a shared server and not a dedicated server?

If so I would get in touch with your host and advise them of the error.

Joined: Jul 2006
Posts: 2,143
Pooh-Bah
Pooh-Bah
Joined: Jul 2006
Posts: 2,143
Or they are using pconnect and have more apache children than mysql connections allowed. Make sure pconnect is UNCHECKED in the control panel.


This thread for sale. Click here! [Linked Image from navaho.infopop.cc]
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Yeh, pconnect is evil... Too bad we can't make it so they have to edit the config file by hand to enable it; so random users just don't turn it on...

Not to mention, the error is not UBB related, it is your MySQL server choking; it's either the pconnect issue, or your server is over-loaded at this timeframe and mysql is struggling to stay alive.


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.
Do you need Forum Install or Upgrade Services?
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!
Joined: Oct 2007
Posts: 92
L
journeyman
journeyman
L Offline
Joined: Oct 2007
Posts: 92
Thanks for the info!

Can't the pconnect option, where is it located?

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
in the control panel, it'll be where your MySQL data resides.
Master Settings >> DB, Paths & URLs >> Use Persistent Connections?


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.
Do you need Forum Install or Upgrade Services?
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!
Joined: Jul 2006
Posts: 2,143
Pooh-Bah
Pooh-Bah
Joined: Jul 2006
Posts: 2,143
pconnect is in no way evil. It's great *IF* you know how to use it. The mantra that pconnect is evil that some of the moderators chat around here is pretty tiring.


This thread for sale. Click here! [Linked Image from navaho.infopop.cc]
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
The fact that users utilize it on overloaded vhosted servers is amusing wink...


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.
Do you need Forum Install or Upgrade Services?
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!

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
3 members (rootman, Gizmo, Nightcrawler), 562 guests, and 186 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)