Query Error: Duplicate entry 'sixa' for key 'name' on X12 Partners when Enabling Audit Log Encryption

modanq · July 21, 2024, 5:53pm

Situation
When turning on “Enable Audit Log Encryption” in config settings, I get a Query Error of “Duplicate entry ‘sixa’ for key ‘name’” on the “X12 Partners” page in Practice Settings. This error goes away when I turn the “Enable Audit Log Encryption” off.

Query Error

ERROR: query failed: INSERT INTO keys (name, value) VALUES (?, ?)

Error: Duplicate entry ‘sixa’ for key ‘name’

/var/www/localhost/htdocs/openemr/src/Common/Crypto/CryptoGen.php at 485:sqlStatementNoLog
/var/www/localhost/htdocs/openemr/src/Common/Crypto/CryptoGen.php at 236:collectCryptoKey(six,a,database)
/var/www/localhost/htdocs/openemr/src/Common/Crypto/CryptoGen.php at 106:coreDecrypt(riaaquKOhWtuWJvKtj3ekGSFOQFStUlmYB7g5ohcduHoFnWOaKe60Pv53q5zF9MiPqjN9BPU99XcRG5OSgZeiC/PHx4D1j9Ct7QnaJVoJlt7ssb9+67T+Ltp7KtcsiyNlbm+mmh7FZNRvu9ekyuUJg==,,database,six)
/var/www/localhost/htdocs/openemr/src/Common/Crypto/CryptoGen.php at 513:decryptStandard(006riaaquKOhWtuWJvKtj3ekGSFOQFStUlmYB7g5ohcduHoFnWOaKe60Pv53q5zF9MiPqjN9BPU99XcRG5OSgZeiC/PHx4D1j9Ct7QnaJVoJlt7ssb9+67T+Ltp7KtcsiyNlbm+mmh7FZNRvu9ekyuUJg==,,database)
/var/www/localhost/htdocs/openemr/src/Common/Crypto/CryptoGen.php at 160:collectCryptoKey(six,a,drive)
/var/www/localhost/htdocs/openemr/src/Common/Crypto/CryptoGen.php at 72:coreEncrypt(SHOW COLUMNS FROM `x12_partners`,,drive,six)
/var/www/localhost/htdocs/openemr/src/Common/Logging/EventAuditLogger.php at 760:encryptStandard(SHOW COLUMNS FROM `x12_partners`)
/var/www/localhost/htdocs/openemr/src/Common/Logging/EventAuditLogger.php at 662:recordLogItem(1,security-administration-select,admin,Default,SHOW COLUMNS FROM `x12_partners`,0,Security)
/var/www/localhost/htdocs/openemr/library/ADODB_mysqli_log.php at 45:auditSQLEvent(SHOW COLUMNS FROM `x12_partners`,1,)
/var/www/localhost/htdocs/openemr/vendor/adodb/adodb-php/drivers/adodb-mysqli.inc.php at 949:Execute(SHOW COLUMNS FROM `x12_partners`)
/var/www/localhost/htdocs/openemr/src/Common/ORDataObject/ORDataObject.php at 174:MetaColumns(x12_partners)
/var/www/localhost/htdocs/openemr/library/classes/X12Partner.class.php at 66:_load_enum(processing_format,)
/var/www/localhost/htdocs/openemr/controllers/C_X12Partner.class.php at 61:__construct()
/var/www/localhost/htdocs/openemr/library/classes/Controller.class.php at 157:list_action()
/var/www/localhost/htdocs/openemr/controllers/C_PracticeSettings.class.php at 144:act(Array)
/var/www/localhost/htdocs/openemr/library/classes/Controller.class.php at 157:x12_partner_action(list)
/var/www/localhost/htdocs/openemr/controller.php at 6:act(Array)

OpenEMR Version
Tested using a docker install on Ubuntu 22.04. Tested both on latest 7.0.3-dev and 7.0.2 (1) versions.

I can also reproduce this error on the official Development 7.0.2 Demo:

Go to https://one.openemr.io/b/openemr
Login using admin and pass
Go to Admin > Config > Logging > and check Enable Audit Log Encryption
Go to Admin > Practice > Practice Settings > X12 Partners

The error is reproduced. If you turn off Enable Audit Log Encryption then the error goes away.

Browser:
Reproduced on Firefox 128.0 and Chrome 126.0.6478.127

Operating System
I’m using: Ubuntu 22.04 server for install and MacOS Sonoma 14.5 for client

Search
Did you search the forum for similar questions?
Yes, this is the only thread I found:

Logs
Did you check the logs?

a559423ebdc0:/var/log/apache2# tail -n 5 error.log 
[Sun Jul 21 17:29:59.657006 2024] [php:warn] [pid 917] [client 192.168.78.1:65060] PHP Warning:  Array to string conversion in /var/www/localhost/htdocs/openemr/library/sql.inc.php on line 576, referer: http://openemr.local:8300/controller.php?practice_settings&pharmacy&action=list
[Sun Jul 21 17:29:59.657019 2024] [php:notice] [pid 917] [client 192.168.78.1:65060] SQL Error with statement:query failed: INSERT INTO `keys` (`name`, `value`) VALUES (?, ?)--Duplicate entry &#039;sixa&#039; for key &#039;name&#039;==&gt;/var/www/localhost/htdocs/openemr/src/Common/Crypto/CryptoGen.php at 485:sqlStatementNoLog, referer: http://openemr.local:8300/controller.php?practice_settings&pharmacy&action=list
[Sun Jul 21 17:38:00.438073 2024] [php:warn] [pid 921] [client 192.168.78.1:65304] PHP Warning:  Array to string conversion in /var/www/localhost/htdocs/openemr/library/sql.inc.php on line 576, referer: http://openemr.local:8300/controller.php?practice_settings&pharmacy&action=list
[Sun Jul 21 17:38:00.438104 2024] [php:warn] [pid 921] [client 192.168.78.1:65304] PHP Warning:  Array to string conversion in /var/www/localhost/htdocs/openemr/library/sql.inc.php on line 576, referer: http://openemr.local:8300/controller.php?practice_settings&pharmacy&action=list
[Sun Jul 21 17:38:00.438120 2024] [php:notice] [pid 921] [client 192.168.78.1:65304] SQL Error with statement:query failed: INSERT INTO `keys` (`name`, `value`) VALUES (?, ?)--Duplicate entry &#039;sixa&#039; for key &#039;name&#039;==&gt;/var/www/localhost/htdocs/openemr/src/Common/Crypto/CryptoGen.php at 485:sqlStatementNoLog, referer: http://openemr.local:8300/controller.php?practice_settings&pharmacy&action=list