Welcome Guest, Not a member yet? Register   Sign In
Session error: "Query error: Commands out of sync; you can't run this command now..."
#9

(09-01-2021, 12:18 AM)Volder Wrote:
(08-31-2021, 02:18 PM)php_rocs Wrote: @Volder ,

Have you tried the query directly in the database (to see if an error appears)? Are you sure that the input data is clean?  Has any of the data field types in the table changed?

The problem is that there is no particular query that produces it. On the local environment I can't replicate it.
As I mentioned on the production it appears only several times a day out of thousands of user visits, so it is very rare case, which I believe would be hard to replicate.
Maybe something connected with heavy load.

What do you mean by input data and clean?

No data types were changed, neither application, nor the database was changed at all, it was only PHP upgrade 7.2 -> 7.4 and then the issue appeared.

I mean is the data in the SQL input statement good data... or if you were to run the query directly in the database (phpMyAdmin) would it work or would it give you an error?
Reply


Messages In This Thread
RE: Session error: "Query error: Commands out of sync; you can't run this command now..." - by php_rocs - 09-01-2021, 08:01 AM



Theme © iAndrew 2016 - Forum software by © MyBB