Details
-
Type: Improvement
-
Status: Done/Fixed
-
Priority: Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.5.4, 4.6.9, 4.6.11, 4.7.7
-
Fix Version/s: 4.7.10
-
Component/s: Core CiviCRM, Joomla Integration
-
Labels:
-
Documentation Required?:User and Admin Doc
-
Sprint:4.7.11 Security
-
Funding Source:Contributed Code
Description
CiviCRM detects a mismatch between the PHP and MySQL time zones. We are in a shared hosting environment where the system and MySQL time zone is different to the one we want to use in PHP, so we get warning messages and there are time stamp issues. We do not have the necessary rights on MySQL to change its time zone globally, so it seems more sensible to do it on a session by session basis. I noticed that CRM/Core/DAO.php seems to do a SET NAMES utf8 each time it sets up a connection to the database. It would therefore seem sensible to change the time zone at that point, too. You CiviCRM experts may see a problem with this, but I offer this diff file (from 4.5.4) in case it is helpful. You may want it to be a setting you configure in the global setup, but my knowledge doesn't run to that.
Attachments
Issue Links
- links to