Sunday, December 27, 2015

DETERMINISTIC, NO SQL, or READS SQL DATA error

Just after giving name for database , next step it shows
This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)...how to solve this?

Most common solution: Open your php.ini file and search for display_errors = ON and change it to display_errors = Off

If the above does not work, try the following:

SSH to your server

Connect to MySQL using your root user and passord and at the mysql prompt, run this command mysql> SET GLOBAL log_bin_trust_function_creators = 1;

No comments:

Post a Comment