CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • TimeZone Issues With Drupal
Pages: [1]

Author Topic: TimeZone Issues With Drupal  (Read 550 times)

jtattersall

  • I post occasionally
  • **
  • Posts: 33
  • Karma: 0
  • CiviCRM version: 4.5
  • CMS version: drupal 7
  • MySQL version: 5.1.70-cll
  • PHP version: 5.3.26
TimeZone Issues With Drupal
November 18, 2014, 03:40:42 am
Hi there, I am trying to correct civicrm to use my time zone which is London. My civicrm is hosted on a shard server my hosting provider is tmdhosting.com. I have Used Php.ini file to set my time zone this has worked but only change the timezone for update time and membershipe payment info not the change log which is still 1 hour out. it  is somthiing to do with my sql time i am unable to change i have even tred code in htaccese file to update this but with no luck. i have looked at civicrm files  and tryed to set it there becase have done this priverly with drupal set up but can't remember how i did it. has anyone got any ideas on how i can do this.

My  Cms id Drupal 7 Lastest version

My civicrm is 4.5.3

JoeMurray

  • Administrator
  • Ask me questions
  • *****
  • Posts: 578
  • Karma: 24
    • JMA Consulting
  • CiviCRM version: 4.4 and 4.5 (as of Nov 2014)
  • CMS version: Drupal, WordPress, Joomla
  • MySQL version: MySQL 5.5, 5.6, MariaDB 10.0 (as of Nov 2014)
Re: TimeZone Issues With Drupal
March 03, 2015, 02:26:33 pm
PHP and MySQL have their own settings for timezones.

You need to change the MySQL timezone for the MySQL server (NB: not for the session and not for a specific command) so that it is the same as the one that PHP is set to. See http://stackoverflow.com/questions/3451847/mysql-timezone-change, or http://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html.
Co-author of Using CiviCRM https://www.packtpub.com/using-civicrm/book
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • TimeZone Issues With Drupal

This forum was archived on 2017-11-26.