Error Upgrade 4.2.2 to 5.0.1

Support
1

(thanks for pointing me to this forum - I had this posted on the old sourceforge forum first)

Hi,

I tried my upgrade to 5.0.1 today (from 4.2.2) on an Ubuntu 16.04 and am running into a problem, and hope that somebody is able to help me debugging this.
I get the following error after logging in:

Query Error
ERROR: insert failed: INSERT INTO log_comment_encrypt (log_id, encrypt, checksum, version) VALUES ( ‘12’,‘No’,’’, ‘1’)
Error: Unknown column ‘version’ in ‘field list’
/var/www/openemr/library/log.inc at 55:sqlInsertClean_audit
/var/www/openemr/library/auth.inc at 84:newEvent(login,0,insufficient data sent)
/var/www/openemr/interface/globals.php at 567:include_once(/var/www/openemr/library/auth.inc)
/var/www/openemr/interface/main/main_screen.php at 25:require_once(/var/www/openemr/interface/globals.php)

I checked that table in the database and it has no such field ‘version’, neither in the db before or after the update. The database update must have run because all my tables are now InnoDB (except form_eye_mag) while before the update I had many MyISAM.

The table with the error has changed slightly in the
AFTER:
CREATE TABLE log_comment_encrypt (
id int(11) NOT NULL,
log_id int(11) NOT NULL,
encrypt enum(‘Yes’,‘No’) NOT NULL DEFAULT ‘No’,
checksum longtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

and BEFORE:
CREATE TABLE log_comment_encrypt (
id int(11) NOT NULL,
log_id int(11) NOT NULL,
encrypt enum(‘Yes’,‘No’) NOT NULL DEFAULT ‘No’,
checksum longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

version in my database.

When I installed I did run the commands in the instructions:
wget downloads.sourceforge.net/openemr/openemr-php7_5.0.1-2_all.deb
apt-get update
dpkg -i openemr-php7_5.0.1-2_all.deb

and did get an error on the third command and had to run
apt-get install -f

which then finished without a problem.
What might have gone wrong?

Thanks,
Merlin

2

hi @MerlinSilk ,

Looks like sql upgrade script may not of completed.

What are you seeing in the below 2 files(sorry I can’t recall the exact names of files):
/etc/openemr/
/var/log/openemr/

-brady

3

Hi Brady, thanks for the reply.
The /etc/openemr/openemr.conf file has the following content:
#Optional settings
#(currently empty, plan to use in subsequent versions of OpenEMR)

#Installation settings

(DO NOT EDIT below!!!)

process=complete

And the installation log is rather long. I had hoped for a file-attach option here in the forum, but as there is not I just copy and paste it below.

Thanks again for looking into this,
Merlin

Sat Sep 30 22:04:11 PDT 2017: Configuring package…
Sat Sep 30 22:04:11 PDT 2017: Installing OpenEMR
Sat Sep 30 22:04:11 PDT 2017: Configuring PHP for OpenEMR
Sat Sep 30 22:04:11 PDT 2017: We changed the following setting(s) in your php configuration file at /etc/php/7.0/apache2/php.ini :
Sat Sep 30 22:05:19 PDT 2017: (We have placed a backup of your php configuration at /etc/php/7.0/apache2/php.ini.BAK)
Sat Sep 30 22:05:19 PDT 2017: Successfully set max_execution_time = 60
Sat Sep 30 22:05:19 PDT 2017: Successfully set max_input_time = 90
Sat Sep 30 22:05:19 PDT 2017: Successfully set post_max_size = 30M
Sat Sep 30 22:05:19 PDT 2017: Successfully set upload_max_filesize = 30M
Sat Sep 30 22:05:19 PDT 2017: Successfully set max_input_vars = 3000
Sat Sep 30 22:05:19 PDT 2017: Done configuring PHP
Sat Sep 30 22:05:19 PDT 2017: Activate OpenEMR config file for Apache
Sat Sep 30 22:05:19 PDT 2017: Restarting Apache service…
Sat Sep 30 22:05:29 PDT 2017: Passed the mysql check loop
Sat Sep 30 22:05:29 PDT 2017: Installing/Configuring OpenEMR…
PHP Notice: Undefined index: iufname in /var/www/openemr/library/classes/Installer.class.php on line 16
PHP Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘openemr’@‘localhost’ (using password: YES) in /var/www/openemr/library/classes/Installer.class.php on line 470
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Only variables should be passed by reference in /var/www/openemr/library/adodb/adodb-xmlschema.inc.php on line 268
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1122
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1122
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1122
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1122
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1122
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1122
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1122
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1122
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1122
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1122
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1122
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1122
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1122
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1122
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1122
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1122
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1122
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Array to string conversion in /var/www/openemr/gacl/gacl_api.class.php on line 1077
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1089
PHP Notice: Only variables should be assigned by reference in /var/www/openemr/gacl/gacl_api.class.php on line 1122
Configuration:

driver = mysqli,

host = localhost,

user = openemr,

database = openemr,

table prefix = gacl_Testing database connection…

Success! Connected to “mysqli” database on “localhost”.

Testing database type…

Success! Compatible database type “mysqli” detected!

Making sure database “openemr” exists…

Success! Good, database “openemr” already exists!

Success!
First Step of Access Control Installation Successful!!!

OpenEMR ACL Setup OpenEMR ACL Setup
All done configuring and installing access controls (php-GACL)!

Sat Sep 30 22:06:22 PDT 2017: Done configuring OpenEMR
Sat Sep 30 22:06:39 PDT 2017: You can now use OpenEMR by browsing to:
Sat Sep 30 22:06:39 PDT 2017: http://localhost/openemr
Sat Sep 30 22:06:39 PDT 2017: user is ‘admin’ and password is ‘pass’
Sat Sep 30 22:06:39 PDT 2017: See the openemr man page for further instructions:
Sat Sep 30 22:06:39 PDT 2017: type ‘man openemr’ at command line
Sat Sep 30 22:13:12 PDT 2017: Unable to upgrade from 4.2.2-1 version package with package method, so can not upgrade the OpenEMR Package.
Sat Sep 30 22:13:12 PDT 2017: EXITING…
Wed May 30 21:20:02 PDT 2018: For upgrade, confirmed that the mysql database (openemr) and mysql user (openemr) exist
Wed May 30 21:22:33 PDT 2018: Upgrading OpenEMR from 4.2.2-1…
Wed May 30 21:23:39 PDT 2018: Configuring package…
Wed May 30 21:23:39 PDT 2018: Continuing Upgrade from (4.2.2-1)
Wed May 30 21:23:39 PDT 2018: Activate OpenEMR config file for Apache
Wed May 30 21:23:39 PDT 2018: Restarting Apache service…
Wed May 30 21:23:44 PDT 2018: Configuring Site (default)
PHP Notice: Undefined index: translate_no_safe_apostrophe in /var/www/openemr/library/translation.inc.php on line 46
PHP Notice: Undefined index: translate_no_safe_apostrophe in /var/www/openemr/library/translation.inc.php on line 46

OpenEMR Database Upgrade OpenEMR Database Upgrade
Processing 4_2_2-to-5_0_0_upgrade.sql ...
Starting conversion of *TEXT types to use default NULL.
amendments.amendment_desc sql column was successfully converted to text with default NULL setting.
amendments_history.amendment_note sql column was successfully converted to text with default NULL setting.
ar_activity.follow_up_note sql column was successfully converted to text with default NULL setting.
ar_session.description sql column was successfully converted to text with default NULL setting.
audit_details.field_value sql column was successfully converted to text with default NULL setting.
audit_master.comments sql column was successfully converted to text with default NULL setting.
automatic_notification.message sql column was successfully converted to text with default NULL setting.
clinical_rules_log.value sql column was successfully converted to text with default NULL setting.
clinical_rules_log.new_value sql column was successfully converted to text with default NULL setting.
customlists.cl_list_item_long sql column was successfully converted to text with default NULL setting.
documents_legal_detail.dld_denial_reason sql column was successfully converted to longtext with default NULL setting.
facility_user_ids.field_value sql column was successfully converted to text with default NULL setting.
form_scanned_notes.notes sql column was successfully converted to text with default NULL setting.
history_data.exams sql column was successfully converted to text with default NULL setting.
history_data.usertext11 sql column was successfully converted to text with default NULL setting.
history_data.userarea11 sql column was successfully converted to text with default NULL setting.
history_data.userarea12 sql column was successfully converted to text with default NULL setting.
history_data.almed sql column was successfully converted to text with default NULL setting.
history_data.prevop sql column was successfully converted to text with default NULL setting.
history_data.exphiv sql column was successfully converted to text with default NULL setting.
history_data.reaane sql column was successfully converted to text with default NULL setting.
history_data.incbleed sql column was successfully converted to text with default NULL setting.
history_data.bloodtrans sql column was successfully converted to text with default NULL setting.
history_data.psych sql column was successfully converted to text with default NULL setting.
history_data.glasses sql column was successfully converted to text with default NULL setting.
history_data.contacts sql column was successfully converted to text with default NULL setting.
history_data.scarring sql column was successfully converted to text with default NULL setting.
history_data.yeswhere sql column was successfully converted to text with default NULL setting.
history_data.otherinfo sql column was successfully converted to text with default NULL setting.
lang_custom.constant_name sql column was successfully converted to mediumtext with default NULL setting.
lang_custom.definition sql column was successfully converted to mediumtext with default NULL setting.
layout_options.conditions sql column was successfully converted to text with default NULL setting.
lbf_data.field_value sql column was successfully converted to text with default NULL setting.
lbt_data.field_value sql column was successfully converted to text with default NULL setting.
log_comment_encrypt.checksum sql column was successfully converted to longtext with default NULL setting.
notification_log.message sql column was successfully converted to text with default NULL setting.
notification_log.patient_info sql column was successfully converted to text with default NULL setting.
patient_data.other02 sql column was successfully converted to text with default NULL setting.
patient_data.primdoc sql column was successfully converted to text with default NULL setting.
patient_data.primphone sql column was successfully converted to text with default NULL setting.
patient_data.primaddr sql column was successfully converted to text with default NULL setting.
patient_data.advdir sql column was successfully converted to text with default NULL setting.
patient_data.advdirloc sql column was successfully converted to text with default NULL setting.
patient_data.permcontact sql column was successfully converted to text with default NULL setting.
patient_data.patref sql column was successfully converted to text with default NULL setting.
patient_data.memtype sql column was successfully converted to text with default NULL setting.
patient_data.memstart sql column was successfully converted to text with default NULL setting.
patient_data.memend sql column was successfully converted to text with default NULL setting.
patient_data.memnotes sql column was successfully converted to text with default NULL setting.
patient_data.notes sql column was successfully converted to text with default NULL setting.
patient_data.industry sql column was successfully converted to text with default NULL setting.
patient_data.billing_note sql column was successfully converted to text with default NULL setting.
procedure_order.patient_instructions sql column was successfully converted to text with default NULL setting.
procedure_order_code.diagnoses sql column was successfully converted to text with default NULL setting.
procedure_providers.notes sql column was successfully converted to text with default NULL setting.
procedure_questions.options sql column was successfully converted to text with default NULL setting.
procedure_report.report_notes sql column was successfully converted to text with default NULL setting.
procedure_result.comments sql column was successfully converted to text with default NULL setting.
rule_action_item.reminder_message sql column was successfully converted to text with default NULL setting.
shared_attributes.field_value sql column was successfully converted to text with default NULL setting.
ALTER TABLE `ar_activity` MODIFY `sequence_no` int UNSIGNED NOT NULL COMMENT 'Sequence_no, incremented in code'
ALTER TABLE `ar_activity` ENGINE="InnoDB"
ALTER TABLE `claims` MODIFY `version` int(10) UNSIGNED NOT NULL COMMENT 'Version, incremented in code'
ALTER TABLE `claims` ENGINE="InnoDB"
ALTER TABLE `procedure_answers` MODIFY `answer_seq` int(11) NOT NULL COMMENT 'Supports multiple-choice questions. Answer_seq, incremented in code'
ALTER TABLE `procedure_answers` ENGINE="InnoDB"
ALTER TABLE `procedure_order_code` MODIFY `procedure_order_seq` int(11) NOT NULL COMMENT 'Supports multiple tests per order. Procedure_order_seq incremented in code'
ALTER TABLE `procedure_order_code` ENGINE="InnoDB"
Starting migration to InnoDB, please wait.
Table addresses migrated to InnoDB.
Table amc_misc_data migrated to InnoDB.
Table amendments migrated to InnoDB.
Table amendments_history migrated to InnoDB.
Table ar_session migrated to InnoDB.
Table array migrated to InnoDB.
Table audit_details migrated to InnoDB.
Table audit_master migrated to InnoDB.
Table background_services migrated to InnoDB.
Table batchcom migrated to InnoDB.
Table billing migrated to InnoDB.
Table categories migrated to InnoDB.
Table categories_seq migrated to InnoDB.
Table categories_to_documents migrated to InnoDB.
Table chart_tracker migrated to InnoDB.
Table clinical_plans migrated to InnoDB.
Table clinical_plans_rules migrated to InnoDB.
Table clinical_rules migrated to InnoDB.
Table clinical_rules_log migrated to InnoDB.
Table code_types migrated to InnoDB.
Table codes migrated to InnoDB.
Table config migrated to InnoDB.
Table config_seq migrated to InnoDB.
Table dated_reminders migrated to InnoDB.
Table dated_reminders_link migrated to InnoDB.
Table direct_message_log migrated to InnoDB.
Table documents migrated to InnoDB.
Table documents_legal_categories migrated to InnoDB.
Table documents_legal_detail migrated to InnoDB.
Table documents_legal_master migrated to InnoDB.
Table drug_inventory migrated to InnoDB.
Table drug_sales migrated to InnoDB.
Table drug_templates migrated to InnoDB.
Table drugs migrated to InnoDB.
Table eligibility_response migrated to InnoDB.
Table eligibility_verification migrated to InnoDB.
Table employer_data migrated to InnoDB.
Table enc_category_map migrated to InnoDB.
Table extended_log migrated to InnoDB.
Table facility migrated to InnoDB.
Table facility_user_ids migrated to InnoDB.
Table fee_sheet_options migrated to InnoDB.
Table form_dictation migrated to InnoDB.
Table form_encounter migrated to InnoDB.
Table form_misc_billing_options migrated to InnoDB.
Table form_reviewofs migrated to InnoDB.
Table form_ros migrated to InnoDB.
Table form_scanned_notes migrated to InnoDB.
Table form_soap migrated to InnoDB.
Table form_vitals migrated to InnoDB.
Table form_vitalsm migrated to InnoDB.
Table forms migrated to InnoDB.
Table geo_country_reference migrated to InnoDB.
Table geo_zone_reference migrated to InnoDB.
Table globals migrated to InnoDB.
Table gprelations migrated to InnoDB.
Table groups migrated to InnoDB.
Table history_data migrated to InnoDB.
Table icd10_dx_order_code migrated to InnoDB.
Table icd10_gem_dx_10_9 migrated to InnoDB.
Table icd10_gem_dx_9_10 migrated to InnoDB.
Table icd10_gem_pcs_10_9 migrated to InnoDB.
Table icd10_gem_pcs_9_10 migrated to InnoDB.
Table icd10_pcs_order_code migrated to InnoDB.
Table icd10_reimbr_dx_9_10 migrated to InnoDB.
Table icd10_reimbr_pcs_9_10 migrated to InnoDB.
Table icd9_dx_code migrated to InnoDB.
Table icd9_dx_long_code migrated to InnoDB.
Table icd9_sg_code migrated to InnoDB.
Table icd9_sg_long_code migrated to InnoDB.
Table immunizations migrated to InnoDB.
Table insurance_companies migrated to InnoDB.
Table insurance_data migrated to InnoDB.
Table insurance_numbers migrated to InnoDB.
Table integration_mapping migrated to InnoDB.
Table issue_encounter migrated to InnoDB.
Table issue_types migrated to InnoDB.
Table lang_constants migrated to InnoDB.
Table lang_custom migrated to InnoDB.
Table lang_definitions migrated to InnoDB.
Table lang_languages migrated to InnoDB.
Table layout_options migrated to InnoDB.
Table lbf_data migrated to InnoDB.
Table lbt_data migrated to InnoDB.
Table list_options migrated to InnoDB.
Table lists migrated to InnoDB.
Table lists_touch migrated to InnoDB.
Table log migrated to InnoDB.
Table notes migrated to InnoDB.
Table onotes migrated to InnoDB.
Table openemr_module_vars migrated to InnoDB.
Table openemr_modules migrated to InnoDB.
Table openemr_postcalendar_categories migrated to InnoDB.
Table openemr_postcalendar_events migrated to InnoDB.
Table openemr_postcalendar_limits migrated to InnoDB.
Table openemr_postcalendar_topics migrated to InnoDB.
Table openemr_session_info migrated to InnoDB.
Table patient_access_offsite migrated to InnoDB.
Table patient_access_onsite migrated to InnoDB.
Table patient_data migrated to InnoDB.
Table patient_reminders migrated to InnoDB.
Table patient_tracker migrated to InnoDB.
Table patient_tracker_element migrated to InnoDB.
Table payments migrated to InnoDB.
Table pharmacies migrated to InnoDB.
Table phone_numbers migrated to InnoDB.
Table pma_bookmark migrated to InnoDB.
Table pma_column_info migrated to InnoDB.
Table pma_history migrated to InnoDB.
Table pma_pdf_pages migrated to InnoDB.
Table pma_relation migrated to InnoDB.
Table pma_table_coords migrated to InnoDB.
Table pma_table_info migrated to InnoDB.
Table pnotes migrated to InnoDB.
Table prescriptions migrated to InnoDB.
Table prices migrated to InnoDB.
Table procedure_order migrated to InnoDB.
Table procedure_providers migrated to InnoDB.
Table procedure_questions migrated to InnoDB.
Table procedure_report migrated to InnoDB.
Table procedure_result migrated to InnoDB.
Table procedure_type migrated to InnoDB.
Table product_warehouse migrated to InnoDB.
Table registry migrated to InnoDB.
Table report_itemized migrated to InnoDB.
Table report_results migrated to InnoDB.
Table rule_action migrated to InnoDB.
Table rule_action_item migrated to InnoDB.
Table rule_filter migrated to InnoDB.
Table rule_patient_data migrated to InnoDB.
Table rule_reminder migrated to InnoDB.
Table rule_target migrated to InnoDB.
Table sequences migrated to InnoDB.
Table standardized_tables_track migrated to InnoDB.
Table supported_external_dataloads migrated to InnoDB.
Table syndromic_surveillance migrated to InnoDB.
Table template_users migrated to InnoDB.
Table transactions migrated to InnoDB.
Table user_settings migrated to InnoDB.
Table users migrated to InnoDB.
Table version migrated to InnoDB.
Table x12_partners migrated to InnoDB.
CREATE TABLE `valueset` ( `nqf_code` varchar(255) NOT NULL DEFAULT '', `code` varchar(255) NOT NULL DEFAULT '', `code_system` varchar(255) NOT NULL DEFAULT '', `code_type` varchar(255) DEFAULT NULL, `valueset` varchar(255) NOT NULL DEFAULT '', `description` varchar(255) DEFAULT NULL, `valueset_name` varchar(500) DEFAULT NULL, PRIMARY KEY (`nqf_code`,`code`,`valueset`)) ENGINE=InnoDB
ALTER TABLE `openemr_postcalendar_categories` ADD `pc_active` tinyint(1) NOT NULL DEFAULT 1
ALTER TABLE `openemr_postcalendar_categories` ADD `pc_seq` int(11) NOT NULL DEFAULT '0'
UPDATE `openemr_postcalendar_categories` set pc_seq = pc_catid
SET @catid = (SELECT MAX(pc_catid) FROM openemr_postcalendar_categories)
INSERT INTO `openemr_postcalendar_categories` (`pc_catid`, `pc_catname`, `pc_catcolor`, `pc_catdesc`, `pc_recurrtype`, `pc_enddate`, `pc_recurrspec`, `pc_recurrfreq`, `pc_duration`, `pc_end_date_flag`, `pc_end_date_type`, `pc_end_date_freq`, `pc_end_all_day`, `pc_dailylimit`, `pc_cattype`, `pc_active`, `pc_seq`) VALUES (@catid+1, 'Health and Behavioral Assessment', '#C7C7C7', 'Health and Behavioral Assessment', 0, NULL, 'a:5:{s:17:"event_repeat_freq";s:1:"0";s:22:"event_repeat_freq_type";s:1:"0";s:19:"event_repeat_on_num";s:1:"1";s:19:"event_repeat_on_day";s:1:"0";s:20:"event_repeat_on_freq";s:1:"0";}', 0, 900, 0, 0, 0, 0, 0,0,1,@catid+1)
INSERT INTO `enc_category_map` ( `rule_enc_id`, `main_cat_id` ) VALUES ('enc_hea_and_beh', @catid+1)
SET @catid = (SELECT MAX(pc_catid) FROM openemr_postcalendar_categories)
INSERT INTO `openemr_postcalendar_categories` (`pc_catid`, `pc_catname`, `pc_catcolor`, `pc_catdesc`, `pc_recurrtype`, `pc_enddate`, `pc_recurrspec`, `pc_recurrfreq`, `pc_duration`, `pc_end_date_flag`, `pc_end_date_type`, `pc_end_date_freq`, `pc_end_all_day`, `pc_dailylimit`, `pc_cattype`, `pc_active`, `pc_seq`) VALUES (@catid+1, 'Preventive Care Services', '#CCCCFF', 'Preventive Care Services', 0, NULL, 'a:5:{s:17:"event_repeat_freq";s:1:"0";s:22:"event_repeat_freq_type";s:1:"0";s:19:"event_repeat_on_num";s:1:"1";s:19:"event_repeat_on_day";s:1:"0";s:20:"event_repeat_on_freq";s:1:"0";}', 0, 900, 0, 0, 0, 0, 0,0,1,@catid+1)
INSERT INTO `enc_category_map` ( `rule_enc_id`, `main_cat_id` ) VALUES ('enc_pre_ind_counsel', @catid+1)
INSERT INTO `enc_category_map` ( `rule_enc_id`, `main_cat_id` ) VALUES ('enc_pre_med_group_counsel', @catid+1)
INSERT INTO `enc_category_map` ( `rule_enc_id`, `main_cat_id` ) VALUES ('enc_pre_med_other_serv', @catid+1)
INSERT INTO `enc_category_map` ( `rule_enc_id`, `main_cat_id` ) VALUES ('enc_pre_med_ser_18_older', @catid+1)
INSERT INTO `enc_category_map` ( `rule_enc_id`, `main_cat_id` ) VALUES ('enc_pre_med_ser_40_older', @catid+1)
SET @max_seq = (select max(seq) from list_options where list_id = 'order_type')
INSERT INTO `list_options` (`list_id`,`option_id`,`title`,`seq`,`is_default`) values ('order_type','enc_checkup_procedure','Encounter Checkup Procedure',@max_seq+10,0)
UPDATE `clinical_rules` set `cqm_nqf_code` = '0018' where `id` = 'rule_htn_bp_measure_cqm'
CREATE TABLE calendar_external ( `id` INT NOT NULL AUTO_INCREMENT, `date` DATE NOT NULL, `description` VARCHAR(45) NOT NULL, `source` VARCHAR(45) NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB
INSERT INTO `openemr_postcalendar_categories` (`pc_catid`, `pc_catname`, `pc_catcolor`, `pc_catdesc`, `pc_recurrtype`, `pc_enddate`, `pc_recurrspec`, `pc_recurrfreq`, `pc_duration`, `pc_end_date_flag`, `pc_end_date_type`, `pc_end_date_freq`, `pc_end_all_day`, `pc_dailylimit`, `pc_cattype`, `pc_active`, `pc_seq`)VALUES (6,'Holidays','#9676DB','Clinic holiday',0,NULL,'a:5:{s:17:"event_repeat_freq";s:1:"1";s:22:"event_repeat_freq_type";s:1:"4";s:19:"event_repeat_on_num";s:1:"1";s:19:"event_repeat_on_day";s:1:"0";s:20:"event_repeat_on_freq";s:1:"0";}',0,86400,1,3,2,0,0,2,1,6)
INSERT INTO `openemr_postcalendar_categories` (`pc_catid`, `pc_catname`, `pc_catcolor`, `pc_catdesc`, `pc_recurrtype`, `pc_enddate`, `pc_recurrspec`, `pc_recurrfreq`, `pc_duration`, `pc_end_date_flag`, `pc_end_date_type`, `pc_end_date_freq`, `pc_end_all_day`, `pc_dailylimit`, `pc_cattype`, `pc_active`, `pc_seq`)VALUES (7,'Closed','#2374AB','Clinic closed',0,NULL,'a:5:{s:17:"event_repeat_freq";s:1:"1";s:22:"event_repeat_freq_type";s:1:"4";s:19:"event_repeat_on_num";s:1:"1";s:19:"event_repeat_on_day";s:1:"0";s:20:"event_repeat_on_freq";s:1:"0";}',0,86400,1,3,2,0,0,2,1,7)
ALTER TABLE `immunizations` ADD COLUMN `information_source` VARCHAR(31) DEFAULT NULL
ALTER TABLE `immunizations` ADD COLUMN `refusal_reason` VARCHAR(31) DEFAULT NULL
ALTER TABLE `immunizations` ADD COLUMN `ordering_provider` INT(11) DEFAULT NULL
INSERT INTO list_options (list_id, option_id, title) VALUES ('lists','immunization_registry_status','Immunization Registry Status')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('immunization_registry_status','active','Active','A', '10')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('immunization_registry_status','inactive_lost_to_follow_up','Inactive - Lost to follow - up','L', '20')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('immunization_registry_status','inactive_moved_gone_elsewhere','Inactive - Moved or gone elsewhere','M', '30')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('immunization_registry_status','inactive_permanently_inactive','Inactive - Permanently inactive','P', '40')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('immunization_registry_status','inactive_unspecified','Inactive - Unspecified','I', '50')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('immunization_registry_status','unknown','Unknown','U', '60')
INSERT INTO list_options (list_id, option_id, title) VALUES ('lists','publicity_code','Publicity Code')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('publicity_code','no_reminder_recall','No reminder/recall','SI', '10')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('publicity_code','reminder_recall_any_method','Reminder/recall - any method','02', '20')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('publicity_code','reminder_recall_no_calls','Reminder/recall - no calls','03', '30')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('publicity_code','reminder_only_any_method','Reminder only - any method','04', '40')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('publicity_code','reminder_only_no_calls','Reminder only - no calls','05', '50')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('publicity_code','recall_only_any_method','Recall only - any method','06', '60')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('publicity_code','recall_only_no_calls','Recall only - no calls','07', '70')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('publicity_code','reminder_recall_to_provider','Reminder/recall - to provider','08', '80')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('publicity_code','reminder_to_provider','Reminder to provider','09', '90')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('publicity_code','reminder_to_provider_no_recall','Only reminder to provider, no recall','10', '100')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('publicity_code','recall_to_provider','Recall to provider','11', '110')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('publicity_code','recall_to_provider_no_reminder','Only recall to provider, no reminder','12', '120')
INSERT INTO list_options (list_id, option_id, title) VALUES ('lists','immunization_refusal_reason','Immunization Refusal Reason')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('immunization_refusal_reason','parental_decision','Parental decision','00', '10')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('immunization_refusal_reason','religious_exemption','Religious exemption','01', '20')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('immunization_refusal_reason','other','Other','02', '30')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('immunization_refusal_reason','patient_decision','Patient decision','03', '40')
INSERT INTO list_options (list_id, option_id, title) VALUES ('lists','immunization_informationsource','Immunization Information Source')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('immunization_informationsource','new_immunization_record','New Immunization Record','00', '10')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('immunization_informationsource','hist_inf_src_unspecified','Historical information -source unspecified','01', '20')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('immunization_informationsource','other_provider','Other Provider','02', '30')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('immunization_informationsource','parent_written_record','Parent Written Record','03', '40')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('immunization_informationsource','parent_recall','Parent Recall','04', '50')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('immunization_informationsource','other_registry','Other Registry','05', '60')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('immunization_informationsource','birth_certificate','Birth Certificate','06', '70')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('immunization_informationsource','school_record','School Record','07', '80')
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES ('immunization_informationsource','public_agency','Public Agency','08', '90')
INSERT INTO `list_options` (list_id, option_id, title) VALUES ('lists','next_of_kin_relationship','Next of Kin Relationship')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','associate','Associate','10','ASC')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) values ('next_of_kin_relationship','brother','Brother','20','BRO')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','care_giver','Care giver','30','CGV')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','child','Child','40','CHD')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','handicapped_dependent','Handicapped dependent','50','DEP')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','life_partner','Life partner','60','DOM')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','emergency_contact','Emergency contact','70','EMC')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','employee','Employee','80','EME')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','employer','Employer','90','EMR')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','extended_family','Extended family','100','EXF')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','foster_child','Foster Child','110','FCH')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','friend','Friend','120','FND')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','father','Father','130','FTH')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','grandchild','Grandchild','140','GCH')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','guardian','Guardian','150','GRD')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','grandparent','Grandparent','160','GRP')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','manager','Manager','170','MGR')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','mother','Mother','180','MTH')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','natural_child','Natural child','190','NCH')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','none','None','200','NON')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','other_adult','Other adult','210','OAD')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','other','Other','220','OTH')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','owner','Owner','230','OWN')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','parent','Parent','240','PAR')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','stepchild','Stepchild','250','SCH')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','self','Self','260','SEL')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','sibling','Sibling','270','SIB')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','sister','Sister','280','SIS')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','spouse','Spouse','290','SPO')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','trainer','Trainer','300','TRA')
INSERT INTO `list_options` (list_id, option_id, title, seq, notes) VALUES ('next_of_kin_relationship','unknown','Unknown','310','UNK')

