error updating mydbr due to column user on mysql 8 db

(2 posts) (2 voices)


No tags yet.

  1. chadwickhung, Member

    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.

  2. myDBR Team, Key Master

    It is not a compatibility issue, but a configuration issue.

    The mydbr_favourite_folders-folder contains a foreign key constraint towards mydbr_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


You must log in to post.