I made a new site, added a few plugins then tried changing the db table prefixes for the site:
changed the prefix in wp-config then ran the appropriate sql commands directly via adminer and then I tried logging back into my site and I just get taken to the wp set-up page asking me to choose language, username etc… everything is gone, even though the database and local domain is there!
Anyone know what might have happened?
Did you change the database prefix in the
It’s hard to say exactly without seeing some of the specifics.
What tables that are in the database (ie, what do you see in Adminer) as well as what is the prefix is within the
wp-config.php file for the site?
You mention running some sql commands. What were the sql statements that were run?
I just created a test site to see exactly what the issue is - didn’t add any themes or plugins just to avoid them complicating the matter -
Literally just set-up a default wp site with one admin user -
then I changed the wp table prefixes -
- Changed on wp-config first
- then the 12 default tables in db via adminer
- options table
- meta table
Now when I sign in, i’m literally just getting a: ‘sorry, you are not allowed to access this page.’
Tried this with two different sites and getting the same response each time :-/
Didn’t get any errors when re-configuring. Any idea what the problem could be?
for prefix name ‘test_’
$table_prefix = ‘test_’
SELECT * FROM
SELECT * FROM
And that’s it
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.