— truncated here --0

4

hi @MerlinSilk ,

The log script is getting truncated here. Prob best to just email it to me at brady.g.miller@gmail.com .

thanks,
-brady

5

hi @MerlinSilk,

Thanks for sending me the log. Here is the part where log shows things to break on the sql upgrade script for you:

UPDATE `openemr_postcalendar_categories` SET pc_constant_id = LOWER(REPLACE (pc_catname,' ', '_'))<br />
ALTER TABLE openemr_postcalendar_categories ADD UNIQUE (`pc_constant_id`)<br />
PHP Notice:  Undefined index: translate_no_safe_apostrophe in /var/www/openemr/library/translation.inc.php on line 46
<h2><font color='red'>Query Error</font></h2>PHP Notice:  Undefined index: sql_string_no_show_screen in /var/www/openemr/library/sql.inc on line 486
<p><font color='red'>ERROR:</font> query failed: ALTER TABLE openemr_postcalendar_categories ADD UNIQUE (`pc_constant_id`)</p>PHP Notice:  Undefined index: sql_string_no_show_screen in /var/www/openemr/library/sql.inc on line 493
<p>Error: <font color='red'>Duplicate entry 'no_show' for key 'pc_constant_id'</font></p>PHP Notice:  Undefined index: sql_string_no_show_screen in /var/www/openemr/library/sql.inc on line 502
<br>/var/www/openemr/library/sql_upgrade_fx.php at 892:sqlStatement<br>/var/www/openemr/TEMPsql_upgrade.php at 92:upgradeFromSqlFile(5_0_0-to-5_0_1_upgrade.sql)SQL Error with statement:query failed: ALTER TABLE openemr_postcalendar_categories ADD UNIQUE (`pc_constant_id`)--Duplicate entry 'no_show' for key 'pc_constant_id'==>/var/www/openemr/library/sql_upgrade_fx.php at 892:sqlStatement

