Help about this '' failed to retrieve the account information '' :(

[proasd1]

using 1.5 client

and ofc sql 2008 r2


EDIT : Forgot ss :(

http://postimage.org/image/l5rvkccn5/

[MentaL]

[GzFKoron]

Are you sure you correctly filled out the database tables and that the information matches in both tables? (Account.dbo and Login.dbo)

[mitor]

The AID need to be the same from Account and Login Table

[proasd1]

AIDs already same :C

[Anju]

UserID is not the same in either Account or Login database from what it looks like.

[proasd1]

After Check Accoung and Login UserIDs same -.- and changed id - pw Still getting same error xs

[proasd1]

still waiting for smart answer q-q

[Chrisss]

Smart answer = Delete database and restore a new one. Simple.

[Anju]

It's most likely the UserID and/or AID isn't matching.

[proasd1]

idk :( theres no way to fix :( ?

[ThroneX]

I got this error when I changed my LastVIPWall to LastVIPWalls .. so change it back to LastVIPWall and it should be fine. If not just post your matchserver logs.

[proasd1]

MatchServer Log

Load XML from memory : strings.xml(0x0052) - SUCCESS
Load XML from memory : cserror.xml(0x0052) - SUCCESS
[02/28/13 19:46:38] DBMS connected

[02/28/13 19:46:38] Command registeration completed

Start GambleItem Init.
GIID : 1000001
GRIID : M(502003), F(502003), RentHourPeriod(360), ItemCnt(0).
GRIID : M(500003), F(500003), RentHourPeriod(360), ItemCnt(0).
GRIID : M(502001), F(502001), RentHourPeriod(360), ItemCnt(0).
GRIID : M(506002), F(506002), RentHourPeriod(360), ItemCnt(0).
GRIID : M(509003), F(509003), RentHourPeriod(360), ItemCnt(0).
GRIID : M(505002), F(505002), RentHourPeriod(360), ItemCnt(0).
GRIID : M(520032), F(520532), RentHourPeriod(360), ItemCnt(0).
GRIID : M(520030), F(520530), RentHourPeriod(360), ItemCnt(0).
GRIID : M(521014), F(521514), RentHourPeriod(360), ItemCnt(0).
GRIID : M(521024), F(521524), RentHourPeriod(360), ItemCnt(0).
GRIID : M(522009), F(522509), RentHourPeriod(360), ItemCnt(0).
GRIID : M(522013), F(522513), RentHourPeriod(360), ItemCnt(0).
GRIID : M(523027), F(523527), RentHourPeriod(360), ItemCnt(0).
GRIID : M(523012), F(523512), RentHourPeriod(360), ItemCnt(0).
GRIID : M(524016), F(524516), RentHourPeriod(360), ItemCnt(0).
GRIID : M(524025), F(524525), RentHourPeriod(360), ItemCnt(0).
GRIID : M(528002), F(528002), RentHourPeriod(360), ItemCnt(0).
GRIID : M(520033), F(520533), RentHourPeriod(360), ItemCnt(0).
GRIID : M(502004), F(502004), RentHourPeriod(360), ItemCnt(0).
GRIID : M(527001), F(527001), RentHourPeriod(360), ItemCnt(0).
GIID : 1000002
GRIID : M(502002), F(502002), RentHourPeriod(168), ItemCnt(0).
GRIID : M(500004), F(500004), RentHourPeriod(168), ItemCnt(0).
GRIID : M(500001), F(500001), RentHourPeriod(168), ItemCnt(0).
GRIID : M(506004), F(506004), RentHourPeriod(168), ItemCnt(0).
GRIID : M(507003), F(507003), RentHourPeriod(168), ItemCnt(0).
GRIID : M(504501), F(504501), RentHourPeriod(168), ItemCnt(0).
GRIID : M(520014), F(520514), RentHourPeriod(168), ItemCnt(0).
GRIID : M(520029), F(520529), RentHourPeriod(168), ItemCnt(0).
GRIID : M(521017), F(521517), RentHourPeriod(168), ItemCnt(0).
GRIID : M(521027), F(521527), RentHourPeriod(168), ItemCnt(0).
GRIID : M(522020), F(522520), RentHourPeriod(168), ItemCnt(0).
GRIID : M(522004), F(522504), RentHourPeriod(168), ItemCnt(0).
GRIID : M(523024), F(523524), RentHourPeriod(168), ItemCnt(0).
GRIID : M(523005), F(523505), RentHourPeriod(168), ItemCnt(0).
GRIID : M(524027), F(524527), RentHourPeriod(168), ItemCnt(0).
GRIID : M(524012), F(524512), RentHourPeriod(168), ItemCnt(0).
GRIID : M(527002), F(527002), RentHourPeriod(168), ItemCnt(0).
GRIID : M(520034), F(520534), RentHourPeriod(168), ItemCnt(0).
GRIID : M(502005), F(502005), RentHourPeriod(168), ItemCnt(0).
GRIID : M(528001), F(528001), RentHourPeriod(168), ItemCnt(0).
GIID : 1000003
GRIID : M(4), F(4), RentHourPeriod(168), ItemCnt(0).
GRIID : M(6), F(6), RentHourPeriod(168), ItemCnt(0).
GRIID : M(14), F(14), RentHourPeriod(168), ItemCnt(0).
GRIID : M(16), F(16), RentHourPeriod(168), ItemCnt(0).
GRIID : M(31), F(31), RentHourPeriod(168), ItemCnt(0).
GRIID : M(4023), F(4023), RentHourPeriod(168), ItemCnt(0).
GRIID : M(4514), F(4514), RentHourPeriod(168), ItemCnt(0).
GRIID : M(5016), F(5016), RentHourPeriod(168), ItemCnt(0).
GRIID : M(6009), F(6009), RentHourPeriod(168), ItemCnt(0).
GRIID : M(7004), F(7004), RentHourPeriod(168), ItemCnt(0).
GRIID : M(8001), F(8001), RentHourPeriod(168), ItemCnt(0).
GRIID : M(9001), F(9001), RentHourPeriod(168), ItemCnt(0).
GRIID : M(21009), F(21509), RentHourPeriod(168), ItemCnt(0).
GRIID : M(22006), F(22506), RentHourPeriod(168), ItemCnt(0).
GRIID : M(23008), F(23511), RentHourPeriod(168), ItemCnt(0).
GRIID : M(24007), F(24507), RentHourPeriod(168), ItemCnt(0).
GRIID : M(30403), F(30403), RentHourPeriod(168), ItemCnt(0).
GRIID : M(25005), F(25005), RentHourPeriod(168), ItemCnt(0).
GRIID : M(30002), F(30002), RentHourPeriod(168), ItemCnt(0).
GRIID : M(400007), F(400007), RentHourPeriod(168), ItemCnt(0).
GIID : 1000004
GRIID : M(7), F(7), RentHourPeriod(168), ItemCnt(0).
GRIID : M(8), F(8), RentHourPeriod(168), ItemCnt(0).
GRIID : M(17), F(17), RentHourPeriod(168), ItemCnt(0).
GRIID : M(18), F(18), RentHourPeriod(168), ItemCnt(0).
GRIID : M(35), F(35), RentHourPeriod(168), ItemCnt(0).
GRIID : M(4022), F(4022), RentHourPeriod(168), ItemCnt(0).
GRIID : M(4516), F(4516), RentHourPeriod(168), ItemCnt(0).
GRIID : M(5020), F(5020), RentHourPeriod(168), ItemCnt(0).
GRIID : M(6010), F(6010), RentHourPeriod(168), ItemCnt(0).
GRIID : M(7009), F(7009), RentHourPeriod(168), ItemCnt(0).
GRIID : M(8004), F(8004), RentHourPeriod(168), ItemCnt(0).
GRIID : M(9007), F(9007), RentHourPeriod(168), ItemCnt(0).
GRIID : M(21010), F(21510), RentHourPeriod(168), ItemCnt(0).
GRIID : M(22007), F(22507), RentHourPeriod(168), ItemCnt(0).
GRIID : M(23009), F(23512), RentHourPeriod(168), ItemCnt(0).
GRIID : M(24008), F(24508), RentHourPeriod(168), ItemCnt(0).
GRIID : M(30003), F(30003), RentHourPeriod(168), ItemCnt(0).
GRIID : M(25006), F(25006), RentHourPeriod(168), ItemCnt(0).
GRIID : M(30103), F(30103), RentHourPeriod(168), ItemCnt(0).
GRIID : M(30305), F(30305), RentHourPeriod(168), ItemCnt(0).
GRIID : M(6008), F(6008), RentHourPeriod(168), ItemCnt(0).
End GambleItem Init.

Start shop GItem list log.
GambleItemCount : 2.
Shop GItem : 1000003
Shop GItem : 1000004
End shop GItem list log.


=== Dump GambleItem Info. ===
Gamble item list.
Gamble item. ID(1000001), Name(Blue Box), IsTimeover(0).
Gamble item. ID(1000002), Name(Pink Box), IsTimeover(0).
Gamble item. ID(1000003), Name(Green Box), IsTimeover(0).
Gamble item. ID(1000004), Name(Gold Box), IsTimeover(0).

Send shop gamble item list.
Shop gamble item count : 2
Shop gamble item. ID(1000003), Name(Green Box).
Shop gamble item. ID(1000004), Name(Gold Box).
=== Completed Dump GambleItem Info. ===

init GameOn success.
success init security.
FILE PATH : D:\Gunz Client 1.5 Kurulum\Gunz 1.5 Repack by Jur13n #1 (Edited)\server\Matchserver\MD5HashValue.txt
MD5 Hash Value => a1 a8 f5 e8 15 e9 72 30 80 5f a6 4e f2 96 77 d7

================================== Server configure info ==================================
[02/28/13 19:46:38] Release Date : Nov 16 2012
[02/28/13 19:46:38] X-Trap Off
[02/28/13 19:46:38] MD5 Check Off
[02/28/13 19:46:38] Loop Log Save Off
[02/28/13 19:46:38] Server Country : KOREA
[02/28/13 19:46:38] Command version : (58)
[02/28/13 19:46:38] Event usable state : (true)
[02/28/13 19:46:38] Load event size : (0)
[02/28/13 19:46:38] FileCRCCheckSum usable state : (false)
[02/28/13 19:46:38] FileCRC size : (0)
[02/28/13 19:46:38] Country Code Filter usalbe state : (false)
[02/28/13 19:46:38] Accept Invalied IP state : (false)
[02/28/13 19:46:38] Keeper IP : (127.0.0.1)
[02/28/13 19:46:38] Monitor IP : (127.0.0.1)
[02/28/13 19:46:38] Ticket use : 0

===========================================================================================

[02/28/13 19:46:38] Match Server Created (Port:6000)

Dueltournament Service Open(2013-2-28 Hour19, Min46)
Daily Survival Ranking Request [month2 day28 hour19 min46]
success to update CustomIP
[02/28/13 19:46:41] Start agent Register (CommUID 0:10) IP:127.0.0.1, TCPPort:5100, UDPPort:7778

[02/28/13 19:46:41] Agent Added (UID:010)
[02/28/13 19:46:41] Agent Registered (CommUID 0:10) IP:127.0.0.1, TCPPort:5100, UDPPort:7778


[02/28/13 19:47:16] MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spGetAccountInfo (1)} ), ErrCode( -1 )
ErrMsg - Could not find stored procedure 'spGetAccountInfo'.
State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]


[02/28/13 19:47:16] MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spUpdateAccountLastLogoutTime (4294967295)} ), ErrCode( -1 )
ErrMsg - Error converting data type numeric to int.
State:37000,Native:8114,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

:(((((

[Anju]

sqGetAccountInfo and spUpdateAccountLastLogoutTime.

[proasd1]

sqGetAccountInfo and spUpdateAccountLastLogoutTime.

and ??

[MAXTRAXv3]

your missing tables, or you have filed them in witch you wasnt ment to do.

[proasd1]

its not about db q-q

using emisand's db

[Anju]

It's more likely database problem.

[proasd1]

i tried 3 db still same sht :o

i think i was know how to fix but cant remember there changing something about tables O.o

EDIT : I FOUND DA F*CKING PROBLEM ITS ABOUT PC -.-

i tried in virtual box its working fine :o so /close this sht -.-