Postado Janeiro 9, 2015 10 anos Olá amigo estou tendo dificuldades com um erro no meu Gesior acc 2012 na Latest News segue código de erro Query: SELECT SQLSTATE: 42000 Driver code: 1064 Error message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 Query: SELECT `date` FROM `z_news_tickers` WHERE `hide_ticker` = '0' SQLSTATE: 00000 Driver code: Error message: Query: SELECT * FROM `z_news_tickers` WHERE hide_ticker != 1 ORDER BY date DESC LIMIT 5; SQLSTATE: 00000 Driver code: Error message: Query: SELECT `g`.`id` AS `id`, `g`.`name` AS `name`, COUNT(`g`.`name`) AS `frags` FROM `killers` k LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id` LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id` LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id` LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id` WHERE `g`.`id` > 0 AND `k`.`unjustified` = 1 AND `k`.`final_hit` = 1 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC LIMIT 4; SQLSTATE: 42S02 Driver code: 1146 Error message: Table 'global.killers' doesn't exist Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\pages\latestnews.php on line 237 Query: SELECT `players`.`name`, `z_forum`.`post_text`, `z_forum`.`post_topic`, `z_forum`.`icon_id`, `z_forum`.`post_smile`, `z_forum`.`id`, `z_forum`.`replies`, `z_forum`.`post_date` FROM `players`, `z_forum` WHERE `players`.`id` = `z_forum`.`author_guid` AND `z_forum`.`section` = 1 AND `z_forum`.`first_post` = `z_forum`.`id` ORDER BY `z_forum`.`last_post` DESC LIMIT 6 SQLSTATE: 00000 Driver code: Error message: VALENDO REP ><
Postado Janeiro 10, 2015 10 anos CREATE TABLE `killers` ( `id` INT NOT NULL AUTO_INCREMENT, `death_id` INT NOT NULL, `final_hit` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE, `unjustified` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE, PRIMARY KEY (`id`), FOREIGN KEY (`death_id`) REFERENCES `player_deaths`(`id`) ON DELETE CASCADE ) ENGINE = InnoDB;
Participe da conversa
Você pode postar agora e se cadastrar mais tarde. Se você tem uma conta, faça o login para postar com sua conta.