Problem with 'review of system checks'

Day-to-Day Users
1

Hi,

A few months ago, I upgraded to v. 5.0.1. I have just noticed that my review of system checks form is not retaining data. I input data, click save, and get a blank screen. I had noticed this before, but since I was receiving no error message, I made the mistake of assuming the data must have been stored anyway. Now I realise that the form does not even appear in my visits history. So I went to Administration - Other - Forms, and saw that Review of System Checks was listed as unregistered. I clicked on ‘register’. I then saw that I was being prompted to ‘install database’. I got an error message but I did not note it down. Upon rebooting, I found that now there are two instances of the same form listed as ‘registered’, one enabled with the DB installed, and one prompting me to install the DB. The form still does not work, or rather, it works partially. If, for example, I check ‘Weight loss’, I get the following:

“There was an OpenEMR SQL Escaping error on the following string weight_loss”

If however I write ‘Weight loss’ in Additional Notes, that information is accepted and retained.

How can I resolve this, please?

Many thanks.

2

hi @rdh61, is there an entry in the php error log for the reviewofs save.php?

3

Hi, Thanks for your response. Where might I find the php error log?

P.S. I’m running Lubuntu 18.04 LTS.

4

try /var/log/apache2/error.log

5

Thanks. Here is the error log entry for a new instance this morning:

[Fri Jul 26 08:27:21.920473 2019] [mpm_prefork:notice] [pid 939] AH00163: Apache/2.4.29 (Ubuntu) configured -- resuming normal operations
[Fri Jul 26 08:27:21.920519 2019] [core:notice] [pid 939] AH00094: Command line: '/usr/sbin/apache2'
[Fri Jul 26 08:27:34.367381 2019] [:error] [pid 2331] [client ::1:44780] PHP Notice:?? Undefined index: basePath in /var/www/openemr/library/core/src/Header.php on line 158, referer: http://localhost/openemr/interface/main/left_nav.php
[Fri Jul 26 08:27:34.368164 2019] [:error] [pid 2331] [client ::1:44780] PHP Notice:?? Undefined variable: form_id in /var/www/openemr/library/validation/validation_script.js.php on line 67, referer: http://localhost/openemr/interface/main/left_nav.php
[Fri Jul 26 08:27:34.458273 2019] [:error] [pid 2331] [client ::1:44780] PHP Notice:?? Undefined variable: result in /var/www/openemr/interface/forms/newpatient/common.php on line 319, referer: http://localhost/openemr/interface/main/left_nav.php
[Fri Jul 26 08:27:34.476210 2019] [:error] [pid 2331] [client ::1:44780] PHP Notice:?? Undefined variable: disabled in /var/www/openemr/interface/forms/newpatient/common.php on line 413, referer: http://localhost/openemr/interface/main/left_nav.php
[Fri Jul 26 08:27:58.742924 2019] [:error] [pid 2333] [client ::1:44784] PHP Notice:?? Undefined index: basePath in /var/www/openemr/library/core/src/Header.php on line 158, referer: http://localhost/openemr/interface/patient_file/encounter/encounter_top.php
[Fri Jul 26 08:28:06.956852 2019] [:error] [pid 2335] [client ::1:44786] PHP Notice:?? Undefined index: basePath in /var/www/openemr/library/core/src/Header.php on line 158, referer: http://localhost/openemr/interface/patient_file/encounter/encounter_top.php
[Fri Jul 26 08:28:53.681636 2019] [:error] [pid 2334] [client ::1:44788] PHP Notice:?? Undefined index: id in /var/www/openemr/interface/forms/reviewofs/save.php on line 37, referer: http://localhost/openemr/interface/patient_file/encounter/load_form.php?formname=reviewofs
[Fri Jul 26 08:28:53.691028 2019] [:error] [pid 2334] [client ::1:44788] ERROR: OpenEMR SQL Escaping ERROR of the following string: depressed, referer: http://localhost/openemr/interface/patient_file/encounter/load_form.php?formname=reviewofs
6

hi @rdh61 ,
Sounds like you are missing the 'depressed' sql column in your form_reviewofs sql table.

7

Thanks Brady. Confession time. I had a heavily customised ‘review of system checks’ form, which had worked in all previous incarnations of openemr. It wasn’t working in this one. Possible reason: I see that “new.php” seems to have had a makeover. Anyway, I thought it was not worth the time involved to troubleshoot / reconstruct my form. Instead, I decided to make do with your original one. I simply removed my custom ‘reviewofs’ folder from /interface/forms/ and reinstated the original one. This is the point at which the above error message started appearing. You are right. The database still had the custom version of the form, which clearly was not compatible with the new data I was trying to input. I have now renamed the custom database form, and imported the original, and all is working. No more dabbling in customisation for me!