Weird Error in GameServer......

04/14/2012 14:01 rushcrush#1
anyone of you saw this error befor in game server?
i get it when i try to buy something from item mall
PHP Code:
fatal    Query Error!!! Query Result : -1, Query : {CALL _STRG_ADD_PACKAGEITEM (24,7004,23,84209,1,0,1000,0,0,0,'')}    2012-04-14 06:56:33 743
fatal    SQL Error State:42000, Native Error Code: 1FD0, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function _ConsumeSilkByGameServer has too many arguments specified.    2012-04-14 06:56:33 744
fatal    {CALL _STRG_ADD_PACKAGEITEM (24,7004,23,84209,1,0,1000,0,0,0,'')}    2012-04-14 06:56:33 745
fatal    _STRG_ADD_PACKAGEITEM Failed (2940)    2012-04-14 06:56:33 746
warnning    AQ Failed! Log out!! [AQType: 18]    2012-04-14 06:56:33 758 
04/14/2012 14:28 ✗EpicSoul✗#2
ConsumeSilkByGameServer has too many arguments specified
04/14/2012 14:30 rushcrush#3
Quote:
Originally Posted by ✗EpicSoul✗ View Post
ConsumeSilkByGameServer has too many arguments specified
i cant find this in shard -.-
04/14/2012 14:31 ✗EpicSoul✗#4
Quote:
Originally Posted by rushcrush View Post
i cant find this in shard -.-
maybe that's the problem.. its not there ?
04/14/2012 14:33 rushcrush#5
Quote:
Originally Posted by ✗EpicSoul✗ View Post
maybe that's the problem.. its not there ?
it suppose to be there?
04/14/2012 14:35 Getzabelz#6
Take in account that _ConsumeSilkByGameServer is not a procedure and you might be looking for it in the wrong place, It's a PL/SQL function. It's being used by that _STG procedure, you could also debug that code in order to see why It prompts that when using the desired function.
04/14/2012 14:37 Kape7#7
That procedure is on the account database, not in shard.

[Only registered and activated users can see links. Click Here To Register...]
04/14/2012 14:40 rushcrush#8
oky thx guys
i will look at it now

i have Q...what this _ConsumeSilkByGameServer2(2 not 1) for