Jump to content

Help with problem, login off.

werednnbs
 Share

Recommended Posts

  • Active+ Member
werednnbs Community Regular

werednnbs 817

Posted
  • Active+ Member
Posted

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!

Link to comment
https://metin2.dev/topic/8588-help-with-problem-login-off/
Share on other sites
  • Replies 5
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

Ayaka
Ayaka

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

Krusty
Krusty

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 IN

Ayaka
Ayaka

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

Ayaka Community Regular

Ayaka 322

Posted
Posted

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
https://metin2.dev/topic/8588-help-with-problem-login-off/#findComment-52607
Share on other sites
  • Active+ Member
werednnbs Community Regular

werednnbs 817

Posted
  • Author
  • Active+ Member
Posted (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 by bigdon
Link to comment
https://metin2.dev/topic/8588-help-with-problem-login-off/#findComment-52627
Share on other sites
Ayaka Community Regular

Ayaka 322

Posted
Posted (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 by Metin2 Dev
Core X - External 2 Internal
  • Angry 1

F E E L  -  T H E  -  A W E S O M E N E S S

Link to comment
https://metin2.dev/topic/8588-help-with-problem-login-off/#findComment-52635
Share on other sites
Krusty Community Regular

Krusty 36

Posted
Posted (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 by Metin2 Dev
Core X - External 2 Internal
  • Angry 1
Link to comment
https://metin2.dev/topic/8588-help-with-problem-login-off/#findComment-52640
Share on other sites
Ayaka Community Regular

Ayaka 322

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

 

Edited by Metin2 Dev
Core X - External 2 Internal
  • Not Good 1

F E E L  -  T H E  -  A W E S O M E N E S S

Link to comment
https://metin2.dev/topic/8588-help-with-problem-login-off/#findComment-52651
Share on other sites

Don't use any images from : imgur, turkmmop, freakgamers, inforge, hizliresim... Or your content will be deleted without notice...
Use : https://metin2.download/media/add/

Please use https://metin2.download/ when uploading files smaller than 100MB, otherwise the approval will take longer due to manual upload.

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
 Share
Go to topic listing
×
×
  • 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.