Error at game Server COS problem

06/29/2018 09:56 kotsh#1
please how i can fix it
my Pick pet page is 1

[Only registered and activated users can see links. Click Here To Register...]
06/29/2018 17:08 JustNrik#2
pick pet page has nothing to do with that error (gs simply crashes and that's it)

you probably fucked up something in the database. Did you add a new pet or commit an update on RefObjChar/Common with pets involved on it?
07/01/2018 11:46 kotsh#3
Quote:
Originally Posted by JustNrik View Post
pick pet page has nothing to do with that error (gs simply crashes and that's it)

you probably fucked up something in the database. Did you add a new pet or commit an update on RefObjChar/Common with pets involved on it?
no i didnt add anything or update anything
07/02/2018 00:32 JustNrik#4
Which database are you using in the first place?
07/03/2018 19:02 kotsh#5
Elyson
07/06/2018 06:59 JustNrik#6
there must be something wrong db-side, try running this query and share result:

SELECT *
FROM _RefObjCommon roc
JOIN _RefObjChar rocha ON rocha.ID = roc.Link
JOIN _RefObjItem roi ON roi.ID = roc.Link
WHERE ID IN (12848,12781,13929,13588)

I'm almost sure something must be wrong with db lines, you could also compare these lines with other pet's lines, I join both tables since I don't know which one is a pet scroll or the pet itself, you should know it though (check char for pet and item for pet scroll)
07/08/2018 00:11 kotsh#7
[Only registered and activated users can see links. Click Here To Register...]

code error
07/08/2018 18:11 JustNrik#8
dude use your brain, can't you concatenate "roc." and "ID" as I missed it?