Unable to set strict sql setting: No such file or directory

OpenEMR Development
,
#1

This is what is in my log file.

 [Sun Apr 17 15:35:56.677016 2022] [php7:notice] [pid 17859] [client 70.184.171.187:55020] Unable to set strict sql setting: No such file or directory, referer: https://e.de.org/interface/main/tabs/main.php?token_main=8bZrahF4j4sxHNA9ZWtuZ1LBVdGyy1LUoXp8n4FH
 [Sun Apr 17 15:36:00.389853 2022] [php7:error] [pid 17327] [client 70.184.171.187:55012] PHP Fatal error:  Allowed memory size of 1073741824 bytes exhausted (tried to allocate 262144 bytes) in /var/www/html/hb600/vendor/adodb/adodb-php/adodb.inc.php on line 183, referer: https://e.de.org/interface/patient_tracker/patient_tracker.php?skip_timeout_reset=1
 [Sun Apr 17 15:36:00.662405 2022] [php7:error] [pid 17859] [client 70.184.171.187:55020] PHP Fatal error:  Allowed memory size of 1073741824 bytes exhausted (tried to allocate 262144 bytes) in /var/www/html/hb600/vendor/adodb/adodb-php/adodb.inc.php on line 1144, referer: https://e.de.org/interface/main/tabs/main.php?token_main=8bZrahF4j4sxHNA9ZWtuZ1LBVdGyy1LUoXp8n4FH
 [Sun Apr 17 15:36:00.852045 2022] [php7:error] [pid 17858] [client 70.184.171.187:55019] PHP Fatal error:  Allowed memory size of 1073741824 bytes exhausted (tried to allocate 262144 bytes) in /var/www/html/hb600/vendor/adodb/adodb-php/adodb.inc.php on line 1144, referer: https://e.de.org/interface/main/tabs/main.php?token_main=8bZrahF4j4sxHNA9ZWtuZ1LBVdGyy1LUoXp8n4FH
 [Sun Apr 17 15:36:56.674917 2022] [php7:notice] [pid 16874] [client 70.184.171.187:55030] PHP custom error: from openemr library/sql.inc  - Unable to set up UTF8MB4 encoding with mysql database: No such file or directory, referer: https://e.de.org/interface/patient_tracker/patient_tracker.php?skip_timeout_reset=1
 [Sun Apr 17 15:36:56.674957 2022] [php7:notice] [pid 16874] [client 70.184.171.187:55030] Unable to set strict sql setting: No such file or directory, referer: https://e.de.org/interface/patient_tracker/patient_tracker.php?skip_timeout_reset=1

I checked the file permissions and it is set to 664.

How can the file call the adodb class then the class not be able to find the file that called it?

/**
 * Set ADODB_DIR to the directory where this file resides...
 * This constant was formerly called $ADODB_RootPath
 */
if (!defined('ADODB_DIR')) {
	define('ADODB_DIR',dirname(__FILE__));
}

I found this

But I don’t think this solves my issue. Any suggestions would be greatly appreciated.

#2

what php version are you running?

#3

The system is running PHP v 7.4.28.

#4

the installer class would output that message, are the values in sqlconf.php working?

#5

Yes, the program is working correctly. This is not a clean install. This is a database that was upgrade from 4.x to 6.1.0

#6

ok, also the calendar could output it and sql.inc as well as gacl.php.

Screenshot from 2022-04-17 21-59-40

#7

looks like something from patient tracker is the culprit

#8

It is coming from the sql.inc. I tracked it back to the sqlconf file but was helpful in finding why it this error being thrown Yes, but that is where I am stuck also.

#9

actually I think someone’s password expired, checkout main_screen.php around line 408

after is_expired is set to true, you get to line 468 and the skip_timeout_reset=1 is passed

maybe just one possible path of many, good luck

1 Like
#10

I ended up having to convert the database table from latan1-Swedish to utf8mb4_unicode_ci. I found a script that created the ALTER statements I needed to convert all the tables. Now, everything is hunky dory. I did have to reset a few of the indexes to get the database under control. Installed mysqltuner to make some suggestions and it humming like an F15 jet fighter now.

2 Likes