PDA

View Full Version : Anyone help with this error:


Disco_Dave
08-06-2013, 09:37 PM
I'm a totally novice when it comes to these things.....Seems like we've lost the forum :~(

Database error in vBulletin 4.2.1:

Invalid SQL:

SELECT user.userid, user.options, user.username, user.usergroupid,
user.displaygroupid, whoread.dateline #, ipdata.ip AS ipaddress, ipdata.altip
FROM vbcontentread as whoread
INNER JOIN vbuser as user USING (userid)
# LEFT JOIN vbipdata as ipdata USING (ipid)
WHERE whoread.readtype = 'view'
AND whoread.contentid = 5762
AND whoread.contenttypeid = 2
AND whoread.dateline > 1375270940;

MySQL Error : Table './nirc_vB4forum/vbcontentread' is marked as crashed and should be repaired
Error Number : 145
Request Date : Tuesday, August 6th 2013 @ 11:25:54 PM
Error Date : Tuesday, August 6th 2013 @ 11:25:56 PM
Script : http://www.nirc.co.uk/forums/showthread.php?5762-They-re-all-looking-back-now!!
Referrer : http://www.nirc.co.uk/forums/search.php?searchid=101427

nerbert
08-06-2013, 10:16 PM
The vbcontentread table has crashed. Go to

Maintenance > Repair / Optimize Tables.

Select the table and set Repair Tables to yes and [Continue]

Disco_Dave
08-07-2013, 06:37 AM
Thanks Nerbert

I ran this last night, all seems fine now.