search

SuperiorServers / gm_tmysql4

MySQL connection module for Garry's Mod servers - SUP has picked up and maintained the module since it was abandoned years ago - Original author: @bkacjios
31 stars 7 forks source link

Errors number [2013] - [2014] #9

Closed JarosLucky closed 4 years ago

JarosLucky commented 4 years ago

When I try to use the latest releases (4.35 - 4.37) of this module, I have a problem with queries, or rather some queries produce an error from 2013 to 2014.

It sounds like this: "Commands out of sync; you can't run this command now".

But when I use the 4.1 version of the module, everything works fine and without errors. =\

The module is used with almost the latest version of Dash.

KingofBeast commented 4 years ago

Do you have a reproduction case I can test with?

JarosLucky commented 4 years ago

I will try to find a way to repeat this case.

пн, 7 сент. 2020 г., 11:43 KingofBeast notifications@github.com:

Do you have a reproduction case I can test with?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/SuperiorServers/gm_tmysql4/issues/9#issuecomment-688030092, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEUDZMG57U7VDK6DHMFT7NDSERQFLANCNFSM4Q24LB4A .

KingofBeast commented 4 years ago

I think I know what it is

Are you preparing statements while queries may possibly be running?

KingofBeast commented 4 years ago

I've fixed it on my end - try redownloading the binaries on the https://github.com/SuperiorServers/gm_tmysql4/releases/tag/4.37 release

JarosLucky commented 4 years ago 
L 09/07/2020 - 15:48:05: "』『　        』『<2><...><>" entered the game
[MySQL] gmod:gmod@:3306 => [2013] Commands out of sync; you can't run this command now
[MySQL] gmod:gmod@:3306 => SELECT * FROM ...

Unfortunately, it didn't help.

JarosLucky commented 4 years ago

I think I know what it is

Are you preparing statements while queries may possibly be running?

By the way, I don't use them.

JarosLucky commented 4 years ago

I'm now trying to figure out what the problem is, but for now I noticed that it is possible that MariaDB parses the data differently (or so) and because of this, problems arise. Although this is currently without a solid guess.

JarosLucky commented 4 years ago

Hell, I don't know exactly what the problem is yet. I'll try to make a simple example to reproduce, for about a week. For now, I'll be busy with other things and probably for this time I will close the request.

KingofBeast commented 4 years ago

I'll be happy to test and fix once you find a reproducible case