drjccaldwell wrote on Thursday, March 09, 2017:
I have pseudo successfully migrated an old system from linux to windows. Initial start went great on Windows with a clean install of OpenEMR. Imported data from old. No obvious problems there. Then imported MySQL DB dump file and ran script to upgrade.
Now I can log in with old user name and passwords so obviously most of it worked but I have this error:
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,
Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘’ at line 10
C:\xampp\htdocs\openemr\library\dated_reminder_functions.php at 47:sqlStatement
C:\xampp\htdocs\openemr\interface\main\dated_reminders\dated_reminders.php at 63:RemindersArray(5,1489014000,)
C:\xampp\htdocs\openemr\interface\main\messages\messages.php at 67:require_once(C:\xampp\htdocs\openemr\interface\main\dated_reminders\dated_reminders.php)
I have looked at the above named files but I am not a php programmer and I do not see any open parenthesis or other glaring issues.
Any ideas?
Thank you,
Clif