View Single Post
  #1  
Old 10-21-2004, 06:15 AM
Xothin
Sarnak
 
Join Date: Oct 2004
Posts: 68
Default Tradeskill errors

Interesting bug...

When doing a tradeskill item, you get the combine, it does all the checks needed, and will pop out the item.. but.. ^.^

When finishing the combine, the tradeskill container(fletching kit for this example) does not empty out. The items that I used to create the item still remain. I can click them to move them about, and get a server error stating that the item is to be deleted, but it still remains in the container. Popped out of my game and got this message on my zone.exe
Code:
[Error] Error in Client::acmod(): Agility: 257, Level: 65
[Error] Error in Client::acmod(): Agility: 257, Level: 65
[Error] Error in Client::acmod(): Agility: 257, Level: 65
[Error] Error in Client::acmod(): Agility: 257, Level: 65
[Error] Error in Client::acmod(): Agility: 257, Level: 65
[Error] Error in Client::acmod(): Agility: 257, Level: 65
[Error] Error in Client::acmod(): Agility: 257, Level: 65
[Error] Error in Client::acmod(): Agility: 257, Level: 65
[Error] Error in Client::acmod(): Agility: 257, Level: 65
[Error] Error in GetTradeRecept search, query: SELECT tre.recipe_id  FROM trades
kill_recipe_entries AS tre WHERE ( tre.item_id IN(?) AND tre.componentcount>0 )
 OR ( tre.item_id=17910 AND tre.iscontainer=1 ) GROUP BY tre.recipe_id HAVING su
m(tre.componentcount) = 0  AND sum(tre.item_id * tre.componentcount) = 0
[Error] Error in GetTradeRecept search, error: #1064: You have an error in your
SQL syntax.  Check the manual that corresponds to your MySQL server version for
the right syntax to use near ') AND tre.componentcount>0 )  OR ( tre.item_id=179
10 AND ?
[Error] Error in GetTradeRecept search, query: SELECT tre.recipe_id  FROM trades
kill_recipe_entries AS tre WHERE ( tre.item_id IN(?g?w) AND tre.componentcount>0
 )  OR ( tre.item_id=17910 AND tre.iscontainer=1 ) GROUP BY tre.recipe_id HAVING
 sum(tre.componentcount) = 0  AND sum(tre.item_id * tre.componentcount) = 0
[Error] Error in GetTradeRecept search, error: #1054: Unknown column '?g?w' in '
where clause'
[Error] Error in Client::acmod(): Agility: 257, Level: 65
[Error] Error in Client::acmod(): Agility: 257, Level: 65
[Error] Error in Client::acmod(): Agility: 257, Level: 65
[Error] Error in Client::acmod(): Agility: 257, Level: 65
[Error] Error in Client::acmod(): Agility: 257, Level: 65
Reply With Quote