Database not saving crafting rep. | CW Scripts | Page 1

frozen ridge Sep 22, 2025, 8:17 AM

#

Hey guys maybe someone can enlighten me as I’ve been having this problem for a couple of days and can’t get it fixed.

So I’m using crafting and I have edited the config jsut for items to be crafted. The player makes the items gets X amount of crafting xp and when the server restarts they are back at zero.

I have installed the sql, I have cw-crafting & rep all started after MySQL in the cfg. I’m using Qbox and Ox has anyone encountered this issue before or maybe can assist I feel like I have blinders on now so I’m missing whatever the issue is.

Also should add no errors anywhere.

jovial pelican Sep 22, 2025, 8:44 AM

#

Any errors?

#

See https://discord.com/channels/1002187567845888042/1199274444271648828 for debug help.

frozen ridge Sep 22, 2025, 9:06 AM

#

No errors which is what has me stumped.

I installed it changed the items in the config, did the sql tested it in game and you can see it going up, I can also log in and out and it will work but if the server restarts that’s when I get mine reset.

jovial pelican Sep 22, 2025, 9:15 AM

#

Sounds like a database issue. You sure the SQL is working and the server isn't throwing errors when updating?

The script updates the DB every x seconds/minutes. It sounds like it's just using cache while the server is on and thats why it's working until you restart it.

frozen ridge Sep 22, 2025, 9:24 AM

#

Yeah I figured as much, so when I run the sql it adds cw-skills to the players row in the db it’s listed as that in the config so I am unsure why it won’t pick up on it.

jovial pelican Sep 22, 2025, 9:25 AM

#

Try doing a clean install of cw-rep

frozen ridge Sep 22, 2025, 9:36 AM

#

That’s what I was thinking just cleaning it all out and redoing it all maybe be the best course. I’m in work right now but when I am home I will just redo it all and report back. Thanks for your help.

frozen ridge Sep 22, 2025, 4:13 PM

#

jovial pelican Try doing a clean install of cw-rep

Okay so I have done this fresh install and same issue not saving to the db.

on this line "Config.UpdateFrequency = 60*60 -- Seconds interval between removing values (no need to touch this)"

is this 60 times 60?

jovial pelican Sep 22, 2025, 4:26 PM

#

That is for if you want to have skills that degrade over time

#

It should be updating the DB every 10 minutes by default iirc

#

Config.MinutesBetweenUpdates to change

frozen ridge Sep 22, 2025, 4:27 PM

#

jovial pelican That is for if you want to have skills that degrade over time

Okay thanks for confirming I had assumed.

So I took that out of the client, change the update to one minute for testing purposes and no xp goes up at all.

I do have this error clinet side ^1SCRIPT ERROR: @cw-crafting/bridge/client/qbox.lua:29: attempt to index a nil value (global 'QBX')^7

#

and this on the server side now until I changed the minutes between updates it was gaining xp in the ui but since i lowered it now it does not gain xp,

I also tried a full restart too with no joy.

jovial pelican Sep 22, 2025, 4:31 PM

#

frozen ridge Okay thanks for confirming I had assumed. So I took that out of the client, ch...

Sounds like youre missing the QBX line in the manifest

#

It should've been there by default tho

#

add this in shared_scripts
'@qbx_core/modules/playerdata.lua',

frozen ridge Sep 22, 2025, 4:33 PM

#

OKay, it was missing. do I need it in rep too?

jovial pelican Sep 22, 2025, 4:34 PM

#

Not sure

#

lol

frozen ridge Sep 22, 2025, 4:34 PM

#

find out I guess

#

So no longer getting any errors client or server side, but you make something an no xp goes up at all in the UI

jovial pelican Sep 22, 2025, 4:37 PM

#

you sure you enabled Rep for crafting?

frozen ridge Sep 22, 2025, 4:38 PM

#

Yep I did and I have boht started after ox and the core.

Config.ItemName = "cw_blueprint" -- Name of the item in your items.lua
Config.PlayersTableName = 'players' -- 'players' for qb/qbox, 'characters' for ox. Something else for esx probably
Config.PlayerDbIdentifier = 'citizenId' -- 'citizenId' for qb/qbox, 'stateId' for ox, Something else for ex probably
Config.UseCWRepForCraftingSkill = true -- Set to true if you want to use cw-rep for skill instead of qbs metadata
-- The following all require cw-rep to be enabled:
Config.CraftingSkillName = 'crafting' -- Make sure this matches the crafting skill name in your cw-rep config
Config.CraftingSkillLabel = 'Crafting Skill' -- Default name for the crafting skill
Config.HideRecipeIfSkillNotMet = false -- if this is enabled then players wont see recipes they dont have skill enough to see
Config.UseLevelsInsteadOfSkill = false -- If true then cw-rep will use level instead of pure xp
Config.DefaultMaxCraft = 10 -- Default max amount a player can craft at a time

jovial pelican Sep 22, 2025, 4:41 PM

#

I'm stumped

#

I assume you went over the guide I posted earlier?

frozen ridge Sep 22, 2025, 4:42 PM

#

Okay so I can confirm I got one xp, restart the server great and it saved.

the minute I made a change to the config then it stops updating in the ui and the db.

#

oh yeah I went through it all

jovial pelican Sep 22, 2025, 4:43 PM

#

Ah ok maybe I missed it. You never posted any Debug logs kap

frozen ridge Sep 22, 2025, 5:02 PM

#

📎 logs.txt

jovial pelican Sep 22, 2025, 5:03 PM

#

Is that all the logs?

#

Looks like just the crafting setup, not the actual item crafting, or cw-rep

frozen ridge Sep 22, 2025, 5:04 PM

#

so that is just the client logs when you try make something sending the server now

#

📎 logsserver.txt

jovial pelican Sep 22, 2025, 5:06 PM

#

Did you miss those errors on server side or?

frozen ridge Sep 22, 2025, 5:06 PM

#

the item error, no I didnt but that wont affect the rep going up because its ox right ?

jovial pelican Sep 22, 2025, 5:07 PM

#

Of course it could. If crafting relies on a return value from ox then it could very well fail to execute correctly when Ox fails

#

Not sure what causes that tho

#

CustomDrop was related to weight = 0 iirc

frozen ridge Sep 22, 2025, 5:21 PM

#

so one of the lads did this for the bridge server file.

"lua function addItem(src, itemName, amount, metadata)
if Config.oxInv then
exports.ox_inventory:AddItem(src, itemName, amount, metadata)
end
end"

now the rep is accumulating on the ui gonna test a restart now

jovial pelican Sep 22, 2025, 5:22 PM

#

yeah he probably removed the drop functionality

frozen ridge Sep 22, 2025, 5:22 PM

#

Aye he did.

#

custom drop is gone he said.

#Database not saving crafting rep.