DB error when attempting to add new group folder and/or session
DB error when attempting to add new group folder and/or session
When trying to enter a new group folder, or a new session, I am receiving a DB error. Please see attachment. Any help would be greatly appreciated!
DB Error.jpg
All Comments (5)
Hello,
What version of RDM are you running?
Have you upgraded recently?
Best regards,
Maurice
Version: 10.1.9.0
I upgraded the day after this version was released, but hadn't had this problem until today.
edited by cdeem on 2/26/2015
Hello,
We havent touched the mysql layer in months, has something happened on the server?
Maurice
We recently moved from one MariaDB server to another. We performed a dump of the SQL db and then restored it to the new server. There were no errors during that process in the logs, but this is also the first time that I've attempted to add an entry since the move.
I've resolved the problem. Evidently something within the schema had been corrupted. I exported all the entries from within the application to a local store. Then I dropped the database from MariaDB. Then I used the RDM to re-create the schema again from scratch. Once that completed, I ran the import routine from within the application and selected the file that I originally exported. Problem resolved!