Can you post a screenshot of the billing manager page?
I removed all the key values for security. It goes to the cryptogen.php but it sees the value in the key table as null even though it isn’t null and so it tries to insert it again and throws the error.
ERROR: query failed: INSERT INTO
value) VALUES (?, ?)
Error: Duplicate entry ‘sixa’ for key ‘name’
/home/evolvebh/public_html/temr/src/Common/Crypto/CryptoGen.php at 434:sqlStatementNoLog
/home/evolvebh/public_html/temr/src/Common/Crypto/CryptoGen.php at 231:collectCryptoKey(six,a,database)
/home/evolvebh/public_html/temr/src/Common/Crypto/CryptoGen.php at ???==,database,six)
/home/evolvebh/public_html/temr/src/Common/Crypto/CryptoGen.php at 463:decryptStandard(???==,database)
/home/evolvebh/public_html/temr/src/Common/Crypto/CryptoGen.php at 153:collectCryptoKey(six,a,drive)
/home/evolvebh/public_html/temr/src/Common/Crypto/CryptoGen.php at 66:coreEncrypt(SHOW COLUMNS FROM
/home/evolvebh/public_html/temr/src/Common/Logging/EventAuditLogger.php at 742:encryptStandard(SHOW COLUMNS FROM
/home/evolvebh/public_html/temr/src/Common/Logging/EventAuditLogger.php at 644:recordLogItem(1,security-administration-select,EBH-admin-20,Default,SHOW COLUMNS FROM
/home/evolvebh/public_html/temr/library/ADODB_mysqli_log.php at 45:auditSQLEvent(SHOW COLUMNS FROM
/home/evolvebh/public_html/temr/vendor/adodb/adodb-php/drivers/adodb-mysqli.inc.php at 632:Execute(SHOW COLUMNS FROM
/home/evolvebh/public_html/temr/src/Common/ORDataObject/ORDataObject.php at 114:MetaColumns(x12_partners)
/home/evolvebh/public_html/temr/library/classes/X12Partner.class.php at 43:_load_enum(processing_format,)
/home/evolvebh/public_html/temr/interface/billing/billing_report.php at 109:__construct()
@stephenwaite. Should I contact a programmer? Do you have time to help me debug? If I should contact a professional, do you have any particular one that you think could solve this issue?
Can you please remove below two file and do the process again
She’s already has done all of that. Re read the threads concerning this issue.
@tjbarr Sent you a PM.
happy to report to everyone following this issue and other related issues like Query Error ERROR: query failed: INSERT INTO `keys` (`name`, `value`) VALUES (?, ?) - Error: Duplicate entry ‘sixa’ for key ‘name’
that it’s that villain of all villains, Admin->Logging->Audit Logging Select Query, guessing it either breaks some
Smarty stuff behind the scenes or really big sql queries, so just turn it off.
@stephenwaite , Is this both 6.0.0 (it should be off by default in 6.0.0) and/or master? The problem is that MU3 will require this setting.
(MU3 actually requires that it is on by default)
good ? brady, just tested v6.0.0 to get this out asap but will hopefully get to more debugging on master