vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Database Error! Need Help ASAP. (https://vborg.vbsupport.ru/showthread.php?t=269786)

MarcInJapan 09-06-2011 05:34 PM

Database Error! Need Help ASAP.
 
I was thinking maybe my host/server had issues, but only one of my sites is receiving this error. Can't open posts or threads. Chatbox works fine. Here is what I get when I try to open a post or thread:

Database error in vBulletin 3.8.6:

Invalid SQL:

SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
thread.prefixid, thread.taglist, hiddencount, deletedcount

, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason

, threadredirect.expires
, post_user.displaygroupid AS post_user_displaygid, post_user.usergroupid AS post_user_usergid, last_post_user.displaygroupid AS last_post_user_displaygid, last_post_user.usergroupid AS last_post_user_usergid
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')


LEFT JOIN post AS post ON(post.postid = thread.firstpostid)

LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
LEFT JOIN user AS last_post_user ON (thread.lastposter = last_post_user.username)
LEFT JOIN user AS post_user ON (thread.postuserid = post_user.userid)
WHERE thread.threadid IN (0,40817,40462,40312,40576,40527,40424,40416,40358 ,40359,39764,39549,39540,39569,39502,39494,39440,3 9360,39364,39222,39299,39291,39072,39128,39071,390 37,39021,38890,38930,38902,38887,23156,30253)
ORDER BY sticky DESC, lastpost DESC;

MySQL Error : Table './ustangs_united3/post' is marked as crashed and should be repaired
Error Number : 145
Request Date : Tuesday, September 6th 2011 @ 10:41:08 AM
Error Date : Tuesday, September 6th 2011 @ 10:41:08 AM
Script : http://www.unitedstangs.com/forums/forumdisplay.php?f=6
Referrer : http://www.unitedstangs.com/forums/index.php
IP Address : 132.3.57.01
Username : Marcus
Classname : vB_Database
MySQL Version : 5.1.56

Is this something that can be repaired? Am I missing a current patch? Or is this a virus?

Your immediate help is appreciated!

kh99 09-06-2011 06:06 PM

Try using Repair/Optimize tables under Maintenance in the adminCP. It looks like the post table is causing the error.

souperman 09-07-2011 07:57 AM

You can also use phpmyadmin if you have that setup. Most control panels include this by default.


All times are GMT. The time now is 04:03 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00914 seconds
  • Memory Usage 1,718KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete