I have an error updating mydbr
the error is about a column user of creating the table "my_dbr_favourite_folders". We are using mysql8, I think it is an compatibility issue. Please help asap.
Thanks
Chadwick
error updating mydbr due to column user on mysql 8 db
(2 posts) (2 voices)-
-
It is not a compatibility issue, but a configuration issue.
The
mydbr_favourite_folders
-folder contains a foreign key constraint towardsmydbr_userlogin
-table. If you installed myDBR using a charater set/collation (most likely UTF8) and are now running myDBR with another charater set (most likely utf8mb4), the charater sets between these two tables do not match, hence the error in foreign key creation.To fix the issue, take a look at this topic.
--
myDBR Team
Reply
You must log in to post.