Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
4 registered (cascadeclimbers, Gizmo, smallufo, Thelockman), 29 Guests and 21 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 09/18/08
Posts: 9
Top Posters (30 Days)
Ruben Rocha 179
Gizmo 112
Rick 106
Thelockman 79
driv 43
AllenAyres 35
ntdoc 28
Ian 24
Sirdude 23
ScriptKeeper 20
Latest Photos
My Home System
test photo gallery
Bernese Mountain Dogs
My Daimler
Dorado and shark
Page 1 of 3 1 2 3 >
Topic Options
Rate This Topic
#212021 - 05/13/08 08:04 AM Couldn't connect.
jgeoff Offline
Pooh-Bah

Registered: 08/08/06
Posts: 1885
Loc: NJ

I'm having major problems since yesterday. Users and myself are getting "Couldn't connect." errors -- I'm getting them constantly submitting anything in the control panel -- I can't do anything!

Check out these gems:

Quote:

UBB Message
We encountered a problem. The reason reported was

Script:
Line#:
SQL Error: User gbb_admin has already more than 'max_user_connections' active connections
SQL Error #: 1203
Query: Unable to connect to the database!

Please click back to return to the previous page.

Quote:

UBB Message
We encountered a problem. The reason reported was

Script: /home/gbb/public_html/threads/libs/user.inc.php
Line#: 434
SQL Error: Table 't1' is marked as crashed and should be repaired
SQL Error #: 1194
Query: SELECT t2.USER_TIME_OFFSET,t2.USER_TOPIC_VIEW_TYPE,t2.USER_TIME_FORMAT, t1.USER_ID, t1.USER_DISPLAY_NAME, t1.USER_PASSWORD, t1.USER_SESSION_ID, t1.USER_MEMBERSHIP_LEVEL, t1.USER_IS_BANNED,t1.USER_RULES_ACCEPTED, t1.USER_IS_UNDERAGE, t2.USER_TOTAL_PM, t2.USER_STYLE, t2.USER_HIDE_LEFT_COLUMN,t2.USER_HIDE_RIGHT_COLUMN, t2.USER_LANGUAGE, t2.USER_MOOD, t2.USER_RELATIVE_TIME, t2.USER_TIME_OFFSET,t2.USER_SHOW_ALL_GRAEMLINS, t2.USER_AVATAR, t2.USER_TITLE, t2.USER_CUSTOM_TITLE, t2.USER_NAME_COLOR, t2.USER_SHOW_LEFT_MYSTUFF FROM ubbt_USERS as t1, ubbt_USER_PROFILE as t2 WHERE t1.USER_ID = 2 AND t1.USER_ID = t2.USER_ID

Please click back to return to the previous page.

Quote:

UBB Message
We encountered a problem. The reason reported was

Script: /home/gbb/public_html/threads/scripts/activetopics.inc.php
Line#: 139
SQL Error: Got error 127 from storage engine
SQL Error #: 1030
Query: select count(t1.TOPIC_ID) from ubbt_TOPICS as t1, ubbt_FORUMS as t2 where t1.TOPIC_LAST_REPLY_TIME > 1210084688 and t1.FORUM_ID in (16,1,9,12,13,2,3,6,7,10,11,8,14,17,18,5,4,15) and t1.FORUM_ID = t2.FORUM_ID and t2.FORUM_ACTIVE_POSTS = 1 and t1.TOPIC_IS_APPROVED = 1 and t1.TOPIC_STATUS <> 'M'

Please click back to return to the previous page.



Host "repaired" the database to no avail. The board otherwise works, but these *&^$%#@#^%*&^ random (on the main site, and constant in admin) "Couldn't connect" errors upon submitting forms is killing me!! mad

What could be the problem?


Edited by jgeoff (05/13/08 11:21 AM)
_________________________
GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Firefox 3.0, Google Chrome, & Safari 3.1 (XP and iPhone)

Top
#212023 - 05/13/08 08:30 AM Re: Couldn't connect. [Re: jgeoff]
Ian Moderator Offline

***

Registered: 06/05/06
Posts: 4160
Loc: Essex, UK
Essentially you have too many people trying to connect to your database than MySQL allows.

Sadly I am not an expert on this, so will have to bow down to someone else.

