(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?
