RevScripts Mysql login history table

[Guralztr]

Hello, can someone gives lines for sql?

[11:29:16.831] mysql_real_query(): DELETE FROM login_history WHERE date < 1707650956 - MYSQL ERROR: Table 'ots.login_history' doesn't exist (1146)

 

[tobi132]

Can you post the script? I maybe have a sql for this.

 

[highsanta]

CREATE TABLE login_history (

    id INT PRIMARY KEY AUTO_INCREMENT,

    date INT

);

 

[Guralztr]

It works but now I have
MYSQL ERROR: Unknown column 'account_id' in 'field list' (1054)

 

[tobi132]

CREATE TABLE IF NOT EXISTS `login_history`
(
`id` INT(11) NOT NULL AUTO_INCREMENT,
`account_id` INT(11) NOT NULL DEFAULT 0,
`player_id` INT(11) NOT NULL DEFAULT 0,
`where` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '1 - server, 2 - website',
`type` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '1 - login, 2 - logout',
`ip` VARCHAR(45) NOT NULL DEFAULT '',
`date` INT(11) NOT NULL DEFAULT 0,
 PRIMARY KEY (`id`)
) ENGINE = InnoDB;

Delete the table and execute this.

 

[Guralztr]

CREATE TABLE IF NOT EXISTS `login_history`
(
`id` INT(11) NOT NULL AUTO_INCREMENT,
`account_id` INT(11) NOT NULL DEFAULT 0,
`player_id` INT(11) NOT NULL DEFAULT 0,
`where` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '1 - server, 2 - website',
`type` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '1 - login, 2 - logout',
`ip` VARCHAR(45) NOT NULL DEFAULT '',
`date` INT(11) NOT NULL DEFAULT 0,
 PRIMARY KEY (`id`)
) ENGINE = InnoDB;

Delete the table and execute this.

Table added but still error
mysql_real_query(): INSERT INTO login_history (account_id, player_id, type, login, ip, date) VALUES (7, 15, 1, 1, 1, 1) - MYSQL ERROR: Table 'ots.login_history' doesn't exist (1146)

 

[highsanta]

because you removed the table are u reading the errror you put the SQL in wrong database 'ots.login_history' doesn't exist (1146)

 

[Guralztr]

I put in correct database, and Im getting this error dont know why

because you removed the table are u reading the errror you put the SQL in wrong database 'ots.login_history' doesn't exist (1146)

 

[highsanta]

'ots.login_history' doesn't exist (1146)
this error says otherwise.

 

[Mateus Robeerto]

try.

CREATE TABLE IF NOT EXISTS `login_history`
(
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `account_id` INT(11) NOT NULL DEFAULT 0,
  `player_id` INT(11) NOT NULL DEFAULT 0,
  `where` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '1 - server, 2 - website',
  `type` TINYINT(1) NOT NULL DEFAULT 0 COMMENT '1 - login, 2 - logout',
  `login` TINYINT(1) NOT NULL DEFAULT 0,
  `ip` VARCHAR(45) NOT NULL DEFAULT '',
  `date` INT(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE = InnoDB;