About BR Files(Item Mall)

01/18/2012 02:38 rushcrush#1
sup guys
yestrday i was setting up test server for br files
i loged on game normaly and try to buy anything from item mall then i got this error in gameserver
PHP Code:
fatal    C:\WORK2005\Source\SilkroadOnline\Server\SR_GameServer\GObjPC.cppCGObjPC::_AsyncQuerySucceeded7239    2012-01-18 03:29:42 470
warnning    AQ succeeded but AsyncQueryCompleted
() error occurred [AQType18]    2012-01-18 03:29:42 471 
iam sure this error not cuz the account db name changed to some random name
there's another reason of this error
so anyone know what it mean?
01/18/2012 02:50 Dead Legend#2
strange error, never seen this before, guess you've really done something wrong, maybe you can tell exactly more detailed explanation of when this error comes up?
01/18/2012 02:55 rushcrush#3
Quote:
Originally Posted by Dead Legend View Post
strange error, never seen this before, guess you've really done something wrong, maybe you can tell exactly more detailed explanation of when this error comes up?
it come when i buy anything from item mall
and yeah i never seen this error befor lol
..maybe my server files missing something but what it would be
or db missing something but what it would be

edit:there's any editor for elite media? seems the one for edit it not working...
always say : error : the entry does not exist
01/18/2012 03:00 Dead Legend#4
Quote:
Originally Posted by rushcrush View Post
it come when i buy anything from item mall
and yeah i never seen this error befor lol
..maybe my server files missing something but what it would be
or db missing something but what it would be
do you get any dc or stuff like that?
01/18/2012 03:40 rushcrush#5
Quote:
Originally Posted by Dead Legend View Post
do you get any dc or stuff like that?
ofc i get dc when i buy anything from item mall=the error i just show you it
you will say the acc db not the correct name.. right?
but if this true then i must get another error
not the error i show you
01/18/2012 11:17 Dr.Abdelfattah#6
cuz u change Account DB name
check the Account DB name in Shard DB stored Procedures .
(the error Explain it's self that the error
, {AQ} the name of query that the game server do to edit in SK_Silk table table just failed to connect or find the database name) .
and how u fix that ,
just execute all stored Procedures and find for example one of those procedure (_GET_REMAIN_SILK , _STRG_BUY_CASHITEM_EXP , _STRG_BUY_CASHITEM_EQUIP_NORMAL_NHAT , _STRG_BUY_CASHITEM_EXP_NHAT)
search in one of those the name of Account db and change to the current Account DB u made
and execute them on again on Shard DB and make sure the query success
if you write un exist Account DB name the query execute will fail

Hope i help :)
01/18/2012 17:41 rushcrush#7
Quote:
Originally Posted by Dr.Abdelfattah View Post
cuz u change Account DB name
check the Account DB name in Shard DB stored Procedures .
(the error Explain it's self that the error
, {AQ} the name of query that the game server do to edit in SK_Silk table table just failed to connect or find the database name) .
and how u fix that ,
just execute all stored Procedures and find for example one of those procedure (_GET_REMAIN_SILK , _STRG_BUY_CASHITEM_EXP , _STRG_BUY_CASHITEM_EQUIP_NORMAL_NHAT , _STRG_BUY_CASHITEM_EXP_NHAT)
search in one of those the name of Account db and change to the current Account DB u made
and execute them on again on Shard DB and make sure the query success
if you write un exist Account DB name the query execute will fail

Hope i help :)
i know about this already
but i already changed it to the right name
kinda weird
01/18/2012 18:05 Dr.Abdelfattah#8
Quote:
Originally Posted by rushcrush View Post
i know about this already
but i already changed it to the right name
kinda weird
well how many account db name u found?
cuz the only issue of ur problem(GS error and dc) that u don't actually change account db in all procedure
01/18/2012 18:32 ✗EpicSoul✗#9
most of the procedures that connect both of the dbs are different names the best way is to use the default name which are BR_AccountTest and BR_GameTest this will fix all of the erros :)
01/18/2012 18:36 djoctan#10
have use all name dc pets :-(
01/18/2012 18:43 Dr.Abdelfattah#11
well let me backup all names of procedure and post for u