Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
2 Registered (Anrui, driv), 24 Guests and 29 Spiders online.
Key: Admin, Global Mod, Mod
Top Posters
Gizmo 11678
Rick 7551
Ian 4102
Mark S 3969
ntdoc 3102
Sirdude 2041
jgeoff 1876
David Dreezer 1750
driv 1557
AllenAyres 1523
Latest Photos
Carrie - So Very
Testing
Test Photo
4TH of July at the river!
Test shots from D300 part 3
Topic Options
Rate This Topic
#215667 - 07/21/08 04:13 PM Having a problem with crashed table...
jgeoff Offline
Pooh-Bah

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

I assume this is a server issue? Been having some issues the past hour or two

At this point, my forums load -- but when I enter a specific forum, I get this:
Quote:
UBB Message
We encountered a problem. The reason reported was

Script: /home/gbb/public_html/threads/scripts/postlist.inc.php
Line#: 520
SQL Error: Table './gbb_threads/ubbt_POSTS' is marked as crashed and last (automatic?) repair failed
SQL Error #: 144
Query: select t1.TOPIC_ID,t1.POST_ID,t2.USER_DISPLAY_NAME,t1.TOPIC_CREATED_TIME,t1.TOPIC_LAST_REPLY_TIME,t1.TOPIC_SUBJECT, t1.TOPIC_STATUS,t1.TOPIC_IS_APPROVED,t1.TOPIC_ICON,t1.TOPIC_VIEWS,t1.TOPIC_REPLIES,t1.TOPIC_TOTAL_RATES, t1.TOPIC_RATING,t3.USER_NAME_COLOR,t2.USER_MEMBERSHIP_LEVEL,t1.USER_ID,t1.TOPIC_IS_STICKY,t1.TOPIC_LAST_POSTER_ID, t1.TOPIC_LAST_POSTER_NAME,t1.TOPIC_LAST_POST_ID,t1.TOPIC_IS_EVENT,t1.TOPIC_HAS_FILE,t1.TOPIC_HAS_POLL,t1.TOPIC_POSTER_NAME,t1.TOPIC_THUMBNAIL,t4.POST_BODY from ubbt_TOPICS as t1 left join ubbt_USERS as t2 on t1.USER_ID = t2.USER_ID left join ubbt_USER_PROFILE as t3 on t1.USER_ID = t3.USER_ID left join ubbt_POSTS as t4 on t1.POST_ID = t4.POST_ID where t1.FORUM_ID = 9 and t1.TOPIC_IS_STICKY = '0' ORDER BY t1.TOPIC_LAST_REPLY_TIME desc LIMIT 35

Please click back to return to the previous page.


When I look in phpMyAdmin it says ubbt_POSTS is "In Use" -- can I still run a Repair on it?

Before this, I was getting errors like these:
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 './gbb_threads/ubbt_USERS' is marked as crashed and should be repaired
SQL Error #: 145
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
Quote:
UBB Message
We encountered a problem. The reason reported was

Script:
Line#:
SQL Error: Too many connections
SQL Error #: 1040
Query: Unable to connect to the database!
Quote:
UBB Message
We encountered a problem. The reason reported was

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


HTTP and MySQL went down a few times during this time as well. Web host said they tried repairing a few times to no avail...
_________________________
GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Firefox 3.0 & Safari 3.1 (XP and iPhone)

Top
#215669 - 07/21/08 04:21 PM Re: Having a problem with crashed table... [Re: jgeoff]
Sirdude Offline


Registered: 04/19/07
Posts: 2041
Loc: SoCal, USA
yah, you can run a repair on it.. but its looking like you are in a shared environment and mysql ain't keeping up ?

also, repairing the POST table is tough for large tables in shared environs.. not sure how your host has things setup..
_________________________

A taxpayer voting for Obama is like a chicken voting for Colonel Sanders.

Top
#215671 - 07/21/08 04:37 PM Re: Having a problem with crashed table... [Re: Sirdude]
jgeoff Offline
Pooh-Bah

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

