Windows Some Console Error

[Lakh]

Hey, everytime I start my server, or try to login, I get this message..

[19:35:01.662] mysql_real_query(): UPDATE `guild_wars` SET `status` = 5, `end` =
 1316306101 WHERE `status` = 1 AND `end` > 0 AND `end` < 1316306101; - MYSQL ERR
OR: Table 'delyria2.guild_wars' doesn't exist (1146)
[19:35:01.663] mysql_real_query(): DELETE FROM `guild_wars` WHERE `status` = 0 A
ND `begin` < 1316133301; - MYSQL ERROR: Table 'delyria2.guild_wars' doesn't exis
t (1146)
[19:35:01.665] mysql_real_query(): SELECT `name`, `password`, `salt`, `premdays`
, `lastday`, `key`, `warnings` FROM `accounts` WHERE `id` = 1 LIMIT 1 - MYSQL ER
ROR: Unknown column 'salt' in 'field list' (1054)
[19:35:01.666] > Global IP address: 127.0.0.1
[19:35:01.668] > Local IP address(es): 192.168.1.2
[19:35:01.668] > Bound ports: 7171      7172
[19:35:01.669] >> Everything smells good, server is starting up...
[19:35:01.670] >> Delyria server Online!


[19:35:04.979] mysql_real_query(): SELECT `name`, `password`, `salt`, `premdays`
, `lastday`, `key`, `warnings` FROM `accounts` WHERE `id` = 1 LIMIT 1 - MYSQL ER
ROR: Unknown column 'salt' in 'field list' (1054)
[19:35:06.563] mysql_real_query(): SELECT `name`, `password`, `salt`, `premdays`
, `lastday`, `key`, `warnings` FROM `accounts` WHERE `id` = 1 LIMIT 1 - MYSQL ER
ROR: Unknown column 'salt' in 'field list' (1054)

 

[Alyhide]

For the Guild Wars

CREATE TABLE IF NOT EXISTS `guild_wars` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `guild_id` INT NOT NULL,
  `enemy_id` INT NOT NULL,
  `begin` BIGINT NOT NULL DEFAULT '0',
  `end` BIGINT NOT NULL DEFAULT '0',
  `frags` INT UNSIGNED NOT NULL DEFAULT '0',
  `payment` BIGINT UNSIGNED NOT NULL DEFAULT '0',
  `guild_kills` INT UNSIGNED NOT NULL DEFAULT '0',
  `enemy_kills` INT UNSIGNED NOT NULL DEFAULT '0',
  `status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `status` (`status`),
  KEY `guild_id` (`guild_id`),
  KEY `enemy_id` (`enemy_id`)
) ENGINE=InnoDB;
 
ALTER TABLE `guild_wars`
  ADD CONSTRAINT `guild_wars_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `guild_wars_ibfk_2` FOREIGN KEY (`enemy_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;
 
ALTER TABLE `guilds` ADD `balance` BIGINT UNSIGNED NOT NULL AFTER `motd`;
 
CREATE TABLE IF NOT EXISTS `guild_kills` (
  `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `guild_id` INT NOT NULL,
  `war_id` INT NOT NULL,
  `death_id` INT NOT NULL
) ENGINE = InnoDB;
 
ALTER TABLE `guild_kills`
  ADD CONSTRAINT `guild_kills_ibfk_1` FOREIGN KEY (`war_id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `guild_kills_ibfk_2` FOREIGN KEY (`death_id`) REFERENCES `player_deaths` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `guild_kills_ibfk_3` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;
 
ALTER TABLE `killers` ADD `war` INT NOT NULL DEFAULT 0;

And second:

generateAccountSalt = true

 

[Lakh]

Thanks worked