Upgrading 5.0.0 to 5.0.1

Management and Administration
1

Hi, I am stuck and I am not able to navigate the forum. I have an installation of openemer 5.0.0 that I am attempting to upgrade. I am following the “Linux Upgrade 5.0.0 to 5.0.1” instructions. I am up to the sql_upgrade.php part. My files are writeable. But I am stuck. when I try the sql_upgrade.php I get an: “unable to handle request” message from the sever. The error log has:

PHP message: PHP Notice:  Undefined index: translate_no_safe_apostrophe in ...library/translation.inc.php on line 46
PHP message: PHP Fatal error:  Uncaught exception 'Exception' with message 'DateTime::__construct(): 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 the timezone 'UTC' for now, but please set date.timezone to select your timezone.' in .../common/database/Connector.php:132
Stack trace:
#0 .../common/database/Connector.php(132): DateTime->__construct()
#1 .../common/database/Connector.php(65): OpenEMR\Common\Database\Connector->createConnection()
#2 .../common/database/Connector.php(78): OpenEMR\Common\Database\Connector->__construct()
#3 /usr/hom" while reading response header from upstream, client: ##.##.##.##, server: ...openemr.net, request: "GET /sql_upgrade.php HTTP/1.1", upstream: "fastcgi:/../php-fpm.sock:", host: "...openemr.net"

I apologize if this is too verbose.
I have a new install of the 5.0.1 version which is working. I am not sure why the upgrade has stalled. I cannot find an answer. This is my set up:

freebsd 11.1
php5.6 (which I can upgrade if needed)
nginx 1.14
mysql 5.6.40

thanks

2

Hello, gutiersa.

Is it correct about your timezone setting? Dig out your webserver’s PHP ini file and take a look.

1 Like
3

This is what I have: America/New_York

4

And the line isn’t commented out or something?

5

No, it’s not

6

hi @gutiersa, could you check what phpinfo() is showing?

7

Hmm:

date
date/time support enabled
“Olson” Timezone Database Version 2016.10
Timezone Database internal
Default timezone UTC
Directive Local Value Master Value
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.583333 90.583333
date.sunset_zenith 90.583333 90.583333
date.timezone no value no value

sorry for the bad formatting.

8

and php -i | grep "php.ini"?

9

Cannot load the ionCube PHP Loader - extension already loaded
Configuration File (php.ini) Path => /usr/local/etc
Loaded Configuration File => /usr/local/etc/php.ini

1 Like
10

that might not be a prob since it’s checking for the php command line interpreter but it does point out the proper directory, here’s a tip from digital ocean, https://www.digitalocean.com/community/tutorials/how-to-install-an-nginx-mysql-and-php-femp-stack-on-freebsd-10-1

12

The thing is, that I have a working install of openemr 4.2.0 (3) in the same machine. I am thinking I should update my server first. However, I am not being able to find out openemr requirements.