Help with problem, login off.

[werednnbs 431]

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 x100

It's really important to start my project.

Thanks!

[Ayaka 295]

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.

[werednnbs 431]

-> 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

[Ayaka 295]

-> 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

[Krusty 32]

-> 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

[Ayaka 295]

-> 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 :'D
https://metin2.download/picture/ysIn4J5rqg66Yv4o6N2LFUYnsuF4ZMT6/.png

 

Edited August 19, 2022 by Metin2 Dev
Core X - External 2 Internal