Yes I am. I will try this.
I redid the upgrade and the patch and still the same problem.
Now run the sql_patch.php and let me know if the issue is still the same.
Ran the patch and still the same error. uuuugh. I don’t know what to do now.
I feel it is the database. I tried to create a new blank database but it keeps stalling when I try to run the setup with the setup creating the database. If I can get this to work can I transfer data without corrupting the new database.
Can you show me the page where the error is occurring and the steps to get to the error?
The original query error or the error creating the blank database?
The original error happened when you were doing what?
When I click on billing manager.
Can you post a screenshot of the billing manager page?
@juggernautsei
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.
Query Error
ERROR: query failed: INSERT INTO keys (name, 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 x12_partners,drive,six)
/home/evolvebh/public_html/temr/src/Common/Logging/EventAuditLogger.php at 742:encryptStandard(SHOW COLUMNS FROM x12_partners)
/home/evolvebh/public_html/temr/src/Common/Logging/EventAuditLogger.php at 644:recordLogItem(1,security-administration-select,EBH-admin-20,Default,SHOW COLUMNS FROM x12_partners,Security)
/home/evolvebh/public_html/temr/library/ADODB_mysqli_log.php at 45:auditSQLEvent(SHOW COLUMNS FROM x12_partners,1,)
/home/evolvebh/public_html/temr/vendor/adodb/adodb-php/drivers/adodb-mysqli.inc.php at 632:Execute(SHOW COLUMNS FROM x12_partners)
/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?
Hi @tjbarr,
Can you please remove below two file and do the process again
sites/default/documents/logs_and_misc/methods/sixa
sites/default/documents/logs_and_misc/methods/sixb
She’s already has done all of that. Re read the threads concerning this issue.
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.
3 Likes
@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
1 Like
You are AWESOME! I had to turn off the emergency query audit also for it to work. Thank You! Thank You! @stephenwaite @sjpadgett @juggernautsei
2 Likes
