Unable to create new tables. Error Code: table_add_update_table_options_failed

  • Resolved webidoo

    (@webidoo)


    8 months, 2 weeks ago

    Hello, I am unable to create new tables. When I try, I get the error table_add_update_table_options_failed.

    Has anyone else had the same problem?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    8 months, 2 weeks ago

    Hi!

    Thanks for your post and sorry for the trouble!

    This indicates a problem with the database that your site uses, most likely with the “wp_postmeta” database table. I therefore suggest to maybe check the integrity of the mySQL database (you could maybe try running the “ANALYZE” or “REPAIR” commands, using e.g. a tool like phpMyAdmin or whatever the hosting company maybe offers). Other than that, I would suggest to get in touch with the host’s support team here, and ask them to check if anything strange is maybe going on on the database server.

    Regards,
    Tobias

    Thread Starter webidoo

    (@webidoo)

    8 months, 2 weeks ago

    Hi Tobias,

    Yes, basically the AUTO_INCREMENT property was missing in the meta_id column of the wp_postmeta table. Once I restored that, I was able to create a new table.

    Thank you very much

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    8 months, 2 weeks ago

    Hi,

    no problem, you are very welcome! 🙂 Good to hear that this helped!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress in the plugin directory. Thanks!

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

The topic ‘Unable to create new tables. Error Code: table_add_update_table_options_failed’ is closed to new replies.