WordPress database error: [Table ‘wp_posts’ is read only]

  • inblog

    (@inblog)


    18 years ago

    I had upgraded WP 3 weeks back to the latest version and have over 2500 posts with approx. 500 people visiting it. Today while updating my blog I got the following error and had no clue about it:
    WordPress database error: [Table ‘wp_posts’ is read only]
    UPDATE IGNORE wp_posts SET post_author = ‘1’, post_date = ‘2007-04-02 01:20:56’, post_date_gmt = ‘2007-04-02 06:20:56’, post_content =

    with the post content after the ‘=’, while at the end of the post I got the following error:

    Warning: Cannot modify header information – headers already sent by (output started at /home/cybercronz/public_html/blog/wp-includes/wp-db.php:121) in /home/cybercronz/public_html/blog/wp-includes/pluggable.php on line 275

    I got no clue how to fix this issue and would be glad if anybody can help me out of it.

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

    (@whooami)

    the mysql issue is something your host will have to take care of

    I am having the same problem upgrading… and in this case I *am* the host.

    I had to reinstall everything on my server,from the OS up. I have copied the database in the proper location, set table permissions to allow the tables to be edited, set user permissions with the rights to edit tables, made sure to chown the database to the mysql user, and chmod the files to 777.

    Still, I’m told this is read only.

    What am I doing wrong?

    I can do a fresh install using a different database without any problems. The various permissions between the older database that won’t upgrade and the new one that installed fine seem identical.

    What am I missing?

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘WordPress database error: [Table ‘wp_posts’ is read only]’ is closed to new replies.