Mysql

[a7aa7a]

[17:16:38.781] mysql_real_query(): SELECT `id`, `guild_id`, `enemy_id` FROM `gui
ld_wars` WHERE `status` IN (1,4) AND `end` > 0 AND `end` < 1402240598 - MYSQL ER
ROR: Table 'thais.guild_wars' doesn't exist (1146)

 

[a7aa7a]

bumb

 

[Evil Puncker]

is your db named thais? if yes then it doesn't have a table called guild_wars

 

[a7aa7a]

no not my dp , how i can add this table

 

[Limos]

http://otland.net/threads/no-wars-in-schema.210089/#post-2013368

How to run a query:
http://otland.net/threads/mysql-how-to-run-a-query.177833/

If you are looking for a table, you can write create table + name of the table in search.

This way you will find the right queries to create the table you are missing.

 

[a7aa7a]

ok thank you but i can't find what i need

 

[Limos]

I posted the link to the query, the second link is a tutorial how to run the query.

 

[elking]

I posted the link to the query, the second link is a tutorial how to run the query.

I have the same problem I can't add

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;

I use sqlitestudio

 

[dominique120]

I have the same problem I can't add

I use sqlitestudio

SQLlite syntax is different than MySQL

 

[elking]

SQLlite syntax is different than MySQL

Then How can I add it ?!