-brady

6

for more information, this is related to this code in the upgrade script:

7

Next question is what does the data look like in your openemr_postcalendar_categories table?
(it appears you may have duplicate entries for No Show)

8

Hi Bardy,
I have, in fact a double entry for No Show in the database records (below)
What I am curious is that the error I am getting is for the table log_comment_encrypt - does that still make sense, could this be a secondary error?
How would I go about fixing this problem. Would I have to restore my old version, fix the double No Show and then try the update again? Or is there a better method. Also, should there be a UNIQUE index on the pc_catname field?
Getting rid of the second No Show could turn into some difficult ‘brain surgery’ as that record is probably referenced in many places, yes?

Thanks you so much for your help,
Merlin

INSERT INTO openemr_postcalendar_categories (pc_catid, pc_catname, pc_catcolor, pc_catdesc, pc_recurrtype, pc_enddate, pc_recurrspec, pc_recurrfreq, pc_duration, pc_end_date_flag, pc_end_date_type, pc_end_date_freq, pc_end_all_day, pc_dailylimit, pc_cattype) VALUES
(5, ‘Office Visit’, ‘#FFFFCC’, ‘Normal Office Visit’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 900, 0, 0, 0, 0, 0, 0),
(4, ‘Vacation’, ‘#EFEFEF’, ‘Reserved for use to define Scheduled Vacation Time’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 0, 0, 0, 0, 1, 0, 1),
(1, ‘No Show’, ‘#DDDDDD’, ‘Reserved to define when an event did not occur as specified.’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 0, 0, 0, 0, 0, 0, 0),
(2, ‘In Office’, ‘#6699CC’, ‘Reserved todefine when a provider may haveavailable appointments after.’, 1, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“1”;s:22:“event_repeat_freq_type”;s:1:“4”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 0, 1, 3, 2, 0, 0, 1),
(3, ‘Out Of Office’, ‘#0000FF’, ‘Reserved to define when a provider may not have available appointments after.’, 1, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“1”;s:22:“event_repeat_freq_type”;s:1:“4”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 0, 1, 3, 2, 0, 0, 1),
(8, ‘Lunch’, ‘#99FF99’, ‘Lunch’, 1, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“1”;s:22:“event_repeat_freq_type”;s:1:“4”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 3600, 0, 3, 2, 0, 0, 1),
(9, ‘Established Patient’, ‘#CCFF33’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 900, 0, 0, 0, 0, 0, 0),
(10, ‘New Patient’, ‘#CCFFFF’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 1800, 0, 0, 0, 0, 0, 0),
(11, ‘Reserved’, ‘#FF7777’, ‘Reserved’, 1, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“1”;s:22:“event_repeat_freq_type”;s:1:“4”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 900, 0, 3, 2, 0, 0, 1),
(12, ‘Filler’, ‘#FF66CC’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 1800, 0, 0, 0, 0, 0, 0),
(13, ‘Insurance Consult’, ‘#00FFFF’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 1800, 0, 0, 0, 0, 0, 0),
(14, ‘Consult’, ‘#3399FF’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 1800, 0, 0, 0, 0, 0, 0),
(15, ‘Follow Up’, ‘#FFFF33’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 900, 0, 0, 0, 0, 0, 0),
(16, ‘Peel’, ‘#FF9900’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 1800, 0, 0, 0, 0, 0, 0),
(17, ‘Surgery’, ‘#CCCCCC’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 3600, 0, 0, 0, 0, 0, 0),
(18, ‘Laser’, ‘#CC0033’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 1800, 0, 0, 0, 0, 0, 0),
(19, ‘Facial’, ‘#009999’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 3600, 0, 0, 0, 0, 0, 0),
(20, ‘Neurotoxins’, ‘#FF99CC’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 1800, 0, 0, 0, 0, 0, 0),
(21, ‘Office Procedure’, ‘#99CCCC’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 1800, 0, 0, 0, 0, 0, 0),
(22, ‘Phone Call’, ‘#FFFFFF’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 300, 0, 0, 0, 0, 0, 0),
(23, ‘Post Op’, ‘#FFFF66’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 900, 0, 0, 0, 0, 0, 0),
(24, ‘Markings’, ‘#FF0000’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 1800, 0, 0, 0, 0, 0, 0),
(25, ‘Pre Op’, ‘#000000’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 3600, 0, 0, 0, 0, 0, 0),
(26, ‘Product Purchase’, ‘#663399’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 300, 0, 0, 0, 0, 0, 0),
(27, ‘V-Shape’, ‘#009999’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 3600, 0, 0, 0, 0, 0, 0),
(28, ‘Staff Note’, ‘#FF0066’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 900, 0, 0, 0, 0, 0, 0),
(29, ‘Sclerotherapy’, ‘#FFCCFF’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 1800, 0, 0, 0, 0, 0, 0),
(30, ‘Pixel Laser’, ‘#FF3333’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 1800, 0, 0, 0, 0, 0, 0),
(31, ‘Hospital Surgery’, ‘#FF0000’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 3600, 0, 0, 0, 0, 0, 0),
(32, ‘Bloodwork’, ‘#FF9966’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 900, 0, 0, 0, 0, 0, 0),
(33, ‘Sculptra’, ‘#FF66FF’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 6300, 0, 0, 0, 0, 0, 0),
(34, ‘Lymphatic Drainage’, ‘#33CC00’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 1800, 0, 0, 0, 0, 0, 0),
(35, ‘IV Vitamin Therapy’, ‘#00CC66’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 900, 0, 0, 0, 0, 0, 0),
(36, ‘B12 Shot’, ‘#009900’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 900, 0, 0, 0, 0, 0, 0),
(37, ‘Red Light Therapy’, ‘#FF6633’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 1800, 0, 0, 0, 0, 0, 0),
(38, ‘Time Off’, ‘#99FFCC’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 1800, 0, 0, 0, 0, 0, 0),
(39, ‘No Show’, ‘#330066’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 0, 0, 0, 0, 0, 0, 0),
(40, ‘Kenalog/Cortisone Injection’, ‘#33FF99’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 900, 0, 0, 0, 0, 0, 0),
(41, ‘Cancelled appt’, ‘#99CCCC’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 0, 0, 0, 0, 0, 0, 0),
(42, ‘Assisting Dr. Wilson’, ‘#CC0000’, ‘’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;s:19:“event_repeat_on_num”;s:1:“1”;s:19:“event_repeat_on_day”;s:1:“0”;s:20:“event_repeat_on_freq”;s:1:“0”;}’, 0, 14400, 0, 0, 0, 0, 0, 0);

9

Hi @MerlinSilk ,

I think best thing may be to change title of No Show to No Show 2 for one of your No Show entries in 4.2.2. Then try to run the upgrade again.

-brady

10

Also,
To answer you question regarding log_comment_encrypt, this is because the sql upgrade script died when it errored out. So, it didn’t add the version column along with lots of other things.
-brady