CSPro Users Forum

Hello,

We are getting Error Uploading Dictionary. Error 500 when deploying an app to CSWeb. The deployment works if NO Dictionary to Upload for Synchronization is selected. Even with it selected the app makes it through, but not the dictionary - the Data tab on CSWeb is empty and Adding a dictionary manually shows the following error:


The API log says the error (when deploying the app with the dictionary) is:

request.CRITICAL: Uncaught PHP Exception PDOException: "SQLSTATE[HY000]: General error: 1419 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)" at C:\csweb\vendor\aura\sql\src\AbstractExtendedPdo.php line 213 {"exception":"[object] (PDOException(code: HY000): SQLSTATE[HY000]: General error: 1419 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) at C:\\csweb\\vendor\\aura\\sql\\src\\AbstractExtendedPdo.php:213)"} []

Would appreciate any advice!

This is a MySQL error caused because the account used to setup CSWeb MySQL database does not have super user privileges, which is required when binary logging is enabled on MySQL. Either
Grant super user privileges to the user account used in CSWeb setup to login to MySQL
OR
Locate your MySQL configuration file:
Add this line under the [mysqld] section:
[mysqld]
log_bin_trust_function_creators = 1

and Restart MySQL service:

Hi Savy,

Thanks for your prompt assistance and sorry for my late reply - I was on leave and then we had to keep the server running for ongoing production work. But the suggested fix worked and everything is fine now.

Again many thanks,
Iulian