Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?
  1. Home
  2. Discussion Forum
  3. PHPFusion 6 Support
  4. Official Core Support - 6
  5. MySQL repair warnings! Strange

MySQL repair warnings! Strange

Asked Modified Viewed 2,690 times
Back to Forum Index Previous Topic Next Topic
Print
W
Wanabo
W
Wanabo 10
www.probemyip.com/probe-my-ip-80x15.png
 pHp-Fusion.Asia & pHp-Fusion.Fr & pHp-Fusion.Cn are available for a localized support community. Send PB for info.
  • Senior Member, joined since
  • Contributed 598 posts on the community forums.
  • Started 94 threads in the forums
  • Started this discussions
asked
Senior Member

Just was playing with SQLYog and tried some repair funcions.
This was the result;

Quote

Table Op Msg_type Msg_text
------------------------ ------ -------- ------------------------------------
fusion_admin repair warning Number of rows changed from 0 to 38
fusion_admin repair status OK
fusion_article_cats repair warning Number of rows changed from 0 to 2
fusion_article_cats repair status OK
fusion_articles repair status OK
fusion_blacklist repair status OK
fusion_captcha repair status OK
fusion_comments repair status OK
fusion_custom_pages repair status OK
fusion_download_cats repair warning Number of rows changed from 0 to 2
fusion_download_cats repair status OK
fusion_downloads repair warning Number of rows changed from 0 to 4
fusion_downloads repair status OK
fusion_faq_cats repair warning Number of rows changed from 0 to 8
fusion_faq_cats repair status OK
fusion_faqs repair warning Number of rows changed from 0 to 3
fusion_faqs repair status OK
fusion_flood_control repair status OK
fusion_forum_attachments repair status OK
fusion_forums repair warning Number of rows changed from 0 to 30
fusion_forums repair status OK
fusion_infusions repair warning Number of rows changed from 0 to 2
fusion_infusions repair status OK
fusion_messages repair warning Number of rows changed from 0 to 100
fusion_messages repair status OK
fusion_messages_options repair warning Number of rows changed from 0 to 16
fusion_messages_options repair status OK
fusion_new_users repair status OK
fusion_news repair warning Number of rows changed from 0 to 5
fusion_news repair status OK
fusion_news_cats repair warning Number of rows changed from 0 to 16
fusion_news_cats repair status OK
fusion_online repair warning Number of rows changed from 0 to 1
fusion_online repair status OK
fusion_panels repair warning Number of rows changed from 0 to 22
fusion_panels repair status OK
fusion_photo_albums repair warning Number of rows changed from 0 to 1
fusion_photo_albums repair status OK
fusion_photos repair status OK
fusion_poll_votes repair warning Number of rows changed from 0 to 25
fusion_poll_votes repair status OK
fusion_polls repair warning Number of rows changed from 0 to 1
fusion_polls repair status OK
fusion_posts repair warning Number of rows changed from 0 to 113
fusion_posts repair status OK
fusion_ratings repair status OK
fusion_rss_feeds repair warning Number of rows changed from 0 to 5
fusion_rss_feeds repair status OK
fusion_settings repair warning Number of rows changed from 0 to 1
fusion_settings repair status OK
fusion_shoutbox repair warning Number of rows changed from 0 to 60
fusion_shoutbox repair status OK
fusion_site_links repair warning Number of rows changed from 0 to 17
fusion_site_links repair status OK
fusion_submissions repair status OK
fusion_thread_notify repair status OK
fusion_threads repair warning Number of rows changed from 0 to 43
fusion_threads repair status OK
fusion_user_groups repair warning Number of rows changed from 0 to 3
fusion_user_groups repair status OK
fusion_users repair warning Number of rows changed from 0 to 55
fusion_users repair status OK
fusion_vcode repair status OK
fusion_weblink_cats repair warning Number of rows changed from 0 to 9
fusion_weblink_cats repair status OK
fusion_weblinks repair warning Number of rows changed from 0 to 36
fusion_weblinks repair status OK


In both cases unrepaired and repaired site is working OK.

Can anyone explain this?

The MySQL database was created with an PHPFusion install. Could this mean there are bugs in the default database install?

Should I fix it or should I leave it as is?
0 replies

2 posts

M
Matonor
M
Impossible things are there to be made possible
  • Veteran Member, joined since
  • Contributed 1,022 posts on the community forums.
  • Started 3 threads in the forums
answered
Veteran Member

repair status OK means that everything is fine. You probably used one of the stronger repair queries using use_frm. In this case, the database storage files are read to replace the header in case of corruption. In order to do this, the header is first reset (-> 0 rows) and then set to the actual rowcount (=>second number).
0 replies
W
Wanabo
W
Wanabo 10
www.probemyip.com/probe-my-ip-80x15.png
 pHp-Fusion.Asia & pHp-Fusion.Fr & pHp-Fusion.Cn are available for a localized support community. Send PB for info.
  • Senior Member, joined since
  • Contributed 598 posts on the community forums.
  • Started 94 threads in the forums
  • Started this discussions
answered
Senior Member

Before repairing I backupped my site and restored it because I did not know what to think of these repair messages.

Thanks for explaining this to me! Indeed I used use_frm.
0 replies

Category Forum

Official Core Support - 6

Labels

None yet

Statistics

  • Views 0 views
  • Posts 2 posts
  • Votes 0 votes
  • Topic users 2 members

0 participants

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet