werednnbs 442 Posted September 16, 2015 Share Posted September 16, 2015 Hi guy, I would like to ask for help with this problem, my server has a problem trying to enter. When the loading bar finishes loading exits to login.I guess it's this syserr log in db. SYSERR: Sep 15 22:14:57.508594 :: Start: TABLE_POSTFIX not configured use default SYSERR: Sep 15 22:14:57.535325 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'common.priv_settings' doesn't exist query: DELETE FROM priv_settings WHERE value <= 0 OR duration <= NOW(); SYSERR: Sep 15 22:14:57.535982 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'common.priv_settings' doesn't exist query: SELECT priv_type, id, type, value, UNIX_TIMESTAMP(duration) FROM priv_settings SYSERR: Sep 15 22:26:27.281164 :: ChildLoop: AsyncSQL: query failed: Unknown column 'applytype0' in 'field list' (query: SELECT id,window+0,pos,count,vnum,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=205 AND (window < 3 or window = 5) errno: 1054) SYSERR: Sep 15 22:26:27.379370 :: RESULT_COMPOSITE_PLAYER: null MYSQL_RES QID 1 Syserr CH1 SYSERR: Sep 16 00:24:25.975304 :: Empire: EmpireSelectFailed 178 SYSERR: Sep 16 00:41:08.312523 :: Empire: EmpireSelectFailed 182 SYSERR: Sep 16 00:46:48.47724 :: Empire: EmpireSelectFailed 171 SYSERR: Sep 16 00:47:27.981959 :: Empire: EmpireSelectFailed 107 SYSERR: Sep 16 00:48:41.970722 :: Empire: EmpireSelectFailed 173 SYSERR: Sep 16 00:51:26.240792 :: Empire: EmpireSelectFailed 110 SYSERR: Sep 16 00:52:48.734410 :: Empire: EmpireSelectFailed 171 SYSERR: Sep 16 00:54:06.32899 :: Empire: EmpireSelectFailed 171 SYSERR: Sep 16 00:54:17.970222 :: Empire: EmpireSelectFailed 171 SYSERR: Sep 16 00:54:54.90334 :: Empire: EmpireSelectFailed 171 SYSERR: Sep 16 00:56:14.210398 :: Empire: EmpireSelectFailed 110 SYSERR: Sep 16 00:58:18.679323 :: Empire: EmpireSelectFailed 171 SYSERR: Sep 16 00:59:29.816634 :: Empire: EmpireSelectFailed 171 SYSERR: Sep 16 00:59:41.495908 :: Empire: EmpireSelectFailed 171 LOGS x100It's really important to start my project.Thanks! Link to comment Share on other sites More sharing options...
Ayaka 300 Posted September 16, 2015 Share Posted September 16, 2015 At first you guys should learn how to set up your database and tables befor starting an "Epic pServer". -> Table 'common.priv_settings' doesn't exist -> Unknown column 'applytype0' in 'field list' what is more to say? All you have to do is reading and adding. 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...
werednnbs 442 Posted September 16, 2015 Author Share Posted September 16, 2015 (edited) -> Table 'common.priv_settings' doesn't exist 1º-> Unknown column 'applytype0' in 'field list' 2º 1º: ---- I know this problem well. Obviously read. The only problem is that not even that is the table because I've never seen, if someone has a .sql file or querys please share it. 2º: ---- This is what I literally do not know. Edited September 16, 2015 by bigdon Link to comment Share on other sites More sharing options...
Ayaka 300 Posted September 16, 2015 Share Posted September 16, 2015 (edited) -> Table 'common.priv_settings' doesn't exist 1º-> Unknown column 'applytype0' in 'field list' 2º 1º: ---- I know this problem well. Obviously read. The only problem is that not even that is the table because I've never seen, if someone has a .sql file or querys please share it. 2º: ---- This is what I literally do not know. 1: You have the query already Use one of the already existng columns in your database - copy and paste, but dont forget to rename it to applytype0 (https://metin2.download/picture/WLvGLos8B7wlHGREU9a51u7zR4qwD77Y/.png) the structure should be the same 2: I googled for it and found one but is it the right one? i dont know ... just test it and add it in common database: CREATE TABLE `priv_settings` ( `priv_type` enum('PLAYER','GUILD','EMPIRE') NOT NULL DEFAULT 'EMPIRE' COMMENT 'GUILD and PLAYER are untested.' , `id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'this is for empire_id, player_id or guild_id' , `type` int UNSIGNED NOT NULL DEFAULT 4 COMMENT '1:item_drop, 2:gold_drop, 3:gold10_drop, 4:exp (1~4)' , `value` int NOT NULL DEFAULT 0 COMMENT '0~1000%' , `duration` datetime NOT NULL DEFAULT 0 , PRIMARY KEY (`priv_type`, `id`, `type`) ); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '1', '200', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '2', '66', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '3', '1', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '4', '15', '2014-08-07 14:26:03'); source: epvpersucks Edited August 19, 2022 by Metin2 Dev Core X - External 2 Internal 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...
Krusty 32 Posted September 17, 2015 Share Posted September 17, 2015 (edited) -> Table 'common.priv_settings' doesn't exist 1º-> Unknown column 'applytype0' in 'field list' 2º 1º: ---- I know this problem well. Obviously read. The only problem is that not even that is the table because I've never seen, if someone has a .sql file or querys please share it. 2º: ---- This is what I literally do not know. 1: You have the query already Use one of the already existng columns in your database - copy and paste, but dont forget to rename it to applytype0 (https://metin2.download/picture/WLvGLos8B7wlHGREU9a51u7zR4qwD77Y/.png) the structure should be the same 2: I googled for it and found one but is it the right one? i dont know ... just test it and add it in common database: CREATE TABLE `priv_settings` ( `priv_type` enum('PLAYER','GUILD','EMPIRE') NOT NULL DEFAULT 'EMPIRE' COMMENT 'GUILD and PLAYER are untested.' , `id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'this is for empire_id, player_id or guild_id' , `type` int UNSIGNED NOT NULL DEFAULT 4 COMMENT '1:item_drop, 2:gold_drop, 3:gold10_drop, 4:exp (1~4)' , `value` int NOT NULL DEFAULT 0 COMMENT '0~1000%' , `duration` datetime NOT NULL DEFAULT 0 , PRIMARY KEY (`priv_type`, `id`, `type`) ); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '1', '200', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '2', '66', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '3', '1', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '4', '15', '2014-08-07 14:26:03'); source: epvpersucks lol, why? @Ayaka INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '1', '200', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '2', '66', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '3', '1', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '4', '15', '2014-08-07 14:26:03'); Edited August 19, 2022 by Metin2 Dev Core X - External 2 Internal 1 Link to comment Share on other sites More sharing options...
Ayaka 300 Posted September 17, 2015 Share Posted September 17, 2015 (edited) -> Table 'common.priv_settings' doesn't exist 1º-> Unknown column 'applytype0' in 'field list' 2º 1º: ---- I know this problem well. Obviously read. The only problem is that not even that is the table because I've never seen, if someone has a .sql file or querys please share it. 2º: ---- This is what I literally do not know. 1: You have the query already Use one of the already existng columns in your database - copy and paste, but dont forget to rename it to applytype0 (https://metin2.download/picture/WLvGLos8B7wlHGREU9a51u7zR4qwD77Y/.png) the structure should be the same 2: I googled for it and found one but is it the right one? i dont know ... just test it and add it in common database: CREATE TABLE `priv_settings` ( `priv_type` enum('PLAYER','GUILD','EMPIRE') NOT NULL DEFAULT 'EMPIRE' COMMENT 'GUILD and PLAYER are untested.' , `id` int UNSIGNED NOT NULL DEFAULT 0 COMMENT 'this is for empire_id, player_id or guild_id' , `type` int UNSIGNED NOT NULL DEFAULT 4 COMMENT '1:item_drop, 2:gold_drop, 3:gold10_drop, 4:exp (1~4)' , `value` int NOT NULL DEFAULT 0 COMMENT '0~1000%' , `duration` datetime NOT NULL DEFAULT 0 , PRIMARY KEY (`priv_type`, `id`, `type`) ); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '1', '200', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '2', '66', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '3', '1', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '4', '15', '2014-08-07 14:26:03'); source: epvpersucks lol, why? @Ayaka INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '1', '200', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '2', '66', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '3', '1', '2014-08-07 14:26:03'); INSERT INTO `priv_settings` VALUES ('EMPIRE', '0', '4', '15', '2014-08-07 14:26:03'); because you have to fill it with: 1:item_drop, 2:gold_drop, 3:gold10_drop, 4:exp (1~4) like the comment in column "type" says? lol -> 4 types -> 4 inserts with the value for each type .... is it that hard to understand? oh, AND because your pissed that im not answering your pms :'Dhttps://metin2.download/picture/ysIn4J5rqg66Yv4o6N2LFUYnsuF4ZMT6/.png Edited August 19, 2022 by Metin2 Dev Core X - External 2 Internal 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...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now