Logo
My activities
Submit a Ticket >

Toll Free: 1.877.776.2995

Database Schema Upgrade Failed - Error: You do not have the SUPER privilege and binary logging is enabled

Database Schema Upgrade Failed with the following error:

Exception in thread "main" com.agiliance.com mon.ALException: code: 0 You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable) DROP TRIGGER IF EXISTS trig_agl_raproject_delete at com.agiliance.com mon.SQLScriptProcessor.executeScript_internal(SQLScriptProcessor.java:83) at com.agiliance.com mon.SQLScriptProcessor.executeScript(SQLScriptProcessor.java:55) at com.agiliance.admin.upgrade.SQLUpgradeTask.execute(SQLUpgradeTask.java:33) at com.agiliance.admin.upgrade.UpgradeProcessor.upgradeDatabase(UpgradeProcessor.java:630) at com.agiliance.admin.upgrade.UpgradeProcessor.upgradeDatabaseSchema(UpgradeProcessor.java:48) at com.agiliance.admin.upgrade.UpgradeProcessor.main(UpgradeProcessor.java:1276) database schema upgrade failed

To resolve the error:

Add the line log-bin-trust-function-creators=1 to my.ini, prior to upgrading. Then restart MySQL database and RiskVision services.

 

 

Follow
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Powered by Zendesk