[Konstantinos]

I've updated mysql server to 5.7.11 and since then I've got few problems. I fixed the issue with ONLY_FULL_GROUP_BY sql mode and the one left is very odd.

My query:

Code:

"INSERT INTO player_vehicles VALUES (NULL,%i,%i,%i,%i,%i,%i) ON DUPLICATE KEY UPDATE modelid=%i,color1=%i,color2=%i,paintjob=%i"

The problem is that it doesn't insert a new row when it should.

I print the query and everything seems fine. I copy the output and run it through phpmyAdmin and it inserts a new row. I execute the same query after connecting the mysql in OnGameModeInit and it still inserts a new row.

However when I use it in the command, it does not insert a new row. Extra info:
- it retrieves the ID generated for an AUTO_INCREMENT column by the sent query correctly
- debug with LOG_ALL and it says "query was successfully executed within X milliseconds"

Any help would be appreciated.

EDIT: After more analysis it seems the cache is the problem.
I tried running a non-threaded query for the INSERT and it worked. Switching cache back to true didn't work though.