Endless database error

  • Ok, here it is. One of my sites is plagued by the terrible database error thing.
    Obviously my first move was to run the WordPress database fix thing by adapting the wp-config file and running the test.
    Then I addressed the issues that were given and -just to be safe- ran a PHP repair on the tables. At that point the WP database repair option gave me an “oke” at every step of the test.
    All is well, you would expect, but no, there was no change at all. The site still displayed the database error.

    So, what else did I try?

    • I set up a new database user and password (no change)
    • I have updated WP to the latest version
    • I removed the plugin and theme directories to remove any conflicting plugins/themes
    • I ran through the database to see whether there was any ‘siteurl’ references instead of the actual URL

    Needless to say, I am getting rather frustrated now. Any suggestions?

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Try exporting your database then re-importing it. That should force MySQL to rebuild all the tables.

    Allen McKenzie

    (@allenmcnichols)

    WordPress Mechanic

    Verify that your database connection setting entries in wp-config.php are in line with your hosting configuration.

    Many times I have seen this happen due to localhost or 127.0.0.1 not being a valid host because the hosting provider has a dedicated server to use for database connections.

    Another reason could be user permissions for the database user itself not having the granted permissions for a particular database.

    Moderator Jose Castaneda

    (@jcastaneda)

    THEME COFFEE MONKEY

    Hi there!

    As Allen mentioned, check with your host just in case as well. I’ve also seen instances where the database process had to be restarted because it either went idle or some maintenance routine.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Endless database error’ is closed to new replies.