Query in SQL for changing sql_mode in session removin STRICT_TRANS_TABLES
Budget: $10 – $30 USD
Hi.
I'm looking for a developer to help me out in solving a mini-problem.
I do have a website with a private area connected to a database.
With the update of new MySQL, I came along a problem with it.
Basically, I have to change the sql_mode removing the function "STRICT_TRANS_TABLES", which causes me a problem.
As long as I'm on a shared hosting, I can't edit it globally using phpmyadmin, so I have to set it via code for the session.
I have to put this string:
SET SESSION sql_mode="ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION";"
But I don't know where to put it, I guess on the login.php page
It's a 1 minute job, but I really don't know where to put it.
Thanks
David
I'm looking for a developer to help me out in solving a mini-problem.
I do have a website with a private area connected to a database.
With the update of new MySQL, I came along a problem with it.
Basically, I have to change the sql_mode removing the function "STRICT_TRANS_TABLES", which causes me a problem.
As long as I'm on a shared hosting, I can't edit it globally using phpmyadmin, so I have to set it via code for the session.
I have to put this string:
SET SESSION sql_mode="ONLY_FULL_GROUP_BY,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION";"
But I don't know where to put it, I guess on the login.php page
It's a 1 minute job, but I really don't know where to put it.
Thanks
David