The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Database ERROR QUICK HELP PLEASE!!!!!!!!!!!!!!!!!!!!!!!!!!!!
everytime anyone clicks on a thread on my site www.whoyoureppin.com/forum they get thos
Database error in vBulletin 3.6.4: Invalid SQL: SELECT post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted, user.*, userfield.*, usertextfield.*, icon.title as icontitle, icon.iconpath, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason, editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline, editlog.reason AS edit_reason, postparsed.pagetext_html, postparsed.hasimages, sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages, sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid FROM post AS post LEFT JOIN user AS user ON(user.userid = post.userid) LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid) LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid) LEFT JOIN icon AS icon ON(icon.iconid = post.iconid) LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post') LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid) LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 41 AND postparsed.languageid = 1) LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 41 AND sigparsed.languageid = 1) LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid) WHERE post.postid IN (0,45905) ORDER BY post.dateline; MySQL Error : Table 'postparsed' is marked as crashed and should be repaired Error Number : 1194 Date : Thursday, September 13th 2007 @ 09:58:54 AM Script : http://www.whoyoureppin.com/forum/showthread.php?t=4829 Referrer : http://www.whoyoureppin.com/forum/ IP Address : 82.32.144.37 Username : K Classname : vB_Database how do i fix please help fast? |
#2
|
||||
|
||||
The table is damaged and you need to run a repair on it. Do you have access to phpMyAdmin?
If you can get into your Admin Panel navigate to Maintenance, then select Repair/Optimize Tables. Select the postparsed table (or all of them, it will not hurt), then make sure both Optimize and Repair options are set to yes, then click continue. If you can not get to your admin panel you can use phpMyAdmin Login there and navigate to your database (if you have more than 1) Click on the "postparsed" table on thr right and then the Operations tab at the top. At the bottom of the right panel, under "Table maintenance" select "Repair Table" |
#3
|
|||
|
|||
imk_micforum.postparsed repair status OK
i still have the error tho? |
#4
|
||||
|
||||
try to simply repair all tables.
If that still doesnt work disable all plugins and see if it works then. |
#5
|
||||
|
||||
Run it from your admin panel and click "Repeat Process" a couple of times, see if that clears it up.
My need somebody a bit more knowledgeable about MySQL if that does not work. Good Luck |
#6
|
|||
|
|||
how do i repair all tables?
|
#7
|
||||
|
||||
In your admin panel, under Maintenance Repair/Optimize Tables there is a checkbox at the top that says "Check All"
That will do all of your tables. Rerun the process a couple of times and see if that clears up the problems. |
#8
|
|||
|
|||
postparsed Check Warning: Table is marked as crashed
postparsed Check Warning: 2 clients are using or haven't closed the table properly postparsed Check Error: Record at pos: 58564 is not remove-marked postparsed Check Error: record delete-link-chain corrupted postparsed Check Error: Corrupt Thanks The Problem Is Ok Now But Should I Be Fixing This Another Wya? |
#9
|
||||
|
||||
The best way is probably the admin panel, it is already part of vB and works very well.
The other method I posted would be if you could not get to the admin panel for some reason. Both really do the same thing in the end. Glad you are back up and running |
#10
|
|||
|
|||
THANKS for your help
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|