Helm of northern worlf material - no combine

[Rhodan]

This recipe in the peq database was different than what I've read on all the quest sites as well as what the quest NPC tells you - so I decided to change it.

Orignally, it needed 1 lore bone chip, 2 small ore and a gnoll pup scalp. The bone chip was wrong so I changed it to the 13073 version and set the amount to 2. I rebooted the server (dunno if thats required, just figured it couldn't hurt) then tried the recipe, which did not work. I get the message that I cannot combine these items in that container type.

I checked the database and it seems to be correct. I tried the other materials and had no trouble making those.

So anyway, I'm stumped as to why this wouldn't work. Here's the database data

tradeskill_recipe
8598, 'northern wolf helm material', 69, 0, 0, 1, 0, 'created by ylosh'

tradeskill_recipe_entries
112142, 8598, 55095, 0, 0, 0, 1
112141, 8598, 13073, 0, 0, 2, 0
112140, 8598, 10500, 0, 0, 2, 0
112139, 8598, 13789, 0, 0, 1, 0
112138, 8598, 55104, 1, 0, 0, 0

55095 is definately the northern wolf plate assembly kit given by the NPC and its marked as the container

13073 is the bonechip type that I have (not stacked)
10500 is the ore I have (not stacked)
13789 is the gnoll pup scalp.

And ideas where I'm going wrong?

[MainMan]

Hey, this is still a problem. It's still not working.

It's both the helm and the boots. Any ideas?

[cavedude]

You need to apply this patch to your code:

http://eqemulator.net/forums/showthread.php?t=25235

Or, download and use the PEQ Installer, the 1118 upgrade version contains this fix.

[MainMan]

I apologize, I wasn't specific, and this might not be the right place to comment.

I meant that this problem appears to still be occurring on The Grand Creation.

[cavedude]

No it isn't, I just did the combine fine. I'll check to make sure the recipe in the DB matches with what is on Allah.

[MainMan]

Hmm.. Here's the original from Allah:

2 Small Pieces of Ore
1 Gnoll Pup Scalp
2 Bone Chips

I'm sorry for the inconvenience, it's just frustrating; this won't work for me and I've double checked the items dozens of times.

[cavedude]

I was able to recreate the problem on TGC, but the problem is I cannot on my internal test server and they are identical. Same code, same db, same quests, even same OS and scripts.

I'll figure out what's causing TGC to flip out with these combines tomorrow.

[MainMan]

How bizarre.

Thanks again though, I really appreciate it.

[trevius]

Couldn't be that there are multiple versions of bone chips? Or, maybe the issue where you can't create a tradeskill item that has the same name as another recipe? Maybe your test server has the fix for that and PEQ doesn't?

[cavedude]

Bone chips are fine, and we're using the tradeskill patch mentioned above. TGC's source folder is identical to the one I use here as once I test here I upload to TGC, make, and deploy. I'm sure it's just a small oversight somewhere.

[joligario]

Ok, just checked this out in our system... Taby can't combine it either. I think it has to do with the Gnoll Pup Scalp.

Could the fact that Lucy does not have it as a tradeskill item be the problem? I would think that the containers check if they are "tradeskillable" items inside.

http://lucy.allakhazam.com/item.html?id=13789

[cavedude]

No, it doesn't have to do with items, it all goes back to that patch I posted above. None of the duplicate recipes combine on TGC, but yet they all work fine on my internal test, using identical code and DB. I'm sure it's a small oversight somewhere, but I am banging my head to find it.

[cavedude]

If still interested, I finally tracked down the cause of this problem. I have no way to test the correction since I don't have a MySQL 4.0 server up, but it'll be active on PEQ with tomorrow's reboot if anybody wants to give it a try.

It came down to a query in the patch I mentioned above working in MySQL 5.0, but not 4.0 which is what TGC is running.