WordPress.org

1. Daemus
   Member
   Posted 5 months ago #

   Running 3.2.1, completely fresh install. First thing I did was install Better WP Security and start going through the security fixes.

   Trying to change the database prefix from wp_ to something random, it gives an error "Could not update prefix refences in options table."

   After that, if I try to access the admin area, I get the message "One or more database tables are unavailable. The database may need to be repaired." Outside the admin area, in the frontend, just a white page with "Error establishing a database connection".

   I used Better WP Security on another site 2 days ago to do the same thing without issue. The other site is on a separate hosting account with the same host and exact same versions of PHP, MySQL, etc.

   Any insight into what is going wrong would be appreciated.

2. kmessinger
   Member
   Posted 5 months ago #

   Why not go to the db itself. See what prefix was used and update the options table from within the db.

   As for what went wrong . . . one of those tiny things that carry data took a break and then forgot what he was doing.

3. Daemus
   Member
   Posted 5 months ago #

   Thank you for the reply. As for the "Why not [go do such and such]", I had no clue what to do. I am still learning this stuff and have not gotten to the point where I know what I am doing outside of installing plugins and doing some basic code editing.

   Thank you for the suggestion on what to do to fix it. I will read up a bit and give it a try.

4. kmessinger
   Member
   Posted 5 months ago #

   You may be able to talk your host into checking the db. It is pretty easy to work on (always have a backup!) even though it at first looks pretty scary. Normally you would edit it through your hosted site interface like v-deck, etc. From that interface you would most likely have mysql, etc. to make changes.

Reply

You must log in to post.