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

  • Resolved vgnavada

    (@vgnavada)


    1 year, 7 months ago

    Hello,

    I’m unable to login to the site: https://karavalixpress.com/

    It is running on “WordPress with NGINX and SSL packaged by Bitnami” on Amazon ec2.

    I also raised a ticket on Bitnami Forums: https://github.com/bitnami/vms/issues/837
    Looks like they don’t have any insights into this

    I enable the DEBUG MODE, And found these major errors:

    WordPress database error: [Table ‘wp_options’ is read only]
    UPDATE wp_options SET option_value = '1681396523.5065269470214843750000' WHERE option_name = '_transient_doing_c

    WordPress database error: [Table ‘wp_usermeta’ is read only]
    UPDATE wp_usermeta SET meta_value = 'a:1:{s:64:\"1710e0695c0eb73e731b74b7ba52d26644fc0ae647c48e7c927b5832e090d2ba\";a:4:{s:10:\"expiration\";i:1681569323;s:2:\"ip\";s:14:\"162.158.235.63\";s:2:\"ua\";s:117:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36\";s:5:\"login\";i:1681396523;}}' WHERE user_id = 4 AND meta_key = 'session_tokens'

    Can anyone help me how to fix this?

    • This topic was modified 1 year, 7 months ago by vgnavada.

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

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

  • Hi @vgnavada

    As those errors notes, it appears your database tables are read-only. The first things that come to mind are:

    • Checking the MySQL user associated with your WordPress installation has the necessary permissions to read and write to the database.
    • Perhaps repairing the database via the built-in WordPress database repair feature.

    You can find some further information on the latter in the developer docs.

    Failing that, Bitnami should be able to help debug your database permissions further.

    I hope that helps!

    Thread Starter vgnavada

    (@vgnavada)

    Hi @aaronrobertshaw ,

    I was able to over come this issue by doing as follows:

    1. Backing up all individual tables in the effected DB manually and exporting it
    2. Creating a separate / new ec2 instance
    3. Manually importing the previously backed up DB tables one by one to the new instance’s DB
    4. Manually migrating the themes, plugins and uploads folders using SFTP.

    Thanks!

    • This reply was modified 1 year, 7 months ago by vgnavada.
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘WordPress database error: [Table ‘wp_options’ is read only]’ is closed to new replies.