Could not insert post into the database

  • 5:4

    (@5against4)


    2 years, 9 months ago

    My site has a few pages that contain a lot of data, in the form of ratings given to music releases. This particular page has around 8,000 entries, and i usually update it by copy-pasting code generated by a spreadsheet directly into WordPress editor (containing all the relevant formatting). This is the page in question:

    [ redundant link removed ]

    Lately, WordPress has started refusing updates to it, saying “Could not insert post into the database”. i’m assuming it has something to do with size, as there’s a lot of data, but the actual quantity of data is pretty small – if saved as a text file it’s just 480Kb. i’ve tried in both Classic Editor (which i’m currently using) and Block Editor (which i only started using recently), but neither of them will accept this much data.

    Is there a limit i’m not aware of? Can pages only be so big? There are no other problems with posting so i’m guessing size must be something to do with it. Any help would be *very* much appreciated.

    • This topic was modified 2 years, 9 months ago by Jan Dembowski. Reason: Moved to Fixing WordPress, this is not an Everything else WordPress topic

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Dion

    (@diondesigns)

    There is a configuration setting in MySQL (max_allowed_packet) that controls how much data can be sent in one transaction. You may be exceeding that value. If you have shared or managed hosting, you should contact your hosting company. If you have an unmanaged VPS or dedicated server, you’ll need to check the value yourself and make sure it’s set to a minimum of 16MB.

    Max packet should be in the 32 meg range.
    Also, check the disk space available on your host.

    Thread Starter 5:4

    (@5against4)

    Thanks for the responses. i haven’t been able to find a setting “max_allowed_packet” but i’ve increased some of the values on this page of cPanel (see screenshot):

    https://ibb.co/3MGVyvN

    Is this likely to solve the problem or do i need to hunt further?

    EDIT: Still getting “Publishing failed. Could not update post in the database.” *sigh*

    • This reply was modified 2 years, 9 months ago by 5:4.
    Dion

    (@diondesigns)

    Your problem has nothing to do with the settings in your image. If you have shared or managed hosting, please contact your host. Otherwise, since you’re using cPanel, access WHM instead and check the MySQL settings page. (Note that this page is only available when WHM is accessed as the “root” user.)

    Thread Starter 5:4

    (@5against4)

    “access WHM instead” – how? What is WHM?

    i have hosting with GoDaddy and i can only see an option to access cPanel, nothing else. Goes GoDaddy count as “managed hosting”?

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Could not insert post into the database’ is closed to new replies.