Check if mysql is in strict mode

[supercain]

Hi,

i wonder if there is a php function or something that allows me to know for sure if strict mode is on or off, something like phpinfo(). This is because im sure i disabled strict mode but for some reason i still get errors that seem to indicate its still on.

Thank you.

[NogDog]

You could try running this query:

SELECT @@sql_mode

[supercain]

Thanks. It says STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_ so that means its running on strict mode again! and i dont get why because i changed the configuration file and it was once on normal mode so i dont know why it went back to strict mode because i checked the config file and it hasnt changed since then. How can i fix this?

Thank you.