[For SQL Experts] Tables RelationShips request
Alright i figured that the bug i have is because i deleted once the Relationships in the following tables.
_Items
_ItemsPool
_Inventory
_InvCOS
_Inventoryforavatar
_Inventoryforlinkedstorage
_ItemQuotation
_Chest
question is , any knows how i can re-add the relationships this tables had by default ?
Every time i try adding the relationship i get this
Code:
'_Items' table saved successfully
'_Inventory' table
- Unable to create relationship 'FK__Inventory__Items'.
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK__Inventory__Items". The conflict occurred in database "SRO_VT_SHARD", table "dbo._Items", column 'ID64'.
So if i remove the key , it will say is invalid and needs the key - _ -. SO idk what to do.
Re: [For SQL Experts] Tables RelationShips request
probrem is? ... it should work fine with or without the relations
Re: [For SQL Experts] Tables RelationShips request
As far as I know relations are just used by the database for keep the data sync between tables, shouldn't affect anything ingame. I mean, even without relations, the serverfiles will just read the tables and thats all.
Re: [For SQL Experts] Tables RelationShips request
The problem is , players cant buy from npc. I mean from any npc in any town. They will just get disconnected. Same thing goes for picking up items from the floor.
The game server will start spamming the error "Invalid Inventory Information" and many others. For example.
Code:
fatal Invalid Inventory Information! OBJDBID[246928] Slot[3] Item[2] 2012-02-20 09:52:02 347
fatal D:\WORK2005\Source\SilkroadOnline\Server\SR_GameServer\GObjPC.cpp, CGObjPC::_AsyncQuerySucceeded, 7275 2012-02-20 09:52:05 389
warnning AQ succeeded but AsyncQueryCompleted() error occurred [AQType: 18] 2012-02-20 09:52:05 389
fatal D:\WORK2005\Source\SilkroadOnline\Server\SR_GameServer\GObjPC.cpp, CGObjPC::_AsyncQuerySucceeded, 7275 2012-02-20 09:52:07 385
warnning AQ succeeded but AsyncQueryCompleted() error occurred [AQType: 18] 2012-02-20 09:52:07 385
fatal D:\WORK2005\Source\SilkroadOnline\Server\SR_GameServer\GObjPC.cpp, CGObjPC::_AsyncQuerySucceeded, 7237 2012-02-20 09:52:23 921
warnning AQ succeeded but AsyncQueryCompleted() error occurred [AQType: 18] 2012-02-20 09:52:23 921
fatal Storage Operation Failed!!! [OperationType: 6, ErrorCode: -1] 2012-02-20 09:52:30 770
warnning Query: {CALL _STRG_ADD_ITEM_MAGIC (?, ?, 6, 356098,16, 13825,0,385883301,70, 2,25769803826,25769803831,0,0,0,0,0,0,0,0,0,0)} 2012-02-20 09:52:30 770
warnning AQ Failed! Log out!! [AQType: 1] 2012-02-20 09:52:30 770
fatal D:\WORK2005\Source\SilkroadOnline\Server\SR_GameServer\GObjPC.cpp, CGObjPC::_AsyncQuerySucceeded, 7237 2012-02-20 09:52:42 423
warnning AQ succeeded but AsyncQueryCompleted() error occurred [AQType: 18] 2012-02-20 09:52:42 423
fatal D:\WORK2005\Source\SilkroadOnline\Server\SR_GameServer\GObjPC.cpp, CGObjPC::_AsyncQuerySucceeded, 7275 2012-02-20 09:52:42 423
warnning AQ succeeded but AsyncQueryCompleted() error occurred [AQType: 18] 2012-02-20 09:52:42 423
fatal DB Query Error(100): {CALL _STRG_ADD_ITEM_MAGIC (?, ?, 6, 295735,15, 39161,4,0,85, 1,8589934671,0,0,0,0,0,0,0,0,0,0,0)} 2012-02-20 09:52:54 170
fatal Storage Operation Failed!!! [OperationType: 6, ErrorCode: 0] 2012-02-20 09:52:54 248
warnning Query: {CALL _STRG_ADD_ITEM_MAGIC (?, ?, 6, 295735,15, 39161,4,0,85, 1,8589934671,0,0,0,0,0,0,0,0,0,0,0)} 2012-02-20 09:52:54 248
warnning AQ Failed! Log out!! [AQType: 1] 2012-02-20 09:52:54 248
Re: [For SQL Experts] Tables RelationShips request
Quote:
Originally Posted by
Larkon
The problem is , players cant buy from npc. I mean from any npc in any town. They will just get disconnected. Same thing goes for picking up items from the floor.
The game server will start spamming the error "Invalid Inventory Information" and many others. For example.
Code:
fatal Invalid Inventory Information! OBJDBID[246928] Slot[3] Item[2] 2012-02-20 09:52:02 347
fatal D:\WORK2005\Source\SilkroadOnline\Server\SR_GameServer\GObjPC.cpp, CGObjPC::_AsyncQuerySucceeded, 7275 2012-02-20 09:52:05 389
warnning AQ succeeded but AsyncQueryCompleted() error occurred [AQType: 18] 2012-02-20 09:52:05 389
fatal D:\WORK2005\Source\SilkroadOnline\Server\SR_GameServer\GObjPC.cpp, CGObjPC::_AsyncQuerySucceeded, 7275 2012-02-20 09:52:07 385
warnning AQ succeeded but AsyncQueryCompleted() error occurred [AQType: 18] 2012-02-20 09:52:07 385
fatal D:\WORK2005\Source\SilkroadOnline\Server\SR_GameServer\GObjPC.cpp, CGObjPC::_AsyncQuerySucceeded, 7237 2012-02-20 09:52:23 921
warnning AQ succeeded but AsyncQueryCompleted() error occurred [AQType: 18] 2012-02-20 09:52:23 921
fatal Storage Operation Failed!!! [OperationType: 6, ErrorCode: -1] 2012-02-20 09:52:30 770
warnning Query: {CALL _STRG_ADD_ITEM_MAGIC (?, ?, 6, 356098,16, 13825,0,385883301,70, 2,25769803826,25769803831,0,0,0,0,0,0,0,0,0,0)} 2012-02-20 09:52:30 770
warnning AQ Failed! Log out!! [AQType: 1] 2012-02-20 09:52:30 770
fatal D:\WORK2005\Source\SilkroadOnline\Server\SR_GameServer\GObjPC.cpp, CGObjPC::_AsyncQuerySucceeded, 7237 2012-02-20 09:52:42 423
warnning AQ succeeded but AsyncQueryCompleted() error occurred [AQType: 18] 2012-02-20 09:52:42 423
fatal D:\WORK2005\Source\SilkroadOnline\Server\SR_GameServer\GObjPC.cpp, CGObjPC::_AsyncQuerySucceeded, 7275 2012-02-20 09:52:42 423
warnning AQ succeeded but AsyncQueryCompleted() error occurred [AQType: 18] 2012-02-20 09:52:42 423
fatal DB Query Error(100): {CALL _STRG_ADD_ITEM_MAGIC (?, ?, 6, 295735,15, 39161,4,0,85, 1,8589934671,0,0,0,0,0,0,0,0,0,0,0)} 2012-02-20 09:52:54 170
fatal Storage Operation Failed!!! [OperationType: 6, ErrorCode: 0] 2012-02-20 09:52:54 248
warnning Query: {CALL _STRG_ADD_ITEM_MAGIC (?, ?, 6, 295735,15, 39161,4,0,85, 1,8589934671,0,0,0,0,0,0,0,0,0,0,0)} 2012-02-20 09:52:54 248
warnning AQ Failed! Log out!! [AQType: 1] 2012-02-20 09:52:54 248
I Have the Same Problem :S