Add New Post "You are currently editing the page" plus media library failure

  • stylenoir

    (@stylenoir)


    8 years, 9 months ago

    Last night The media library stopped showing any images at all on the site, although clearly the database was still running since the site from the front end was fine…

    – hosting then repaired the database, which then created this error. when clicking ADD NEW POST the screen displays without the ‘content’ and ‘media library’ box and instead the error “You are currently editing the page that shows your latest posts.”

    The site is http://www.stylenoir.com which from the front end you can see is completely fine but from the backend you can see the screenshots below…

    This is really quite scary to me, I’m experienced in wordpress, PHP and develop sites but I’ve never seen this before and I’m very UN-experienced with mySQL apart from the usual set ups… can anyone help?!!!!

    Website: http://www.stylenoir.com

    Screenshot
    http://imgur.com/MpjSzQP

    P.S I’ve tried deactivating plugins of things like security/firewalls/yoast etc, and it doesn’t change I feel it is a mySQL issue..

    thankyou all in advance!!

    J

Viewing 3 replies - 1 through 3 (of 3 total)
  • primitivenet

    (@primitivenet)

    8 years, 9 months ago

    The images could be a permissions problem, oryou might be running out of server space?

    If neither of those, deactivate all plugins and see I’d the issue still occurs. If it’s fixed, reactivate them one by one to find the culprit.

    If it’s still broken, switch to the twentyfifteen theme and see if that resolves it. If it does, then the problem is you theme.

    If none of that helps, try manually reinstalling all the WordPress files with fresh copies.

    Whatever you do remember to backup first!

    Thread Starter stylenoir

    (@stylenoir)

    8 years, 9 months ago

    If anyone ever needs solution… mySQL was suddenly creating id’s in the billions! when we’re looking at a highest normal id entry of 25,000 ish.

    1. deleted all offending records with ID numbers in the billions
    2. reset the auto_increment to a few hundred above the highest number in the database (for us 27,000)

    FIXED

    Sample Code – ALTER TABLE some_table AUTO_INCREMENT=1000

    MAKE SURE THE AUTO_INCREMENT IS HIGHER THAN THE LARGEST ID NUMBER!!!!

    primitivenet

    (@primitivenet)

    8 years, 9 months ago

    Good catch – thanks for the update!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Add New Post "You are currently editing the page" plus media library failure’ is closed to new replies.