Welcome Guest, Not a member yet? Register   Sign In
CI 3 DB LOCKING ISSUE ON SET SESSION sql_mode = REPLACE(REPLACE(REPLACE(REPLACE
#4

(This post was last modified: 09-21-2020, 08:32 AM by jreklund.)

Yes, I mean your mysql configuration. But that are a global setting and will affect all your applications.

stricton | TRUE/FALSE (boolean) - Whether to force "Strict Mode" connections, good for ensuring strict SQL while developing an application.

So it's disabling MySQL Strict in case it's on (for it's own connection). It's built that way so it can remove STRICT_ALL_TABLES and STRICT_TRANS_TABLES in case it's in the beginning, middle or end of the string.

https://dev.mysql.com/doc/refman/5.7/en/...ode-strict

It have always been executing it, but now it hangs for some reason.
Reply


Messages In This Thread
RE: CI 3 DB LOCKING ISSUE ON SET SESSION sql_mode = REPLACE(REPLACE(REPLACE(REPLACE - by jreklund - 09-21-2020, 08:31 AM



Theme © iAndrew 2016 - Forum software by © MyBB