icewolf 27 Posted October 18, 2016 Share Posted October 18, 2016 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 More sharing options...
icewolf 27 Posted October 19, 2016 Author Share Posted October 19, 2016 #Refresh Link to comment Share on other sites More sharing options...
Ayaka 300 Posted October 19, 2016 Share Posted October 19, 2016 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". 1 F E E L - T H E - A W E S O M E N E S S Link to comment Share on other sites More sharing options...
icewolf 27 Posted October 19, 2016 Author Share Posted October 19, 2016 How i can solve it !! Link to comment Share on other sites More sharing options...
icewolf 27 Posted October 20, 2016 Author Share Posted October 20, 2016 #Refresh Link to comment Share on other sites More sharing options...
iltizio 217 Posted October 20, 2016 Share Posted October 20, 2016 15 hours ago, icewolf said: How i can solve it !! It's clear. You need to add column applytype0 on table item. Link to comment Share on other sites More sharing options...
icewolf 27 Posted October 20, 2016 Author Share Posted October 20, 2016 i will try it and send the result's did'nt Work Link to comment Share on other sites More sharing options...
icewolf 27 Posted October 21, 2016 Author Share Posted October 21, 2016 #Refresh Link to comment Share on other sites More sharing options...
icewolf 27 Posted October 22, 2016 Author Share Posted October 22, 2016 #edit the storge problem solved still 1 problem Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now