Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
Register FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 08-06-2013, 08:37 PM
Disco_Dave's Avatar
Disco_Dave Disco_Dave is offline
 
Join Date: May 2011
Location: Belfast
Posts: 586
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Anyone help with this error:

I'm a totally novice when it comes to these things.....Seems like we've lost the forum :~(

PHP Code:
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 
Reply With Quote
  #2  
Old 08-06-2013, 09:16 PM
nerbert nerbert is offline
 
Join Date: May 2008
Posts: 784
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The vbcontentread table has crashed. Go to

Maintenance > Repair / Optimize Tables.

Select the table and set Repair Tables to yes and [Continue]
Reply With Quote
3 благодарности(ей) от:
CAG CheechDogg, Disco_Dave, Lynne
  #3  
Old 08-07-2013, 05:37 AM
Disco_Dave's Avatar
Disco_Dave Disco_Dave is offline
 
Join Date: May 2011
Location: Belfast
Posts: 586
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks Nerbert

I ran this last night, all seems fine now.
Reply With Quote
Reply


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

Forum Jump


All times are GMT. The time now is 09:51 AM.


Powered by vBulletin® Version 3.9.0
Copyright ©2000 - 2017, vBulletin Solutions Inc.