Posts table Auto_increment value too large – cannot add new pages

  • webmastercostalessgolf

    (@webmastercostalessgolf)


    10 years, 1 month ago

    I have a strange problem where I import a lot of posts from an external source and also a lot of attachments for each post. Over time this has led to the situation where WordPress will not allow me to manually add a new page using Pages -> Add New…

    After a lot of investigation (and trying all the usual tricks like changing themes, clearing plugins, adding admin users etc.) I was able to reproduce the issue by creating a fresh installation of WordPress and manually adding a post using phpMyAdmin with an id of 2147537784. Hey presto, WordPress will not allow the creation of a new page, instead of the publish button I will see a “Submit for Review” button which does not itself in fact work either. An attempt to submit for review will simply redirect me to /wp-admin/edit.php.

    Does anybody have any idea why? I am thinking that it could be to do with the integer type used somewhere in WordPress being overflowed or something? Any help at all would be appreciated

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Posts table Auto_increment value too large – cannot add new pages’ is closed to new replies.

Tags