Author Topic: On CentOS 7.3 - Date column is blank  (Read 3488 times)

Offline siestad

  • Newbie
  • *
  • Posts: 5
On CentOS 7.3 - Date column is blank
« on: July 12, 2017, 12:59:51 PM »
Just finished a new install and did a data migration from old server. All emails are there but the data is blank! I have set the php.ini as follows:

[Date]
; Defines the default timezone used by the date functions
; http://php.net/date.timezone
date.timezone = EST

Please advise!
Thanks


Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Re: On CentOS 7.3 - Date column is blank
« Reply #1 on: July 12, 2017, 01:07:29 PM »
1. You shouldn't use EST as that has been deprecated, you should use one of the others listed here: http://php.net/manual/en/timezones.php
2. Are you sure your editing the correct php.ini file? Some systems have different files for command line and web servers.
3. Did you restart the web server after making the change?

Offline siestad

  • Newbie
  • *
  • Posts: 5
Re: On CentOS 7.3 - Date column is blank
« Reply #2 on: July 12, 2017, 01:52:14 PM »
Thanks for the swift reply.

I have just changed it to my intial entry - America/New_York
It's the only php.ini file I can find
& I have restarted the web server several times

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Re: On CentOS 7.3 - Date column is blank
« Reply #3 on: July 12, 2017, 02:27:16 PM »
If you create a test.php file in the Roundcube directory with the following:
Code: [Select]
<?php
phpinfo
();

What does it say.

Offline siestad

  • Newbie
  • *
  • Posts: 5
Re: On CentOS 7.3 - Date column is blank
« Reply #4 on: July 12, 2017, 02:32:11 PM »
Build Date   Nov 6 2016 00:30:05
Server API   Apache 2.0 Handler
Virtual Directory Support   disabled
Configuration File (php.ini) Path   /etc
Loaded Configuration File   /etc/php.ini
Scan this dir for additional .ini files   /etc/php.d
Additional .ini files parsed   /etc/php.d/apcu.ini, /etc/php.d/bcmath.ini, /etc/php.d/curl.ini, /etc/php.d/dom.ini, /etc/php.d/fileinfo.ini, /etc/php.d/gd.ini, /etc/php.d/imap.ini, /etc/php.d/intl.ini, /etc/php.d/json.ini, /etc/php.d/ldap.ini, /etc/php.d/mbstring.ini, /etc/php.d/mcrypt.ini, /etc/php.d/mssql.ini, /etc/php.d/mysql.ini, /etc/php.d/mysqli.ini, /etc/php.d/odbc.ini, /etc/php.d/pdo.ini, /etc/php.d/pdo_dblib.ini, /etc/php.d/pdo_mysql.ini, /etc/php.d/pdo_odbc.ini, /etc/php.d/pdo_sqlite.ini, /etc/php.d/phar.ini, /etc/php.d/posix.ini, /etc/php.d/pspell.ini, /etc/php.d/snmp.ini, /etc/php.d/soap.ini, /etc/php.d/sqlite3.ini, /etc/php.d/sysvmsg.ini, /etc/php.d/sysvsem.ini, /etc/php.d/sysvshm.ini, /etc/php.d/tidy.ini, /etc/php.d/wddx.ini, /etc/php.d/xmlreader.ini, /etc/php.d/xmlrpc.ini, /etc/php.d/xmlwriter.ini, /etc/php.d/xsl.ini, /etc/php.d/zip.ini

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Re: On CentOS 7.3 - Date column is blank
« Reply #5 on: July 12, 2017, 02:50:51 PM »
What does it say is set for the date.timezone?

Offline siestad

  • Newbie
  • *
  • Posts: 5
Re: On CentOS 7.3 - Date column is blank
« Reply #6 on: July 12, 2017, 02:58:50 PM »
no value! This is what I have in the php.ini:

[Date]
; Defines the default timezone used by the date functions
; http://php.net/date.timezone
date.timezone = America/New_York


also tried:
date.timezone = "America/New_York"
« Last Edit: July 12, 2017, 03:02:16 PM by siestad »

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Re: On CentOS 7.3 - Date column is blank
« Reply #7 on: July 12, 2017, 03:25:17 PM »
The first way is the correct way for some reason that configuration isn't being loading. Are you sure you restarted the web server? Are you using php-fpm, if so there is a separate service that needs to be restarted.

Offline siestad

  • Newbie
  • *
  • Posts: 5
Re: On CentOS 7.3 - Date column is blank
« Reply #8 on: July 12, 2017, 03:29:01 PM »
Fixed it! I had accidentally removed the ; on another item in the config file..thanks for your help!!!