Error Number 1036
 

Hello,

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:

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 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(thread.open = 10 AND thread.threadid = threadredirect.threadid)

WHERE thread.threadid IN (0,163690,165972,179462,179428,179333,178603,17921 4,178920,179224,179121,177860,178961,179128,179122 ,179120,176443,178857,178533,177614,178483,97207,1 00849,122468,126057,128077,130991,142562,142815,14 5687,155902,163691,172501,172489,90990,144204,1792 60)
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 : http://www.muonline.biz/zhyper/forumdisplay.php?f=4
Referrer : http://www.muonline.biz/zhyper/index.php
IP Address : 122.53.183.29
Username : Nocturnal
Classname : vB_Database
MySQL Version : 5.0.77

--------------- Added [DATE]1246515421[/DATE] at [TIME]1246515421[/TIME] ---------------

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

Take a look at this thread and try a different method to repair your database - 3 ways to repair a database

all of that didnt help

can you help me like

deleting that table threadredirect and then add it again?

Check if the operating system files for the database have the correct permissions.