francois85000 wrote on Friday, January 06, 2017:
Hi, I have installed openemr on a webserver and I have experience some issue which I do not seems to be able to resolve. The first one is with the time zone. I keep getting the following:
Strict Standards: strftime(): It is not safe to rely on the system’s timezone settings. You are required to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected ‘Europe/Berlin’ for ‘CET/1.0/no DST’ instead in /homepages/23/d633616940/htdocs/openemr/interface/main/calendar/modules/PostCalendar/common.api.php on line 219
My other issue is with the mysql. I keep getting the following:
*ERROR: query failed: SELECT FROM langdefinitions JOIN langconstants ON langdefinitions.consid = langconstants.consid WHERE langid=? AND constantname = ? LIMIT 1
Error: Illegal mix of collations (latin1bin,IMPLICIT) and (utf8generalci,COERCIBLE) for operation ‘=’
/homepages/23/d633616940/htdocs/openemr/library/translation.inc.php at 36:sqlStatementNoLog
/homepages/23/d633616940/htdocs/openemr/library/globals.inc.php at 2426:xl(Māori)
/homepages/23/d633616940/htdocs/openemr/interface/super/editglobals.php at 13:requireonce(/homepages/23/d633616940/htdocs/openemr/library/globals.inc.php)
*
Also I must add that no matter what I do the server is utf8 and the tables are latin1.
Any ideas?