Multiple WP installations, same database, can’t login now

  • Resolved _ze

    (@_ze)


    16 years, 4 months ago

    I originally setup a WP installation at the root of my domain. We then decided to add a jobs board, which required it’s own installation of WP. I installed that to a sub-directory.

    I followed the steps to renaming the WP table (prefixes), of the original WP installation on the root of the domain. Then when installing the 2nd WP installation, I made sure to change the table prefix to something different, while installing it to the same database. Everything seemed to be working fine, until I attempted to log into the original WP installation.

    When I login as Admin on the 1st WP installation, I get the following error: “You do not have sufficient permissions to access this page.”

    I can login to the 2nd WP admin fine.

    Is this because I installed the 2nd WP installation into a folder inside the root of the 1st WP installation? How can I fix it so that I can log into both admin areas without conflict?

    Thanks for any ideas you guys can share with me, as my head is red, from bashing it into my desk.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Samuel B

    (@samboll)

    16 years, 4 months ago

    I followed the steps to renaming the WP table (prefixes), of the original WP installation

    you should leave this at what was working originally – only change the 2nd install’s prefix

    Thread Starter _ze

    (@_ze)

    16 years, 4 months ago

    Thanks for your response samboll, but as I was waiting a response, I found another option. For security purposes, I felt I really wanted to change from the default wp_ table prefix.

    Anyhow, I got the problem fixed, and this is how I did it.

    I had originally only changed the table prefixes in the database, and updated the wp-config.php file to reflect the change. I had left out a few important steps that I found here. I had missed steps 4 and 5.

    I hadn’t thought to browse each table, and look for references to the old prefix in the rows and stored data. There were two places where I found I needed to update it. First in the old wp_options table, there was a wp_user_roles row. My wp_options table had 200+ rows, so I didn’t see it listed until I resorted my rows.

    Then inside the wp_usermeta table there were several values still using the old wp_ prefix.

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

The topic ‘Multiple WP installations, same database, can’t login now’ is closed to new replies.