thymona / fivem-mysql Goto Github PK

Hope it's a project you are gonna keep active with out doubt, and get optimized, would be nice with a sql connecter based on mysql2 since like you mentioned it's a faster connector.

When someone is saving an object/table/class, the resource is automatically escaping all possible MySQL injection characters.

Example:
"{"black_money":0,"bank":8688975,"money":0}" will become "{\ "black_money\ ":0,\ "bank\ ":8688975,\ "money":0}"

Those strings aren't a SQL danger and shouldn't be escaped.

SCRIPT ERROR: @fivem-mysql/lib/MySQL.lua:219: Callback must be a function

Parse value based on there required type, when a column is a INT and a boolean is given. The library is trying to add the value true instead of 1, that causes SQL issues.
When true is given, parse this value to a int (1).

Maybe there are more tables that having this issue, resolve this issue.

I'm seeing these following errors across all of my resources when trying to startup fxserver with fivem-mysql:

I updated all the resource.lua files with the following changes

Is there more that needs to be done to migrate from mysql-async to fivem-mysql that I might be missing?

failed to synch on redm ! a lot of errors

Error

No such export ... in resource fivem-mysql

I followed your advice: Makes it easy to transform fivem-mysql-async to fivem-mysql

i resently reinstalled my whole server an started over due to this same issue an couldnt get help on it. i have not changed the qb clothing file this time i ran the sql an it happened again i need help in understanding this an a way to fix this please