Register Members List Search Today's Posts Mark Forums Read

Thread Tools
Old 02 Jul 2009, 06:16
DeadRabbit DeadRabbit is offline
Join Date: Sep 2008
Error Number 1036


I have a problem on my forum i did made repair / optimize tables like hundreds of times but it doesnt fix this problem.


Database error in vBulletin 3.8.3:

Invalid SQL:

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 thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 14360 AND canview = 1)

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

LEFT JOIN threadredirect AS threadredirect ON( = 10 AND thread.threadid = threadredirect.threadid)

WHERE thread.threadid IN (0,163690,165972,179462,179428,179333,178603,179214,178920,179224,179121,177860, 178961,179128,179122,179120,176443,178857,178533,177614,178483,97207,100849,1224 68,126057,128077,130991,142562,142815,145687,155902,163691,172501,172489,90990,1 44204,179260)
ORDER BY sticky DESC, lastpost DESC;

MySQL Error : Table 'threadredirect' is read only
Error Number : 1036
Request Date : Thursday, July 2nd 2009 @ 03:01:41 PM
Error Date : Thursday, July 2nd 2009 @ 03:01:41 PM
Script :
Referrer :
IP Address :
Username : Nocturnal
Classname : vB_Database
MySQL Version : 5.0.77

--------------- Added 02 Jul 2009 at 06:17 ---------------

when i try to repair optimize table i get error from 1 table and here is the error


threadredirect Check Error: Table 'threadredirect' is read only
threadredirect Check Error: Corrupt

Last edited by DeadRabbit; 02 Jul 2009 at 06:17. Reason: Auto-Merged DoublePost
Reply With Quote
Old 02 Jul 2009, 15:28
Lynne's Avatar
Lynne Lynne is offline
Join Date: Sep 2004
Real name: Lynne
Take a look at this thread and try a different method to repair your database - 3 ways to repair a database
Former Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
Old 04 Jul 2009, 07:00
DeadRabbit DeadRabbit is offline
Join Date: Sep 2008
all of that didnt help

can you help me like

deleting that table threadredirect and then add it again?
Reply With Quote
Old 06 Jul 2009, 09:58
Marco van Herwaarden Marco van Herwaarden is offline
Join Date: Jul 2004
Check if the operating system files for the database have the correct permissions.
Marco van Herwaarden
Ex Coordinator
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

New To Site? Need Help?

All times are GMT. The time now is 08:25.

Layout Options | Width: Wide Color: