Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 12 Jul 2012, 22:17
nomoreturn's Avatar
nomoreturn nomoreturn is offline
 
Join Date: Apr 2009
Real name: mastdunya.com
How To Fix Database error in vBulletin 4.2.0 for new thread or new nreply ?

How i can fix this Database error it came up when we submit a new thread or new reply i disable plugin and try and still have this error please help me to fix this thanks

:

Invalid SQL:
INSERT INTO vb_searchcore_text (searchcoreid, title, keywordtext)
VALUES ( 51, 'Admin اِیڈمن', '' )
ON DUPLICATE KEY UPDATE searchcoreid = VALUES(searchcoreid), title = VALUES(title), keywordtext = VALUES(keywordtext);

MySQL Error : Table './mast***_so**/vb_searchcore_text' is marked as crashed and should be repaired
Error Number : 145
Request Date : Thursday, July 12th 2012 @ 06:11:11 PM
Error Date : Thursday, July 12th 2012 @ 06:11:11 PM
Script : http://www.mastdunya.com/newreply.ph...streply&t=2880
Referrer : http://www.mastdunya.com/newreply.ph...streply&t=2880
IP Address : **.**.**.**
Username : admin
Classname : vB_Database
MySQL Version : 5.1.63-cll
Reply With Quote
  #2  
Old 12 Jul 2012, 23:36
soniceffect's Avatar
soniceffect soniceffect is offline
 
Join Date: Feb 2005
Real name: Marc
You need to repair the table in question.

Go to phpmyadmin
Select the table vb_searchcore_text
Select repair table from the menu at the bottom
Reply With Quote
  #3  
Old 15 Jul 2012, 23:21
nomoreturn's Avatar
nomoreturn nomoreturn is offline
 
Join Date: Apr 2009
Real name: mastdunya.com
Thanks for reply i check in myphp and i saw this code in it
SHOW FULL FIELDS FROM `vb_searchcore_text`;

but i dont know how to repair it i can see any option there for repair so can you please let me know how i can fix this.
Reply With Quote
  #4  
Old 16 Jul 2012, 03:57
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Use an application like phpMyAdmin to repair it.

Or see this thread - 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
  #5  
Old 16 Jul 2012, 22:08
nomoreturn's Avatar
nomoreturn nomoreturn is offline
 
Join Date: Apr 2009
Real name: mastdunya.com
Thanks for helping me out i got it fixed
AdminCP > Import & Maintenence > Repair and Optimize Tables
Reply With Quote
  #6  
Old 16 Jul 2012, 22:28
soniceffect's Avatar
soniceffect soniceffect is offline
 
Join Date: Feb 2005
Real name: Marc
YEah that'll do it Glad you got yourself sorted
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 17:02.

Layout Options | Width: Wide Color: