Jump to content

Recommended Posts

Hi Guy's

like always 

i have bug with db server

while i add the binding system and it's all perfect 

but ....

when my inventory have some weapon's  and poison's and some book's 

and i logout and login again 

all my inventory gone 

like i'm doing /ip 

this is the sysser from my db server

Spoiler

SYSERR: Oct 18 19:46:55.340524 :: pid_init: 
Start of pid: 743

SYSERR: Oct 18 19:46:55.351390 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 18 19:47:04.904124 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Oct 18 19:47:23.662324 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)
SYSERR: Oct 18 19:47:23.668073 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)
SYSERR: Oct 18 19:51:11.73068 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Oct 18 19:54:51.524099 :: pid_init: 
Start of pid: 714

SYSERR: Oct 18 19:54:51.552583 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Oct 18 19:55:02.264037 :: Load:  DirectQuery failed(SELECT IP_FROM, IP_TO, COUNTRY_NAME FROM iptocountry)
SYSERR: Oct 18 19:55:17.970553 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)
SYSERR: Oct 18 19:55:18.4166 :: __GetHostInfo: __GetHostInfo() ==> DirectQuery failed(SELECT mIP FROM gmhost)
SYSERR: Oct 18 20:08:36.829085 :: ChildLoop: AsyncSQL: query failed: Unknown column 'applytype0' in 'field list' (query: SELECT id, window+0, pos, count, vnum, bind, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7 FROM item WHERE owner_id=157 AND (window < 3 or window = 5) errno: 1054)
SYSERR: Oct 18 20:08:36.942252 :: RESULT_COMPOSITE_PLAYER: null MYSQL_RES QID 1
SYSERR: Oct 18 20:29:59.192219 :: ChildLoop: AsyncSQL: query failed: Unknown column 'applytype0' in 'field list' (query: SELECT id, window+0, pos, count, vnum, bind, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7 FROM item WHERE owner_id=157 AND (window < 3 or window = 5) errno: 1054)
SYSERR: Oct 18 20:29:59.291231 :: RESULT_COMPOSITE_PLAYER: null MYSQL_RES QID 1
SYSERR: Oct 18 20:36:50.997685 :: ChildLoop: AsyncSQL: query failed: Unknown column 'applytype0' in 'field list' (query: SELECT id, window+0, pos, count, vnum, bind, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7 FROM item WHERE owner_id=157 AND (window < 3 or window = 5) errno: 1054)
SYSERR: Oct 18 20:36:51.40287 :: RESULT_COMPOSITE_PLAYER: null MYSQL_RES QID 1
SYSERR: Oct 18 20:39:21.445938 :: ChildLoop: AsyncSQL: query failed: Unknown column 'applytype0' in 'field list' (query: SELECT id, window+0, pos, count, vnum, bind, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7 FROM item WHERE owner_id=100 AND window='SAFEBOX' errno: 1054)
SYSERR: Oct 18 20:39:21.512941 :: RESULT_SAFEBOX_LOAD: null safebox result
SYSERR: Oct 18 20:41:56.708493 :: ChildLoop: AsyncSQL: query failed: Unknown column 'applytype0' in 'field list' (query: SELECT id, window+0, pos, count, vnum, bind, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7 FROM item WHERE owner_id=171 AND (window < 3 or window = 5) errno: 1054)
SYSERR: Oct 18 20:41:56.807257 :: RESULT_COMPOSITE_PLAYER: null MYSQL_RES QID 1
SYSERR: Oct 18 20:44:45.315675 :: ChildLoop: AsyncSQL: query failed: Unknown column 'applytype0' in 'field list' (query: SELECT id, window+0, pos, count, vnum, bind, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7 FROM item WHERE owner_id=171 AND (window < 3 or window = 5) errno: 1054)
SYSERR: Oct 18 20:44:45.415324 :: RESULT_COMPOSITE_PLAYER: null MYSQL_RES QID 1

#2 :

the second problem when i trying to open the storge and write 000000 password the storge Window do not show 

i hope you gonna help me

Link to comment
Share on other sites

  • Bronze

Read the error.  query failed: Unknown column 'applytype0' in 'field list' (query: SELECT id, window+0, pos, count, vnum, bind, socket0, socket1, socket2, attrtype0, attrvalue0, attrtype1, attrvalue1, attrtype2, attrvalue2, attrtype3, attrvalue3, attrtype4, attrvalue4, attrtype5, attrvalue5, attrtype6, attrvalue6, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, applytype3, applyvalue3, applytype4, applyvalue4, applytype5, applyvalue5, applytype6, applyvalue6, applytype7, applyvalue7 FROM item WHERE owner_id=157 AND (window < 3 or window = 5).

The column "applytype0" doesn't exist in table "item".

  • Love 1
Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.