Previous Thread
Next Thread
Print Thread
Hop To
#250664 10/19/2012 9:19 AM
Joined: Sep 2009
Posts: 48
S
newbie
newbie
S Offline
Joined: Sep 2009
Posts: 48
Hi all,

I am getting Thread failure notices and am not sure what happened? The UBB is up and running however when you go to a particular Forum you receive an error message (for example:

Code
We encountered a problem. The reason reported was
Script: /home/content/m/o/n/[redacted]/html/pct/ubbthreads/scripts/postlist.inc.php
Line#: 478
SQL Error: Table './pctubbthreads/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,t3.USER_GROUP_IMAGES 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.TOPIC_ID IN ( 16514, 16522, 16526, 16528, 16602) ORDER BY t1.TOPIC_IS_STICKY DESC, t1.TOPIC_LAST_REPLY_TIME desc

Please click back to return to the previous page.)

Any idea what would cause this and how to repair?

Thanks in advance!

--Stephen

Joined: Jan 2008
Posts: 514
addict
addict
Joined: Jan 2008
Posts: 514
Is this a new forum created, or is it a forum that has been active a while?

If it is a forum that has been around for a bit... I would try to optimize the tables and make sure there aren't any issues with the DB. If you have done a purge or something that is massive, I would use the Rebuild Forums command to see if that helped. Not sure on what the actual issue is, as I am no expert. These are just things I would try if I were getting a similar issue.

Dunny

Joined: Jan 2008
Posts: 514
addict
addict
Joined: Jan 2008
Posts: 514
As an add on.... (and on a second thought) also check permissions. You can do this from the CP at the very bottom (right below where you click for SQL). May be a permission issue with that particular script that may be causing an issue.

Dunny

Stephen #250672 10/19/2012 12:14 PM
Joined: Jun 2006
Posts: 16,199
Likes: 106
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,199
Likes: 106
You'll have to run "repair" on the "ubbt_POSTS" table through PHPMyAdmin or the server command line.


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: Jan 2008
Posts: 514
addict
addict
Joined: Jan 2008
Posts: 514
Aye Gizmo got it.. one of these days I will be as good as he is with this thing lol


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Add a post to additional forums
by Larry Miller - 01/27/2023 2:58 PM
What happens to modified templates during the upgrade
by Michael_E6D9 - 01/13/2023 2:11 AM
Attachments broken after server migration
by jgeoff - 12/22/2022 3:33 PM
Users cannot register
by - 07/04/2022 8:42 PM
Who's Online Now
0 members (), 194 guests, and 60 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 20221228)