Ghmattimysql: My MySQL Implementation for FiveM [1.3.2]

1.3.1

  • Added storeSync as a wrapper around store.
  • Added mysql_log_level to remove unwanted prints to the console, so they just could go directly to a file.
  • Added mysql_log_file_format to specify the output log file.
  • Reworked the UI. UI Bundle-size lost 550kB in size.
1 Like

YAY ! Thanks for this update.

for other make u ensure vrp_ghmattimysql-js instead vrp_ghmattimysql

cfx> [ghmattimysql] [ERROR] connect ETIMEDOUT

I am getting this error. Tried to use all different databases, even used XAMP to host a database. Used mariadb and now using MYSQL. But still it gives this error. Tried both ways of using Config.json and using direct mysql string.

Can anybody tell me why do we get this error?

This error is of no major concern. You just get a timeout while connecting on your first connection. The other connections will proceed normally.

1 Like

thanks for the help bro, I was worried. Now I can focus on the rest of the stuff.

Hey, is there some function on Ghmattimysql that replace the MySQL.ready function? Ty!

Everything is okay on extendedmode another resources and worked but i have issue when extendedmode time to save automatically, i have issue with that?

How to fix that?
Thanks

Hey can anyone help i have been using ghmattimysql for 2 weeks and worked fine then all of a sudden when i spawn sometimes i cant move and i have to relog a few times before i can move, I get now errors either, when i cant move when holding alt i can move and run and do everything but the minute i let go of alt i cant move. This has been happening to everyone on my server, i also rolled back my server to make sure it wasnt a script i installed and it isnt. Also when i cant move and i restart ghmattimysql i can then move.

ghmattimysql vs mysql-async. which better for server?

How can I implement this into an esx server?

What is wrong on this query?

[ script:ghmattimysql] [MariaDB:10.4.17-MariaDB] [ERROR] [vrp] An error happens for query ā€œINSERT INTO vrp_users(whitelisted,banned) VALUES(false,false); SELECT LAST_INSERT_ID() AS id : []ā€: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ā€˜SELECT LAST_INSERT_ID() AS id’ at line 1

can someone help me im having an problem when im implementing the resurce ghmattimysql and when i’m starting the server i’m getting this error and i don’t know how i can fix it

SCRIPT ERROR: citizen:/scripting/lua/scheduler.lua:1155: No such export executeSync in resource ghmattimysql

executeSync is not a valid export

use instead

exports.ghmattimysql:execute()

More can be found here: ghmattimysql - ghmattimysql

Is it possible to run Ghmattimysql a longside with MySQL-Async, we tried it and it seems to be working so wanted to make sure we won’t break anything in the long term.

It wont do anything but that is a dumb thing to do.

Dead link?

1 Like

The project has been disbanded or moved by its owner. I can’t seem to find a new documentation on hhmattimysql.

Can’t find it either