sql issue on character creation | Qbox Project | Page 1

long dew Dec 16, 2024, 2:56 AM

#

02:55:09 PM [     script:qbx_core] [-1,"W842MY79",2,"license2:ee61c17a14c4920d59d721827107bcfbb0be7936","Sam","{\"crypto\":0,\"bank\":25000,\"cash\":500}","{\"firstname\":\"test\",\"backstory\":\"placeholder backstory\",\"nationality\":\"test\",\"phone\":\"8001690666\",\"cid\":2,\"birthdate\":\"2000-4-4\",\"account\":\"US03QBX1965370538\",\"gender\":0,\"lastname\":\"test\"}","{\"label\":\"Centerlink\",\"payment\":450,\"grade\":{\"level\":0,\"name\":\"Job Seeker\"},\"isboss\":false,\"onduty\":true,\"name\":\"unemployed\"}","{\"grade\":{\"level\":0,\"name\":\"Unaffiliated\"},\"label\":\"No Gang\",\"isboss\":false,\"name\":\"none\"}","{\"x\":-581.1824340820313,\"y\":-393.9296569824219,\"z\":36.17138671875,\"w\":2.83464550971984}","{\"fingerprint\":\"1GNND6C85443S7G\",\"injail\":0,\"hunger\":100,\"attachmentcraftingrep\":0,\"health\":200,\"stress\":0,\"ishandcuffed\":false,\"criminalrecord\":{\"hasRecord\":false},\"phonedata\":{\"InstalledApps\":[],\"SerialNumber\":22602761},\"craftingrep\":0,\"inside\":{\"apartment\":[]},\"bloodtype\":\"A+\",\"licences\":{\"id\":true,\"weapon\":false,\"driver\":true},\"armor\":0,\"walletid\":\"QB-69298160\",\"callsign\":\"NO CALLSIGN\",\"phone\":[],\"tracker\":false,\"isdead\":false,\"jailitems\":[],\"jobrep\":{\"taxi\":0,\"trucker\":0,\"hotdog\":0,\"tow\":0},\"status\":[],\"dealerrep\":0,\"inlaststand\":false,\"thirst\":100}","2024-12-16 12:55:09",-1,"Sam","{\"crypto\":0,\"bank\":25000,\"cash\":500}","{\"firstname\":\"test\",\"backstory\":\"placeholder backstory\",\"nationality\":\"test\",\"phone\":\"8001690666\",\"cid\":2,\"birthdate\":\"2000-4-4\",\"account\":\"US03QBX1965370538\",\"gender\":0,\"lastname\":\"test\"}","{\"label\":\"Centerlink\",\"payment\":450,\"grade\":{\"level\":0,\"name\":\"Job Seeker\"},\"isboss\":false,\"onduty\":true,\"name\":\"unemployed\"}","{\"grade\":{\"level\":0,\"name\":\"Unaffiliated\"},\"label\":\"No Gang\",\"isboss\":false,\"name\":\"none\"}","{\"x\":-581.1824340820313,\"y\":-393.9296569824219,\"z\":36.17138671875,\"w\":2.83464550971984}","{\"fingerprint\":\"1GNND6C85443S7G\",\"injail\":0,\"hunger\":100,\"attachmentcraftingrep\":0,\"health\":200,\"stress\":0,\"ishandcuffed\":false,\"criminalrecord\":{\"hasRecord\":false},\"phonedata\":{\"InstalledApps\":[],\"SerialNumber\":22602761},\"craftingrep\":0,\"inside\":{\"apartment\":[]},\"bloodtype\":\"A+\",\"licences\":{\"id\":true,\"weapon\":false,\"driver\":true},\"armor\":0,\"walletid\":\"QB-69298160\",\"callsign\":\"NO CALLSIGN\",\"phone\":[],\"tracker\":false,\"isdead\":false,\"jailitems\":[],\"jobrep\":{\"taxi\":0,\"trucker\":0,\"hotdog\":0,\"tow\":0},\"status\":[],\"dealerrep\":0,\"inlaststand\":false,\"thirst\":100}","2024-12-16 12:55:09"]
02:55:09 PM [     script:qbx_core] Out of range value for column 'userId' at row 1
02:55:09 PM [     script:qbx_core] > upsertPlayerEntity (@qbx_core/server/storage/players.lua:96)
02:55:09 PM [     script:qbx_core] > fn (@qbx_core/server/player.lua:1052)
02:55:09 PM [     script:qbx_core] > logError (@oxmysql/dist/build.js:25870)
02:55:09 PM [     script:qbx_core] > rawQuery (@oxmysql/dist/build.js:26053)
02:55:09 PM [     script:qbx_core] > runMicrotasks (<anonymous>:0)
02:55:09 PM [     script:qbx_core] > processTicksAndRejections (node:internal/process/task_queues:96)

#

cosmic torrent Dec 16, 2024, 3:16 AM

#

did you edit your core at all?

long dew Dec 16, 2024, 5:24 AM

#

cosmic torrent did you edit your core at all?

no, i did switch from xampp to mariadb thats all ive done i can do a fresh install of the core though and see if it fixes it

cosmic torrent Dec 16, 2024, 5:25 AM

#

userIds should not match the ids column

long dew Dec 16, 2024, 5:33 AM

#

cosmic torrent userIds should not match the ids column

this table here may be the reason?

    characterDataTables = {
        {'properties', 'owner'},
        {'bank_accounts_new', 'id'},
        {'playerskins', 'citizenid'},
        {'player_mails', 'citizenid'},
        {'player_outfits', 'citizenid'},
        {'player_vehicles', 'citizenid'},
        {'player_groups', 'citizenid'},
        {'players', 'citizenid'},
        {'npwd_calls', 'identifier'},
        {'npwd_darkchat_channel_members', 'user_identifier'},
        {'npwd_marketplace_listings', 'identifier'},
        {'npwd_messages_participants', 'participant'},
        {'npwd_notes', 'identifier'},
        {'npwd_phone_contacts', 'identifier'},
        {'npwd_phone_gallery', 'identifier'},
        {'npwd_twitter_profiles', 'identifier'},
        {'npwd_match_profiles', 'identifier'},
    }, -- Rows to be deleted when the character is deleted

in config/server.lua

#

it had nothing in it

#

long dew Dec 18, 2024, 1:16 AM

#

Ill just have to go through everthing and see ehats causing the issue

final ferry Jan 24, 2025, 5:14 PM

#

@long dew are you using an external multichar?

long dew Jan 24, 2025, 5:37 PM

#

final ferry <@948075332093771776> are you using an external multichar?

yes

final ferry Jan 24, 2025, 5:39 PM

#

long dew yes

which one? um or another?

long dew Jan 24, 2025, 5:40 PM

#

final ferry which one? um or another?

corem but having other issues with it, will probably end up getting um

long dew Jan 28, 2025, 6:29 AM

#

nah

long dew Jan 30, 2025, 1:26 AM

#

solved just a multicharacter issue

final ferry Jan 31, 2025, 3:06 PM

#

long dew solved just a multicharacter issue

what did they change for this fix?

long dew Feb 1, 2025, 1:02 PM

#

final ferry what did they change for this fix?

i have no idea probably had the wrong exports as it was made for qb but idk as qbx should work 99%

#sql issue on character creation