vb.org Archive - Anyone help with this error:

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - Anyone help with this error: (https://vborg.vbsupport.ru/showthread.php?t=300902)

Disco_Dave

08-06-2013 09:37 PM

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

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.

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01526 seconds Memory Usage 1,719KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: