ansky
Forum Replies Created
-
Emily @cleanup, to have mixed case letters on Windows you need to set MySQL option:
lower_case_table_names=2, or maybe it is also your DB software is not allowing it.To check the setting value you can run the query:
SELECT @@lower_case_table_names;But a simpler solution would just use lower case DB prefix in wp-config.php, just like umitdursoy said.
In my case, I already had
lower_case_table_names=2, and solving the problem was as easy as renaming the problematic table from lowercase to the name with uppercase letters. (But I had to rename it to something else first)Usually, you can’t rename table name from lowercase to uppercase just like that.
It will keep the previous name. To workaround that you need to rename it to something else and then rename to the name with an uppercase lettersThis is happening because MySQL configured to convert table names to lower case.
I think Migration_Runner::run_migrations() uses prefix set in wp-config to check if migration table exists.
To solve the problem rename your migration table from
ljf2yoast_migrationstoLJf2yoast_migrations