Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 14 Oct 2010, 05:13
[email protected] p@ndu is offline
 
Join Date: Jan 2009
Getting Datbase Error

while opening my forum i am getting this error


Database error in vBulletin 4.0.6:

Invalid SQL:

SELECT *
FROM thread AS thread
LEFT JOIN force_read_users AS force_read_users ON (thread.threadid = force_read_users.force_read_threadid AND force_read_users.force_read_userid = '2')
WHERE thread.force_read = '1' AND (thread.force_read_expire_date = '0' OR thread.force_read_expire_date > '1287029278') AND (force_read_usergroups = '' OR force_read_usergroups LIKE '%-6-%') AND (force_read_forums = '') AND force_read_users.force_read_userid IS NULL
ORDER BY force_read_order ASC;

MySQL Error : Table './*******_downloadsmasti/thread' is marked as crashed and should be repaired
Error Number : 145
Request Date : Wednesday, October 13th 2010 @ 11:07:58 PM
Error Date : Wednesday, October 13th 2010 @ 11:07:58 PM

Referrer :
IP Address : ********
Username : *****
Classname : vB_Database
MySQL Version : 5.1.50


can some one please give em a solution for this

Last edited by [email protected]; 21 Jan 2011 at 07:38.
Reply With Quote
  #2  
Old 14 Oct 2010, 05:34
ry215's Avatar
ry215 ry215 is offline
 
Join Date: May 2006
Real name: Nelson
Did you installed this mod:
http://www.vbulletin.org/forum/misc....sersreadthread

Try to reinstall it, or remove it.

have good time.
__________________
My Mods & Styles

Contace me now for more details!
Reply With Quote
  #3  
Old 14 Oct 2010, 05:36
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Your thread table is crashed. Go to maintenance > repair & optimize tables > select the thread table > continue. You may have to do that a couple of times before it says OK.
__________________
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
  #4  
Old 14 Oct 2010, 05:47
[email protected] p@ndu is offline
 
Join Date: Jan 2009
i cant login in to my admin cp also
Reply With Quote
  #5  
Old 14 Oct 2010, 10:44
ry215's Avatar
ry215 ry215 is offline
 
Join Date: May 2006
Real name: Nelson
upload tools.php in folder do_not_upload to admincp, then run it. Ex: domain.com/forum/admincp/tools.php

Repair table.
__________________
My Mods & Styles

Contace me now for more details!
Reply With Quote
  #6  
Old 14 Oct 2010, 13:14
[email protected] p@ndu is offline
 
Join Date: Jan 2009
even after uploading tht the problem isnt solved...

plz help....
Reply With Quote
  #7  
Old 14 Oct 2010, 15:28
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Repair the table via phpmyadmin. Or see this - 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
  #8  
Old 15 Oct 2010, 07:59
[email protected] p@ndu is offline
 
Join Date: Jan 2009
problem solved thx for help guyz....
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 14:42.

Layout Options | Width: Wide Color: