Hi Good Morning,
I have a slightly different error with data entry to insurance. I am using Linux Mint 20 with Mariadb 15.1 and Openemr-6.0. Openemr-6.0 was upgraded form Openemr-5.0.2(5). Upgrade was smooth and login was flawlless. Checking mysql_sql showed all OK. I however received this error when trying to update insurance data.
ERROR: query failed: INSERT INTO keys (name, value) VALUES (?, ?)
Error: Duplicate entry ‘sixa’ for key ‘name’
/var/www/html/openemr/src/Common/Crypto/CryptoGen.php at 433:sqlStatementNoLog
/var/www/html/openemr/src/Common/Crypto/CryptoGen.php at 231:collectCryptoKey(six,a,database)
/var/www/html/openemr/src/Common/Crypto/CryptoGen.php at 100:coreDecrypt(WqUaalmVefeTDsUVPVe6V2c6cAp67AUn5x1GZK3lPdgM/8rR6MK+8Jsd/qgRK/ob3lCxaAYxF6TrXbwsPdJ5Sjr1ii2ZNtQxXGW+ZnDsxitosmJM2dUUxu/Y5uMCnTWFPhgXma2opHkjsbJO7eNhWA==,database,six)
/var/www/html/openemr/src/Common/Crypto/CryptoGen.php at 462:decryptStandard(006WqUaalmVefeTDsUVPVe6V2c6cAp67AUn5x1GZK3lPdgM/8rR6MK+8Jsd/qgRK/ob3lCxaAYxF6TrXbwsPdJ5Sjr1ii2ZNtQxXGW+ZnDsxitosmJM2dUUxu/Y5uMCnTWFPhgXma2opHkjsbJO7eNhWA==,database)
/var/www/html/openemr/src/Common/Crypto/CryptoGen.php at 153:collectCryptoKey(six,a,drive)
/var/www/html/openemr/src/Common/Crypto/CryptoGen.php at 66:coreEncrypt(SHOW COLUMNS FROM x12_partners,drive,six)
/var/www/html/openemr/src/Common/Logging/EventAuditLogger.php at 739:encryptStandard(SHOW COLUMNS FROM x12_partners)
/var/www/html/openemr/src/Common/Logging/EventAuditLogger.php at 641:recordLogItem(1,security-administration-select,admin,Default,SHOW COLUMNS FROM x12_partners,Security)
/var/www/html/openemr/library/ADODB_mysqli_log.php at 45:auditSQLEvent(SHOW COLUMNS FROM x12_partners,1,)
/var/www/html/openemr/vendor/adodb/adodb-php/drivers/adodb-mysqli.inc.php at 632:Execute(SHOW COLUMNS FROM x12_partners)
/var/www/html/openemr/src/Common/ORDataObject/ORDataObject.php at 114:MetaColumns(x12_partners)
/var/www/html/openemr/library/classes/X12Partner.class.php at 43:_load_enum(processing_format,)
/var/www/html/openemr/library/classes/InsuranceCompany.class.php at 150:__construct()
/var/www/html/openemr/controllers/C_InsuranceCompany.class.php at 19:__construct()
/var/www/html/openemr/library/classes/Controller.class.php at 100:__construct()
/var/www/html/openemr/controllers/C_PracticeSettings.class.php at 58:act(Array)
/var/www/html/openemr/library/classes/Controller.class.php at 137:insurance_company_action(list)
/var/www/html/openemr/controller.php at 6:act(Array)
I would appreciate any help with this error.
Thanks.
Jack