uctopuk wrote on Wednesday, March 06, 2013:
Greetings.
The hard drive on my linux box got toasted in a recent lightning storm. I have all of my files and databases backed up.
Since I had a Windows machine sitting around, I put Openemr 4.1 (the old version was 3.2?) on it and attempted to restore my databases (from the linux machine) following these directions: http://www.open-emr.org/wiki/index.php/Windows_OpenEMR_Restore_using_emr_backup.tar
Following the restore procedure, I am unable to log in with my admin account. I can log in with the doctor’s login (not my main issue). When I log in I get the following error in the menu frame: ERROR: query failed: SELECT * FROM code_types WHERE ct_active=1 ORDER BY ct_seq, ct_key
Error: Unknown column ‘ct_active’ in ‘where clause’
The top frame gives the following error: ERROR: query failed: select id, name, color from facility where service_location != 0
Error: Unknown column ‘color’ in ‘field list’
And the bottom frame says: Message and Reminder Center
Reminders
ERROR: query failed: SELECT dr.pid, dr.dr_id, dr.dr_message_text,dr.dr_message_due_date, u.fname ffname, u.mname fmname, u.lname flname FROM `dated_reminders` dr JOIN `users` u ON dr.dr_from_ID = u.id JOIN `dated_reminders_link` drl ON dr.dr_id = drl.dr_id WHERE drl.to_id = ? AND dr.`message_processed` = 0 AND dr.`dr_message_due_date` < ADDDATE(NOW(), INTERVAL 5 DAY) ORDER BY `dr_message_due_date` ASC , `message_priority` ASC LIMIT 0,5
So, my questions are 1) Is this a Linux/Windows issue? 2) An upgrade issue? 3) A combination of the two? 4) Would it be easiest to just rebuild a 3.2 on a linux box or attempt to repair these issues and stick with Windows?
Thanks.