Page 1 of 1
Crafting at stuff and keg
Posted: Fri Aug 18, 2017 11:57 am
by Ememjr
if you try to craft at a stove and keg in frostfang sea crafting area the server will crash
and it appears i crashed emu
Re: Crafting at stuff and keg
Posted: Fri Aug 18, 2017 3:37 pm
by Jabantiz
Did the other crafting stations work?
Re: Crafting at stuff and keg
Posted: Fri Aug 18, 2017 4:13 pm
by Ememjr
hmm i thought i posted the fix for this
Re: Crafting at stuff and keg
Posted: Fri Aug 18, 2017 4:18 pm
by Ememjr
on the current db from svn, there appears to be 147 item numbers missing from the recipe_components table when item slot_id =0 if the primary component item id is missing it caused the server to crash
based on what i have found in most cases the item number in recipe_products for stage 0 matches the item id of the same recipe slot_id 0, which makes since becuase slot_id 0 is the primary compnent, and stage0 item id is the item you get back when failing at the first stage
in fact only seems to be 13 out of 981 that dont follow this
any way here is a sql script you can run to fix the issue and populate the missing data
Code: Select all
UPDATE recipe_components
INNER JOIN recipe_products
ON recipe_components.recipe_id = recipe_products.recipe_id
SET recipe_components.item_id = recipe_products.product_id
WHERE recipe_components.slot_id = 0 AND recipe_components.item_id =0
update: that do not dfall into this category are the adornment conversion recipes and the COokies recipes, i will post a fix for those as well
Re: Crafting at stuff and keg
Posted: Sun Jun 24, 2018 9:36 pm
by Cynnar
As if you can't guess, I'm moving things to archives. This one read to go?
Re: Crafting at stuff and keg
Posted: Tue Jun 26, 2018 5:26 am
by Ememjr
only if the above was corrected in the db, i dont seem to have access to check theat