iMisterK

Bump anyone?

ANOTHER ISSUE:

It’s permalink structure. Could this be because of lack of .htaccess?

https://139.162.241.186 I can log into the admin fully now.
https://139.162.241.186/directory/the-wolesley/ it gives out Not Found error however the data is present in the backend.

Ok so, ladies and gentlemen, I have found an issue while going through each damn table on the DB.

The prefix for usermeta was y4Hv0RJ rather than all lowercase… While I updated the wp-config to support it all in lowercase, some of the tables were still in uppercase.

What a ridiculous thing… Guess UNIX does not like lowercase?

You guys have no idea how happy I am.

No, I tried all tables, just wp_post and then only the siteurl and home rows in wp_options and all the same issue

Could a different MYSQL version cause this permission issue? Any way to forcefully add permissions to a user account via SQL query since i cant login to wp-admin?

I used Better Search Replace plugin to take all wp_post table urls that are pointing to the old server and replacing them with the new, still the same issue with permissions ??

Here is the process I am running which is causing this issue on both of my Linux Environments.

1) I zip up my core files on the IIS Windows Server and move them over to the Linux run server.

2) I go into phpmyadmin and run a SQL Quick Export (or modified unchecking few fields).

3) I import the Database via phpmyadmin and or mysql workbench (i have fasthost account and linode)

4) I update the _options table with the new domain URL/IP

5) I remove themename in _options so I can log into the wp-admin

6) When logged in, I get just a blank admin bar and directing to wp-admin just gives me “You do not have sufficient permissions to access this page.”

7) I created a new admin user via SQL query called “developer” and same issue happens. The permission level is 10 with the standard permission line but nothing seems to be working.

Could it be because of utf8 and utf8mb4 difference or something? Here is a dropbox to the Database.

https://db.misterk.me/dbissue.sql

Up you go #bump

bump

Used an Advanced Custom Field plugin and together with php include code I was able to create what I want.