search

FredyH / MySQLOO

MySQLOO
GNU Lesser General Public License v2.1
140 stars 55 forks source link

GmodAdminSuite #86

Closed Hariamane closed 3 years ago

Hariamane commented 3 years ago

Hello I contacted the Billy logs addons developer, billy wl.. following a problem on my gmod server with WL and logs more precisely an SQL problem, it sends me to you and it tells me to tell you that it uses the "setCachePreparedStatements" and for errors enter it is: https://www.noelshack.com/2021-20-3-1621447202-u6srxtgo5h.png https://www.noelshack.com/2021-19-4-1620895216-screenshot-20210513-103917.jpg

From what I understand, it is that there is only you who can help me, thank you for taking the time to read and sorry for my English, I am French, see you very soon, cordially.

Kefta commented 3 years ago

You should be making a ticket with Billy, mysqloo is not at fault here.

Hariamane commented 3 years ago

That’s why I had them watch: https://www.noelshack.com/2021-20-5-1621605011-ajgffb6xjs.png

FredyH commented 3 years ago

Your second error is definitely not an error of mysqloo.

The first error could theoretically be an issue with mysqloo, but it is far more likely that some addon you are using is misusing prepared statements and creating too many of them. The point about him using setCachePreparedStatements is not related, since the value is true by default. Ask him if he is setting it to false.

Hariamane commented 3 years ago

Ok no worries I pass on to him not to.

WilliamVenner commented 3 years ago

@FredyH It's not being set to false. I added setCachePreparedStatements(true) into my database stuff in the hopes it would fix this issue (other than actually using prepared statements properly, but this was a couple years ago now), but it did not.

Notably, only @Hariamane has reported this issue to me.

FredyH commented 3 years ago

That probably means that there's just some addon that spams new prepared statements. It would be good to know when this error happens, is it soon after you start the server or only after a longer time?

Hariamane commented 3 years ago

What’s weird is that his ass wasn’t buttoned before, he’s only been doing it for a week like that overnight.

Hariamane commented 3 years ago

Hello, I inform you that the problem is solved as soon as I changed my host, well it's weird.

WilliamVenner commented 3 years ago

Which host? MySQL or game server host?

On Wed, 26 May 2021, 5:24 pm FredyH, @.***> wrote:

Closed #86 https://github.com/FredyH/MySQLOO/issues/86.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/FredyH/MySQLOO/issues/86#event-4800559671, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADRM27ZLKVRWPICGRSHTGYLTPUODZANCNFSM45JE5IMA .