Jump to content

[Solved] Privileges To Turn Off Mysql Strict Mode


protraja

Recommended Posts

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.*

Link to comment
Share on other sites

  • 2 weeks later...

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.

Link to comment
Share on other sites

  • 3 weeks later...
Guest
This topic is now closed to further replies.
×
×
  • Create New...