Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 09-27-2009, 07:04 PM
ehabfouad22 ehabfouad22 is offline
 
Join Date: Oct 2007
Posts: 22
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Old file after database repair

Hello!
A frequent database error due to corruption of (MY post) table requires a repair of the entire database, as repairing the (post) table alone through the (phpMyAdmin) page never works out.
After conducting the repair process via the webhosting control panel page, a message that says: (Old file. Allow to cancel repair) appears.
I keep repeating the process of repair again and again, and in most of the cases I find no solution but restoring the database to the last backup!
Any common reasons for that?
Many thanks

--------------- Added [DATE]1254082688[/DATE] at [TIME]1254082688[/TIME] ---------------

Note:
I noticed in more than one case that the occurance of such a problem is proceeded by a mal-posting of a topic or reply. In some cases, before the problem happens, I receive a message from one of my "trusted" users to fix a topic he recently added, and the problem begins when I try to open the link (topic) he sent to me as an administarive message on the admin e-mail.
Does that help?
Reply With Quote
  #2  
Old 09-27-2009, 08:49 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Is anything showing up in the error_logs (if you don't know where they are, ask your host). Are any database errors occuring? You say repairing on the post table "never works out"... what does that mean?
Reply With Quote
  #3  
Old 09-28-2009, 12:34 AM
ehabfouad22 ehabfouad22 is offline
 
Join Date: Oct 2007
Posts: 22
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Lynne View Post
Is anything showing up in the error_logs (if you don't know where they are, ask your host). Are any database errors occuring? You say repairing on the post table "never works out"... what does that mean?
Hi,
Thanks for your time.
Database errors have been occuring frequently, but they're considerably less frequent than before upgrading to 3.8.4.
They're always in (corn), (post) and (datastore) tables (most frequently in "post" table), and none of these tables ever responds to optimization or repair processes "individually" on phpMyAdmin.
Under the title (Type), all of the tables read (MyISAM), while the corrupted one reads (in use).
I select the affected table, (check its box) choose to optimize or repair it, and this never "works out" (never solves the problem).
I use the (Repair database) tool on my webhosting CP, as I said, and sometimes it fixes the issue, but most of the times I receive the message (Old file. Allow to cancel).
I asked my host to provide information on (error_log).
Regards
Reply With Quote
  #4  
Old 09-28-2009, 02:49 AM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Sometimes you need to run repair on a table more than once before it says the table is OK.

I don't know what this error is regarding Old File / Allow to Cancel.
Reply With Quote
Reply

Thread Tools
Display Modes

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 08:20 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03413 seconds
  • Memory Usage 2,180KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete