erro no sqlite

[MatheusFiesta 1]

Eae TK , será que alguem pd me ajudar ?

Hidden Content

Give reaction to this post to see the hidden content.

[kaio Santos 32]

Eae TK , será que alguem pd me ajudar ?

Hidden Content

Give reaction to this post to see the hidden content.

Voce não pode deletar acc do god tente deletar todas as guilds do database para ver se funciona se não funcionar pegue outra database.

[jvsa13 0]

galera ME AJUDA PF

[21/06/2014 10:56:16] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "WERE": syntax error (UPDATE "players" SET "online" = 0 WERE "world_id" = 0;)

[21/06/2014 10:56:16] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "WERE": syntax error (DELETE FROM "guild_wars" WERE "status" = 0 AND "begin" < 1403186176;)

[21/06/2014 10:56:16] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "WERE": syntax error (UPDATE "guild_wars" SET "status" = 5, "end" = 1403358976 WERE "status" = 1 AND "end" > 0 AND "end" < 1403358976;)

ta aparecendo isso, como eu arrumo??

[Alidev 42]

 

galera ME AJUDA PF

[21/06/2014 10:56:16] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "WERE": syntax error (UPDATE "players" SET "online" = 0 WERE "world_id" = 0;)

[21/06/2014 10:56:16] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "WERE": syntax error (DELETE FROM "guild_wars" WERE "status" = 0 AND "begin" < 1403186176;)

[21/06/2014 10:56:16] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "WERE": syntax error (UPDATE "guild_wars" SET "status" = 5, "end" = 1403358976 WERE "status" = 1 AND "end" > 0 AND "end" < 1403358976;)

ta aparecendo isso, como eu arrumo??

 

 

Execute isso no seu banco de dados:

 

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;

[jvsa13 0]

desculpa mas eu sou novo e n sei aonde eh o banco de dados tem como me falar?