Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 02 Jul 2009, 06:16
DeadRabbit DeadRabbit is offline
 
Join Date: Sep 2008
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,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 : 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 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
  #2  
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 vBulletin.org 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
  #3  
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
  #4  
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 vBulletin.org Coordinator
Reply With Quote
Reply



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 00:13.

Layout Options | Width: Wide Color: