Better WP Security – Database Error

  • Daemus

    (@daemus)


    12 years, 4 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.

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

    (@kmessinger)

    12 years, 4 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.

    Thread Starter Daemus

    (@daemus)

    12 years, 4 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.

    kmessinger

    (@kmessinger)

    12 years, 4 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.

    skippyskippy@freenet.de

    (@skippyskippyfreenetde)

    11 years, 6 months ago

    yes check your prefix…

    skippyskippy@freenet.de

    (@skippyskippyfreenetde)

    11 years, 6 months ago

    And those having this white empty page with “error”:

    I have found how to fix this white blank space with “error”

    1.Go to :
    Better WP Security – Administor Away Mode

    2.check the box:
    Enable Away Mode
    3.Type of Restriction select time. Let the date be the current on to the next day.
    Set expired time. Lets say if it is now 12.PM, set it to 10AM and expiring time also to 10:02AM

    Thats a ill..

    REASON:
    The reason is, when the session expires, your user name and IP will be blocked for some time ….. But it is for a security reason since when you access your admin in an internet shop and forget to logout, the seesion will ustj expire and no one …. could access the admin panel.

    However, if you are 24 hours closer to your admin or whatever, just enable to away mode!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Better WP Security – Database Error’ is closed to new replies.