search

KianFrostholm / FlaxHosting-Filer

Dette er nogle simple clean server filer med henblik på at optimere måden danske vRP servere køre på
5 stars 8 forks source link

New install - vrp was unable to execute a query! #1

Open gtabgrp opened 1 year ago

gtabgrp commented 1 year ago

[ script:oxmysql] SCRIPT ERROR in promise (unhandled rejection): Error: vrp was unable to execute a query! [ script:oxmysql] Data truncated for column 'whitelisted' at row 1 [ script:oxmysql] INSERT INTO vrp_users (id, whitelisted, banned) VALUES (1, 'false', 'false') [ script:oxmysql] > query_default (@oxmysql/dist/server/build.js:16103) [ script:oxmysql] > processTicksAndRejections (node:internal/process/task_queues:96) [ script:oxmysql]

You can't join the server. Seems to be working once you change the database datatype to bit for columns whitelisted, banned.

nc-jeni commented 1 year ago

Either change the type of the database column or change the Lua script to be using zero or one, where 'false' = 0 and 'true' = 1.

INSERT INTO vrp_users (id, whitelisted, banned) VALUES (1, 0, 0)

However, I have not seen this error on my own fork, but I might have changed it and forgot about it again.

https://gitlab.com/roleplay-servers/fivem

@gtabgrp