December 23, 2017 at 8:21 am
why this error occurs? like and failure was not, and cleaning the antivirus.
Database error in vBulletin 3.8.4:
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
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadredirect.expires
FROM vb_thread AS thread
LEFT JOIN vb_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN vb_subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
LEFT JOIN vb_post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN vb_threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
WHERE thread.threadid IN (0,9839,6392,6391,1981,1473,88,1375)
ORDER BY sticky DESC, lastpost DESC;
SQL Error : Table './klon/vb_post' is marked as crashed and should be repaired
Error Number : 145
IP Address : 90.188.220.91
Username : xD
Classname : vB_Database
SQL Version : 5.1.54
December 23, 2017 at 3:18 pm
This has all the ear-markings of another one of "those" spam posts. Someone who has never posted before and on their first visit or so posts something with a title about a corrupt database, the actual post is nearly unintelligible or not related to a real problem, and then sometime in the next week some rubber will answer with a link.
--Jeff Moden
Change is inevitable... Change for the better is not.
December 23, 2017 at 4:12 pm
I'm also a little amazed the OP says they're using SQL (Server?) Version 5, which I'm pretty sure never existed. Even if it did, it would have been out of support for probably 12 or so years by now.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 23, 2017 at 4:32 pm
It's not SQL Server. vBulletin uses MySQL. So, given the version, this is MySQL 5.1.54 (still pretty outdated)
This isn't exactly T-SQL afterall - IF(votenum >= 1, votenum, 0) AS votenum,
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 24, 2017 at 8:04 am
This was removed by the editor as SPAM
December 24, 2017 at 8:14 am
powellsudie - Sunday, December 24, 2017 8:04 AMgood day ! perhaps you should help in such a situation, the recovery via backup , but if you do not help, try sql repair. download the program (link removed)
Reported as spam.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply