Jump to content
×
×
  • Create New...
  • 0

Help with problem, login off.


bigdon

Question

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
Share on other sites

  • Answers 5
  • Created
  • Last Reply

Top Posters For This Question

5 answers to this question

Recommended Posts

  • 0

-> 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
Share on other sites

  • 0

-> 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 (http://i.imgur.com/JKGlugK.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 Ayaka
  • Angry 1
Link to comment
Share on other sites

  • 0

-> 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 (http://i.imgur.com/JKGlugK.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');

 

  • Angry 1
Link to comment
Share on other sites

  • 0

-> 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 (http://i.imgur.com/JKGlugK.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
http://i.imgur.com/QpQoUGg.png

 

Edited by Ayaka
  • Not Good 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Activity

    1. 2

      Problem freebsd

    2. 0

      Making chain quest

    3. 4

      Ludus2: a metin2-like browser game

    4. 6
    5. 9

      Help in implementing a switch bot

    6. 0

      Special Inventory System Can't Sell To Npc's

    7. 0

      ROV2.GLOBAL | International | Server start 14.05.2022

    8. 75

      Services - System Ard [C ++ / Python / Lua]

  • Recently Browsing

    • No registered users viewing this page.

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.