Unable to create new tables in Tablepress

  • Resolved grahamm9

    (@grahamm9)


    6 months ago

    My webhost has moved my site to a new server, subsequently I am unable to create or import and create new tables.

    Error: The table could not be added. Error code: post_insert;table_add_post_insert

    Error: The import failed. Error code: post_insert;table_add_post_insert;table_import_table_save_or_add

    I have tried php versions from 7.4 to 8.4, disabling other plug-ins, and switching to a standard theme, with no change, I’m not sure what my next move should be.

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

    (@tobiasbg)

    6 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    Essentially, this means that the WordPress PHP function wp_insert_post() has returned an unspecified error, without providing further details. :-/

    Can you maybe try checking/analysing/repairing the site’s mySQL database with a tool like phpMyAdmin? Most likely, the “wp_posts” database is somehow corrupted.

    Best wishes,
    Tobias

    Thread Starter grahamm9

    (@grahamm9)

    6 months ago

    Thanks for the reply Tobias.

    I have checked the database tables with phpMyAdmin and they all check as OK. (But it is using the InnoDB engine). If I look at the rows in the posts table I can see the title of any new table I attempt to create added to the end of the table. But as a result of the error the table doesn’t appear in Tablepress.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    6 months ago

    Hi,

    regardless of the checks showing OK, can you please run the “REPAIR” command regardless? Otherwise, I can only recommend investigating the exact database queries and their results.

    This definitely is a WP or database issue, but all that TablePress knows is that wp_insert_post() returns 0 as an error (instead of a positive number as a post ID).

    Best wishes,
    Tobias

    Thread Starter grahamm9

    (@grahamm9)

    6 months ago

    Hi, I did also run the repair action, In the meantime I have sourced a good backup from before the site transfer and intend to upload this. If this doesn’t work on the new server, then its over to the hosting company.

    Thanks for your help.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    6 months ago

    Hi,

    yes, most likely this has to do with the migration of servers, so your hosting company might need to check this out.

    As another test: Can you add and edit normal posts and pages (both without and without content)?

    Best wishes,
    Tobias

    Thread Starter grahamm9

    (@grahamm9)

    6 months ago

    The database is being re-installed from the old server, finally!

    Yes I was able to edit existing content, the problem was I could not create new properly, I later found that found that any new pages I created were not editable. So definitely a database problem of some sort which did not respond to my attempts to fix it.

    Again, thanks very much for your help. Graham

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    6 months ago

    Hi Graham,

    Thanks for confirming about posts and pages as well!

    Yes, then this is a database problem. I hope the hosting company can resolve this quickly.

    Best wishes,
    Tobias

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

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

The topic ‘Unable to create new tables in Tablepress’ is closed to new replies.