Maybe I should finally just have you host me! laugh

Trying the Repair again. It lost connection the first time. :/
_________________________
GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Firefox 3.0 & Safari 3.1 (XP and iPhone)

Top
#215672 - 07/21/08 04:39 PM Re: Having a problem with crashed table... [Re: jgeoff]
jgeoff Offline
Pooh-Bah

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

...and again. :/
_________________________
GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Firefox 3.0 & Safari 3.1 (XP and iPhone)

Top
#215673 - 07/21/08 04:43 PM Re: Having a problem with crashed table... [Re: jgeoff]
jgeoff Offline
Pooh-Bah

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

Originally Posted By: ASO
Unfortunately we are currently experiencing MySQL issues with that server. Our admins are aware of the issue and are working hard to correct it. We apologize for the inconvenience and appreciate your patience.


Guess I'll just wait it out and hope for the best!
_________________________
GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Firefox 3.0 & Safari 3.1 (XP and iPhone)

Top
#215674 - 07/21/08 04:46 PM Re: Having a problem with crashed table... [Re: jgeoff]
Sirdude Offline


Registered: 04/19/07
Posts: 2041
Loc: SoCal, USA
_________________________

A taxpayer voting for Obama is like a chicken voting for Colonel Sanders.

Top
#215693 - 07/21/08 06:40 PM Re: Having a problem with crashed table... [Re: Sirdude]
jgeoff Offline
Pooh-Bah

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

ARGH! It's still not fixed and no updates from the host yet. :/

Shout Box works... PMs work... cfrm works... Just not postlist...
_________________________
GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Firefox 3.0 & Safari 3.1 (XP and iPhone)

Top
#215694 - 07/21/08 06:44 PM Re: Having a problem with crashed table... [Re: jgeoff]
jgeoff Offline
Pooh-Bah

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

Does anyone think any of the Content Rebuilder tools might help? I'm afraid.

Control Panel front page just also shows me
Quote:
Control panel message
Script: /home/gbb/public_html/threads/admin/login.php
Line#: 232
SQL Error: Table './gbb_threads/ubbt_POSTS' is marked as crashed and last (automatic?) repair failed
SQL Error #: 144
Query: SELECT COUNT(t1.POST_ID) FROM ubbt_POSTS as t1, ubbt_TOPICS as t2 WHERE t1.POST_IS_APPROVED = '0' and t1.TOPIC_ID = t2.TOPIC_ID
_________________________
GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Firefox 3.0 & Safari 3.1 (XP and iPhone)

Top
#215696 - 07/21/08 06:54 PM Re: Having a problem with crashed table... [Re: jgeoff]
Sirdude Offline


Registered: 04/19/07
Posts: 2041
Loc: SoCal, USA
content rebuilder won't help you. it assumes there's a non-crashed table to rebuild wink
_________________________

A taxpayer voting for Obama is like a chicken voting for Colonel Sanders.

Top
#215702 - 07/21/08 09:39 PM Re: Having a problem with crashed table... [Re: Sirdude]
jgeoff Offline
Pooh-Bah

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

*Whew*

After only about 6 hours, they got it back up and running.

:rolleyes:
_________________________
GangsterBB.NET (Ver. 7.3)
2007 Content Rulez Contest - Hon Mention
UBB.classic 6.7.2 - RIP
Browsers: Firefox 3.0 & Safari 3.1 (XP and iPhone)

Top


Moderator:  Gizmo 
Shout Box

Recent Topics
Anyone tested threads with IE8
by Ian
Today at 09:04 AM
Community Spotlight
by Thelockman
Yesterday at 08:04 AM
Protecting Board from hackers
by duquesne
Yesterday at 04:48 AM
Change New Topic text
by MLD
08/25/08 04:59 PM
Reason for deleting a thread
by MattUK
08/24/08 09:40 PM
Forum Stats
4017 Members
33 Forums
30845 Topics
156628 Posts

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