WP-Optimize is deleting wp_posts :/

  • Resolved puda

    (@puda)


    7 years ago

    Hey,

    Been having issues with WP-Optimize in the last 2 weeks. When running the plugin, it’s randomly deleting wp-posts from time to time. It’s been the second time in just 2 weeks. Thankfully I have have backups but still… Am I the only one experiencing this issue?

Viewing 10 replies - 1 through 10 (of 10 total)
  • guyha

    (@guyha)

    Happens with me too. It doesn’t delete the table, just breaks it (phpmyadmin doesn’t show a row count, and WP says I have no posts)

    Thread Starter puda

    (@puda)

    True sorry! The table is still there but showing a size of 00. Glad I am not the only one with this issue. Contacted the authors of the plugin and they asked me to post here so still waiting to hear back…

    Plugin Author David Anderson / Team Updraft

    (@davidanderson)

    Hi,

    Are you able to give any more details? What is leading you to identify WP-O as the culprit? What is being done at the time that the problem occurs? Any other info that might help?

    David

    Thread Starter puda

    (@puda)

    Sure, always happening when I check the very first optimization (optimizing the tables). I can see that the plugin is running smoothly at first and then at some point it seems to delete all my posts and I can see the size of my database losing a good chunk of data. It has happened twice so far in the last 2 weeks. I have unchecked the first option and now only running option 2, 3 and 4 (drafts, revisions and comments)

    Plugin Author David Anderson / Team Updraft

    (@davidanderson)

    The ‘optimize’ option just runs a single SQL OPTIMIZE command, which tells the MySQL server to optimize its tables. If that is causing you to lose data, then you have serious corruption in your database, and need to speak to your MySQL server administrator to get it repaired.

    David

    Thread Starter puda

    (@puda)

    I will contact them, thanks!

    Thread Starter puda

    (@puda)

    After double checking, all my table + database look fine so maybe the host is blocking or crashing at some point causing wp-posts to empty itself. I haven’t been able to figure out the reason.

    Plugin Author David Anderson / Team Updraft

    (@davidanderson)

    Hi,

    all my table + database look fine

    What was it in particular that you looked at, to discern this?

    David

    Thread Starter puda

    (@puda)

    Ran a script in phpmyadmin.

    I have actually uninstalled wp optimize and now directly optimizing my tables in Phpmyadmin. No issues so far.

    Plugin Contributor DNutbourne

    (@dnutbourne)

    Hi @puda,

    Can I mark this issue as closed?

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘WP-Optimize is deleting wp_posts :/’ is closed to new replies.