2017-12-13, 11:33 AM
Hi All
Started getting some alerts on forum the other day, have now closed the board as I think the issue relates to a DB problem. It should be noted people are using it fine, new threads are going on no problem etc.
Found this thread: https://community.mybb.com/post-816935.html
Put the board into offline mode and ran
"mysqlcheck TABLENAME -r"
Got the following back
As you can see sad state of affairs, few tables need repairing and the threadviews one is corrupt.
Looking around people talk about changing the table type but I would like some pointers from admins here on best way to proceed please.
MySQLi 5.5.57
Currently running 1.8.13 will update to .14 once this is fixed.
Thanks
Started getting some alerts on forum the other day, have now closed the board as I think the issue relates to a DB problem. It should be noted people are using it fine, new threads are going on no problem etc.
[b]Error Messages[/b]
Your Copy of MYBB running on VXOC-Astra-J/GTC (https://www.vxoc.org.uk/forum) has experienced an error, Details of the error include
---
Type 20
File: (Line no. 0)
Message SQL Error: 130 - Incorrect file format 'my_bbthreadviews' Query: INSERT INTO mybb_threadviews(tid) VALUES('3037)
Found this thread: https://community.mybb.com/post-816935.html
Put the board into offline mode and ran
"mysqlcheck TABLENAME -r"
Got the following back
cl53-forummybb.mybb_adminlog OK
cl53-forummybb.mybb_adminoptions OK
cl53-forummybb.mybb_adminsessions OK
cl53-forummybb.mybb_adminviews OK
cl53-forummybb.mybb_alert_types OK
cl53-forummybb.mybb_alerts OK
cl53-forummybb.mybb_announcements OK
cl53-forummybb.mybb_attachments OK
cl53-forummybb.mybb_attachtypes OK
cl53-forummybb.mybb_awaitingactivation OK
cl53-forummybb.mybb_badwords OK
cl53-forummybb.mybb_bam OK
cl53-forummybb.mybb_banfilters OK
cl53-forummybb.mybb_banned OK
cl53-forummybb.mybb_buddyrequests OK
cl53-forummybb.mybb_calendarpermissions OK
cl53-forummybb.mybb_calendars OK
cl53-forummybb.mybb_captcha OK
cl53-forummybb.mybb_datacache OK
cl53-forummybb.mybb_debuglogs OK
cl53-forummybb.mybb_delayedmoderation OK
cl53-forummybb.mybb_events OK
cl53-forummybb.mybb_forumpermissions OK
cl53-forummybb.mybb_forums OK
cl53-forummybb.mybb_forumsread OK
cl53-forummybb.mybb_forumsubscriptions OK
cl53-forummybb.mybb_g33k_thankyoulike_stats OK
cl53-forummybb.mybb_g33k_thankyoulike_thankyoulike OK
cl53-forummybb.mybb_google_seo OK
cl53-forummybb.mybb_groupleaders OK
cl53-forummybb.mybb_hello_messages OK
cl53-forummybb.mybb_helpdocs OK
cl53-forummybb.mybb_helpsections OK
cl53-forummybb.mybb_icons OK
cl53-forummybb.mybb_joinrequests OK
cl53-forummybb.mybb_mailerrors OK
cl53-forummybb.mybb_maillogs OK
cl53-forummybb.mybb_mailqueue OK
cl53-forummybb.mybb_massemails OK
cl53-forummybb.mybb_moderatorlog OK
cl53-forummybb.mybb_moderators OK
cl53-forummybb.mybb_modtools OK
cl53-forummybb.mybb_myadvertisements_advertisements OK
cl53-forummybb.mybb_myadvertisements_zones OK
cl53-forummybb.mybb_mycode OK
cl53-forummybb.mybb_mydonations_archive OK
cl53-forummybb.mybb_mydonations_goal OK
cl53-forummybb.mybb_mypermissions_actions OK
cl53-forummybb.mybb_mysubscriptions_coinpayments_log OK
cl53-forummybb.mybb_mysubscriptions_log OK
cl53-forummybb.mybb_mysubscriptions_subscriptions OK
cl53-forummybb.mybb_ougc_annbars OK
cl53-forummybb.mybb_polls OK
cl53-forummybb.mybb_pollvotes OK
cl53-forummybb.mybb_posts OK
cl53-forummybb.mybb_privatemessages OK
cl53-forummybb.mybb_profile_visitors
note : The storage engine for the table doesn't support repair
cl53-forummybb.mybb_profilefields OK
cl53-forummybb.mybb_promotionlogs OK
cl53-forummybb.mybb_promotions OK
cl53-forummybb.mybb_questions OK
cl53-forummybb.mybb_questionsessions OK
cl53-forummybb.mybb_reportedcontent OK
cl53-forummybb.mybb_reportreasons OK
cl53-forummybb.mybb_reputation OK
cl53-forummybb.mybb_searchlog OK
cl53-forummybb.mybb_sessions OK
cl53-forummybb.mybb_settinggroups OK
cl53-forummybb.mybb_settings OK
cl53-forummybb.mybb_smilies OK
cl53-forummybb.mybb_spamlog OK
cl53-forummybb.mybb_spiders OK
cl53-forummybb.mybb_stats OK
cl53-forummybb.mybb_tags OK
cl53-forummybb.mybb_tapatalk_forum_info
note : The storage engine for the table doesn't support repair
cl53-forummybb.mybb_tapatalk_push_data
note : The storage engine for the table doesn't support repair
cl53-forummybb.mybb_tapatalk_users
note : The storage engine for the table doesn't support repair
cl53-forummybb.mybb_tasklog OK
cl53-forummybb.mybb_tasks OK
cl53-forummybb.mybb_templategroups OK
cl53-forummybb.mybb_templates OK
cl53-forummybb.mybb_templatesets OK
cl53-forummybb.mybb_themes OK
cl53-forummybb.mybb_themestylesheets OK
cl53-forummybb.mybb_threadprefixes OK
cl53-forummybb.mybb_threadratings OK
cl53-forummybb.mybb_threads OK
cl53-forummybb.mybb_threadsread OK
cl53-forummybb.mybb_threadsubscriptions OK
cl53-forummybb.mybb_threadviews
Error : Incorrect file format 'mybb_threadviews'
error : Corrupt
cl53-forummybb.mybb_tickets OK
cl53-forummybb.mybb_tickets_answers OK
cl53-forummybb.mybb_todolist OK
cl53-forummybb.mybb_todolist_permissions OK
cl53-forummybb.mybb_todolist_projects OK
cl53-forummybb.mybb_todolist_searchs OK
cl53-forummybb.mybb_trader_feedback
note : The storage engine for the table doesn't support repair
cl53-forummybb.mybb_trader_permissions
note : The storage engine for the table doesn't support repair
cl53-forummybb.mybb_trader_settings OK
cl53-forummybb.mybb_upgrade_data
note : The storage engine for the table doesn't support repair
cl53-forummybb.mybb_userfields OK
cl53-forummybb.mybb_usergroups OK
cl53-forummybb.mybb_usermap_places OK
cl53-forummybb.mybb_users OK
cl53-forummybb.mybb_usertitles OK
cl53-forummybb.mybb_warninglevels OK
cl53-forummybb.mybb_warnings OK
cl53-forummybb.mybb_warningtypes OK
As you can see sad state of affairs, few tables need repairing and the threadviews one is corrupt.
Looking around people talk about changing the table type but I would like some pointers from admins here on best way to proceed please.
MySQLi 5.5.57
Currently running 1.8.13 will update to .14 once this is fixed.
Thanks