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!
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?
then
RENAME table wp_commentmeta TO test_commentmeta;
RENAME table wp_comments TO test_comments;
RENAME table wp_links TO test_links;
RENAME table wp_options TO test_options;
RENAME table wp_postmeta TO test_postmeta;
RENAME table wp_posts TO test_posts;
RENAME table wp_terms TO test_terms;
RENAME table wp_termmeta TO test_termmeta;
RENAME table wp_term_relationships TO test_term_relationships;
RENAME table wp_term_taxonomy TO test_term_taxonomy;
RENAME table wp_usermeta TO test_usermeta;
RENAME table wp_users TO test_users;
then
SELECT * FROM test_options WHERE option_name LIKE ‘%wp_%’
then
SELECT * FROM test_usermeta WHERE meta_key LIKE ‘%wp_%’