How did you move the site?
Thread Starter
matt4
(@matt4)
The host migrated the site for me using the function in WHM I think.
No idea what WHM is. But the error clearly happened during the migration by your host. Contact their support for clarification.
Thread Starter
matt4
(@matt4)
Sorry, it’s webhost manager a server administration platform. Thank you, I will be contacting them.
Thread Starter
matt4
(@matt4)
The webhost has investigated and drawn a blank. Said they are unable to help further. I am stumped :/
Do you still have a backup of the original web?
Thread Starter
matt4
(@matt4)
Yes, I do. Is it likely to be just the database?
Yes, it would be worth a try it. Unfortunately, I don’t know how you could proceed because I don’t know the technique used to create the backup.
Thread Starter
matt4
(@matt4)
So, I tried dropping the tables in the database and restoring but no luck. I can’t login. I tried restoring the current database and still can’t login it says I have no account!
My wp_users table doesn’t exist. I get this error when I restore. I’m recovering some older updates to see if they have a wp_users table.
#1032 - Can't find record in 'wp_useronline'
What could have happened?
Thread Starter
matt4
(@matt4)
I found a older database from 2022 and restored that then, restored the later database from today on top. Was able to login. Seems okay.
Thread Starter
matt4
(@matt4)
Can anyone provide any idea why this special character issue is happening? I’m lost.
Thread Starter
matt4
(@matt4)
Changed the DB_CHARSET in wp-config file to latin1.
And things worked….. š
define('DB_CHARSET', 'latin1');
define('DB_COLLATE', 'utf8mb4_general_ci');