acroplex
Forum Replies Created
-
Problem solved by adding the following lines to the /wp-admin/.htaccess file, after enabling BasicAuth:
<Files admin-ajax.php> Order allow,deny Allow from all Satisfy any </Files>Forum: Plugins
In reply to: [Optimize Database after Deleting Revisions] Huge data loss after optimizingRolf, problem solved. The culprit was two obsolete keys in one of the indexes which I dropped, and/or temporary (TMM) files that could not be overwritten during the optimization.
Thanks a lot 🙂
Forum: Plugins
In reply to: [Optimize Database after Deleting Revisions] Huge data loss after optimizingHaha, ok 🙂 Close it as resolved. Thanks Rolf.
Forum: Plugins
In reply to: [Optimize Database after Deleting Revisions] Huge data loss after optimizingYes, I can see that after I manually optimized via phpMyAdmin. Thanks!
Forum: Plugins
In reply to: [Optimize Database after Deleting Revisions] Huge data loss after optimizingAlright, I will give it some more thorough testing and will update. Thanks for your suggestions.
Forum: Plugins
In reply to: [Optimize Database after Deleting Revisions] Huge data loss after optimizingYes, you are correct. PHPMyAdmin produces the same error for the table when “Optimize table” is selected.
Many thanks. The question is, why is that triggered by optimization? There are no errors logged otherwise.
Forum: Plugins
In reply to: [Optimize Database after Deleting Revisions] Huge data loss after optimizingRolf, none of these check boxes are ticked. I don’t run the scheduler either. I delete all revisions, so that option is set to ‘0’.
Forum: Plugins
In reply to: [Optimize Database after Deleting Revisions] Huge data loss after optimizingYes, it’s MyISAM; InnoDB tables are skipped. Sent another log file with some stats.
Forum: Plugins
In reply to: [Optimize Database after Deleting Revisions] Huge data loss after optimizingOK, so I unchecked the wp_postmeta from being optimized and clicked the button.
The error_log produced errors, which I will email you.
Correct, I fix the table after checking, by repairing it.
Forum: Plugins
In reply to: [Optimize Database after Deleting Revisions] Huge data loss after optimizingRolf, my method of testing is this:
1. Disabled plugin.
2. Deleted existing error_log
3. Left it alone for a couple of days: no error_log was created.
4. Enabled plugin.
5. Pressed the Optimize DB (1 click) from the Admin section.As soon as I do this, a second later, the error_log is created and starts filling up for a while. The wp_postmeta table crashes and needs to be fixed (I use cPanel).
I will exclude the wp_postmeta and will report my findings. Thanks.
Forum: Plugins
In reply to: [Optimize Database after Deleting Revisions] Huge data loss after optimizingThanks, email sent.
Forum: Plugins
In reply to: [Contextual Related Posts] wp_post meta crashesHi Ajay – I’ve had no errors thus far and I can safely say that the previous issues I faced were circumstantial and potentially linked to the other plugin I mentioned.
Forum: Plugins
In reply to: [Contextual Related Posts] wp_post meta crashesUpdate: Re-installed the plugin with another plugin disabled (“Optimize Database after Deleting Revisions”).
There are NO errors so far. Will update this thread in a couple of days.
Forum: Plugins
In reply to: [Optimize Database after Deleting Revisions] Huge data loss after optimizingYou might have to take a look at what is going on, as I can confirm the plugin crashes the wp_postmeta table the moment it’s executed. Please advise on a method to provide you the error_log privately.
Forum: Plugins
In reply to: [Contextual Related Posts] wp_post meta crashesHi Ajay, I did not change the default setting, so I assume it’s disabled. Currently, I have uninstalled the plugin to monitor the database for errors. Will update this next week.