GameServer Error !

05/22/2015 17:57 !Ego#1

Hello Guy's !!
can some one help me with this
[Only registered and activated users can see links. Click Here To Register...]

05/22/2015 22:13 Dracula Untold#2

Database problem ...

05/22/2015 22:56 Xutan*#3

there is an item in npc which have no package
fix :-
run this query, you will have 4 results maybe you will find one of them without lines. tell me which one have no lines in result. then i'll give you query to add the missing line.

PHP Code:


			
SELECT * FROM _RefShopGoods WHERE RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_HEAVY_04_FA_A'
SELECT * FROM _RefScrapOfPackageItem WHERE RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_HEAVY_04_FA_A'
SELECT * FROM _RefPricePolicyOfItem WHERE RefPackageItemCodeName like 'PACKAGE_ITEM_EU_M_HEAVY_04_FA_A'
SELECT * FROM _RefPackageItem WHERE CodeName128 like 'PACKAGE_ITEM_EU_M_HEAVY_04_FA_A'

05/22/2015 22:56 Eslam Galull#4

well its happen in case you using a released db without a primary id lock in refobjcommon
so

- you aready added the same id twice
Or
- you add the same code twice

soultion

Remove last lines you have done , or set service to 0 and try again

05/22/2015 23:05 Xutan*#5

Quote:

Originally Posted by its.soul

well its happen in case you using a released db without a primary id lock in refobjcommon
so

- you aready added the same id twice
Or
- you add the same code twice

soultion

Remove last lines you have done , or set service to 0 and try again

alright, this is a possible reason too.
query to check how many lines with same ID

PHP Code:


			
SELECT * FROM _RefObjCommon WHERE ID = --put last lines id then previous ...etc
--if you found 2 lines with same id then you should know where the problem is.

query to check how many lines with same codename

PHP Code:


			
SELECT * FROM _RefObjCommon WHERE CodeName128 like 'codename here'
-- do the same like above but with codename