Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
2 registered (David Dreezer, ntdoc), 32 Guests and 15 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 01/19/08
Posts: 85
Top Posters (30 Days)
Ruben Rocha 105
Rick 80
Mark S 71
Thelockman 58
Gizmo 55
driv 35
ntdoc 32
Sirdude 32
packlite 24
AllenAyres 22
Latest Photos
bear test
Beach Barbie-Q
Sunset
Accept the challenge!
Trees
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: 1901
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: 4176
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: 1901
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: 1901
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: 1901
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: 1901
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: 2122
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: 1901
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: 7991
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: 7991
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
Anoneguy
Recent Topics
Chaging the "max online" number and date
by wanted
Today at 02:22 PM
7.4.1. In Threaded Mode - "Mark All Read" Doesn't Work
by packlite
Today at 10:26 AM
Custom island with sql connection
by Robje01
Today at 09:13 AM
Arabic letters test
by Cowabanga
Today at 04:47 AM
Error Message
by Boyzone-Online
Yesterday at 03:14 PM
Forum Stats
4296 Members
33 Forums
30685 Topics
155995 Posts

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