I have been trying to find a good setting for my server, which is a 4GB Quad CPU machine, but to date have not found anyone to assist (the only site that seems to have anyone is a VB site and I would rather not use their service LOL)
_________________________
Fans Focus - Focusing on Fans of Sport

(Okay - mainly football (the British variety wink at the moment - but expanding all the time....))

Top
#212025 - 05/13/08 08:46 AM Re: Couldn't connect. [Re: Ian]
jgeoff Offline
Pooh-Bah

Registered: 08/08/06
Posts: 1885
Loc: NJ

6 Registered (4 invisible), 2 Guests and 18 Spiders online. :/

Making a post sometimes gives me "Cannot Connect" but the post goes through anyway -- but in control panel, I cannot successfully submit ANY form that contains data -- can't even clear cache! frown
_________________________
GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Firefox 3.0, Google Chrome, & Safari 3.1 (XP and iPhone)

Top
#212026 - 05/13/08 10:00 AM Re: Couldn't connect. [Re: jgeoff]
jgeoff Offline
Pooh-Bah

Registered: 08/08/06
Posts: 1885
Loc: NJ

Another symptom? My Who's Online island hasn't updated in forever, despite the main WOL page, and the other islands, working fine. I can't clear my cache w/o connect errors.

I'm getting really pissed off right now. mad
_________________________
GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Firefox 3.0, Google Chrome, & Safari 3.1 (XP and iPhone)

Top
#212031 - 05/13/08 10:45 AM Re: Couldn't connect. [Re: jgeoff]
jgeoff Offline
Pooh-Bah

Registered: 08/08/06
Posts: 1885
Loc: NJ

From my host:
Quote:

I was doing some testing on your site and also searching some forums, it seems you are hitting your max connections. There has to be something in your script that is not closing the connections after they are initiated or it might be the 'shout box' killing all your resources. I would reccomend taking down the shout box and seeing if you still get the "Couldn't connect" issue.
_________________________
GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Firefox 3.0, Google Chrome, & Safari 3.1 (XP and iPhone)

Top
#212032 - 05/13/08 11:06 AM Re: Couldn't connect. [Re: jgeoff]
jgeoff Offline
Pooh-Bah

Registered: 08/08/06
Posts: 1885
Loc: NJ

It wasn't the Shout Box. Guess I'll open up a ticket to rule out threads...

Edit: Crap, no credits. frown


Edited by jgeoff (05/13/08 11:08 AM)
_________________________
GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Firefox 3.0, Google Chrome, & Safari 3.1 (XP and iPhone)

Top
#212034 - 05/13/08 11:21 AM Re: Couldn't connect. [Re: jgeoff]
Sirdude Offline

*****

Registered: 04/19/07
Posts: 2077
Loc: SoCal, USA
are you using persistent connections? turn that off, if you were/are.

_________________________


Top
#212036 - 05/13/08 11:25 AM Re: Couldn't connect. [Re: Sirdude]
jgeoff Offline
Pooh-Bah

Registered: 08/08/06
Posts: 1885
Loc: NJ

No, I've never enabled that...
_________________________
GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Firefox 3.0, Google Chrome, & Safari 3.1 (XP and iPhone)

Top
#212045 - 05/13/08 12:25 PM Re: Couldn't connect. [Re: jgeoff]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7903
Loc: Aberdeen, WA
Well, since it's a max_user_connection limit, then you should be able to take a gander at every running connection and see what it's doing and if they are closing or not.

Best bet would be to do it through your host's control panel, like phpmyadmin.

Run the following SQL command and see what you get:

show processlist
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#212046 - 05/13/08 12:29 PM Re: Couldn't connect. [Re: Rick]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7903
Loc: Aberdeen, WA
Also, it might be interesting to hear what they have for your max_user_connection limit.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
Page 1 of 3 1 2 3 >


Shout Box

Today's Birthdays
No Birthdays
Recent Topics
I'm the Admin but.....
by David DelMonte
Today at 11:12 AM
Fatal error: Smarty::require_once
()

by ThreadsUser
Today at 08:17 AM
PayPal batch file for ID'ing expired and failed payment subscriptions?
by Mitch P.
Today at 06:02 AM
Shrinking graemlins
by Djuma
Yesterday at 05:48 PM
2 problems I'm seeing now.
by DougMM
Yesterday at 04:39 PM
Forum Stats
4261 Members
33 Forums
30535 Topics
154978 Posts

Max Online: 978 @ 06/24/07 08:19 PM