Everything is updated and I can’t access neither of them
I’ve checked and the hosting updated the mysql version, not the php. They changed from 5.7 to 8
Hi.
Ok, so after the update of MySQL you lost access to WordPress-admin and Simple:Press-admin is that correct?
Best regards,
Joakim @ Simple:Press
The hosting just told me there’s an error in the table wp_sfmembers. The “admin” column is a reserved keyword in mysql 8
Hi!
You are correct that the `admin` word is or has been a reserved word. We are running MySQL `8.0.23` on our servers without any issues. From what i can read the documentation says that
ADMIN; became nonreserved in 8.0.12which means that using a MySQL version later than that should solve the issue.
Could you please check your MySQL version just to verify?
Best regards,
Joakim @ Simple:Press
Great, the hosting is giving me a hard time with this issue. I told them the encoding was also wrong and that I was seeing strange characters, and they told me it’s because of the keyword thing
Hi!
How has things worked out? Here is the link regarding the `admin` keyword if you need to show your hosting provider.
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Best regards,
Joakim @ Simple:Press