protraja Posted October 5, 2015 Posted October 5, 2015 I can't install my script correctly because i have to turn off MySQL strict mode. To fix this i must run an SQL query in phpmyadmin - SET @@global.sql_mode= '' , but i don't have the privilege for this operation. This is the error: #1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation Also i was advised that my hosting provider has to do this for me.*
Krydos Posted October 19, 2015 Posted October 19, 2015 Why not just provide a non-null value, the right data type, or a value within the specified range for all of the fields that give an error? For instance to fix the merchant_id error you could give it a default value, or you could give it a non-null value in the insert command.
Krydos Posted November 8, 2015 Posted November 8, 2015 MySQL strict mode has been disabled on all servers. Details can be found in the latest news post: http://www.helionet.org/index/topic/22545-mysql-strict-mode-disabled/
Recommended Posts