Upgrading from Mysql 5.7 to mysql 8
Hello, i want to upgrade my mysql server since this year is getting deprecated. I want to know if there is some pain free solution to this.
I checked all the tables to see if they are compatible with mysql 8.0 and all were OK. Then i dumped the mysql 5.7 db and Imported it in the new mysql 8 server. When i loaded CA again all seem to work just fine. The problem began when i tried to save (with no real changes to) already existing records with links ocurrences and entities (e.g exhibitions and curators).
I got the following errors:
Entity id % is invalid for element <metada_element_eg>
Ocurrence id % is invalid for element <metada_element_eg>
I tried to fix it all day long. the most notorious thing i saw was that after changing databases. the entity/ocurrence id was printed next to the entity/ocurrence name, for example.
In field Curator: John Smith [18], Exhibition: Big Exhibition [9].
But no matter what i introduced in those fields the problem persisted.
I appreciate your help so much. (I am Attaching the error file, its in Spanish, but the relevant part i already translated it above)
Comments
I don't believe this has to do with the database upgrade. What else did you change?
Well, i was using MAMP to run Apache and mysql. And now im trying to get rid of the app to run those services natively. So thats whats different. I still can switch back and forward between deployments and with MAMP works with no problems.
What is normally the problem when this happens?
What version are you running? Did you copy all of your local configuration files to the new set up?
The release version 1.7.16 and I didn't copy anything, just linked the document root of the new apache instance to the same providence folder.
If you switch back to 5.7 does the problem resolve?
Yes, it does.