Gesior AAC [AJUDA] Error latestnews.php

[franckle 4]

Alguem saberia resolver esses erros?

Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\config\config.php:1) in C:\xampp\htdocs\pages\latestnews.php on line1

Warning: Invalid argument supplied for foreach() inC:\xampp\htdocs\pages\latestnews.php on line 18

Warning: Invalid argument supplied for foreach() inC:\xampp\htdocs\pages\latestnews.php on line 286

 

Latestnews anexado

 

Obrigado e aguardo respostas.

latestnews.php

[Ivens Pontes 64]

vai em index e e troca:

define('DEBUG_DATABASE', false);

por 

define('DEBUG_DATABASE', true);

acesse latestnews e me mostre as consultas com erros

[franckle 4]

acessa ai o meu site para voce ver..

http://globx.ddns.net:8090/

ou se não quiser o erro é esse:

 

Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\config\config.php:1) in C:\xampp\htdocs\pages\latestnews.php on line1

Query:	SELECT `g`.`id` AS `id`, `g`.`name` AS `name`, COUNT(`g`.`name`) as `frags` FROM `players` p LEFT JOIN `player_deaths` pd ON `pd`.`killed_by` = `p`.`name` LEFT JOIN `guild_membership` gm ON `p`.`id` = `gm`.`player_id` LEFT JOIN `guilds` g ON `gm`.`guild_id` = `g`.`id` WHERE `g`.`id` > 0 AND `pd`.`unjustified` = 1 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC LIMIT 4;
SQLSTATE:	42S02
Driver code:	1146
Error message:	Table 'server.guild_membership' doesn't exist

Warning: Invalid argument supplied for foreach() inC:\xampp\htdocs\pages\latestnews.php on line 18

Query:	SELECT * FROM `z_news_tickers` WHERE hide_ticker != 1 ORDER BY date DESC LIMIT 50;
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT * FROM `announcements` WHERE id ORDER BY `date` DESC LIMIT 1
SQLSTATE:	42S02
Driver code:	1146
Error message:	Table 'server.announcements' doesn't exist

Warning: Invalid argument supplied for foreach() inC:\xampp\htdocs\pages\latestnews.php on line 286
 

Editado Outubro 11, 2016 por franckle (veja o histórico de edições)

[Ivens Pontes 64]

Table 'server.guild_membership' doesn't exist

Table 'server.announcements' doesn't exist

 

essas tabelas não existem no seu banco de dados, procure-as onde você pegou esse site.
o outro erro é na linha 1
retire o 

header("Content-Type: text/html; charset=ISO-8859-1",true);

provavelmente ja tem esse header() no config.php

[franckle 4]

Um erro sumiu kkk , agora falta os outros 2  , mesmo assim muito obrigado  +++REPPP

[KotZletY 1097]

29 minutos atrás, franckle disse:

Quais são exatamente esses dois erros que faltam ?

 

[franckle 4]

 

Warning: Invalid argument supplied for foreach() inC:\xampp\htdocs\pages\latestnews.php on line 18

Query:	SELECT * FROM `z_news_tickers` WHERE hide_ticker != 1 ORDER BY date DESC LIMIT 50;
SQLSTATE:	00000
Driver code:
Error message:

Query:	SELECT * FROM `announcements` WHERE id ORDER BY `date` DESC LIMIT 1
SQLSTATE:	00000
Driver code:
Error message:

 

 

ERROS ARRUMADOS.. Ivens arrumou todos .. mas obrigado mesmo assim pela atenção KotZletY

Editado Outubro 11, 2016 por franckle (veja o histórico de edições)

[Ivens Pontes 64]

CREATE TABLE IF NOT EXISTS `guild_membership` 
(
    `player_id` int(11) NOT NULL,
    `guild_id` int(11) NOT NULL,
    `rank_id` int(11) NOT NULL,
    `nick` varchar(15) NOT NULL DEFAULT '',
    PRIMARY KEY (`player_id`),
    KEY `guild_id` (`guild_id`),
    KEY `rank_id` (`rank_id`)) ENGINE=InnoDB

 

CREATE TABLE IF NOT EXISTS `announcements` (
  `id` int(10) NOT NULL auto_increment,
  `title` varchar(50) NOT NULL,
  `text` varchar(255) NOT NULL,
  `date` varchar(20) NOT NULL,
  `author` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

ALTER TABLE player_deaths ADD unjustified TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE

alter table `player_deaths` add `killed_by` INT NOT NULL;

 

[KotZletY 1097]

8 minutos atrás, franckle disse:

Já estava pegando as Query aqui, mais o amigo ae em cima já fez esse corre. 

Usa ae, e boa sorte! xD

 

[kleyner0 0]

Query: SELECT * FROM `newsticker` ORDER BY `date` DESC LIMIT 7; SQLSTATE: 00000 Driver code: Error message: Query: SELECT `players`.`name`, `z_forum`.`post_text`, `z_forum`.`post_topic`, `z_forum`.`icon_id`, `z_forum`.`news_icon`, `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`.`post_date` DESC LIMIT 6 SQLSTATE: 00000 Driver code: Error message: estou com o mesmo problema... sou iniciante de novo que nao lembro todo... parado 15 anos

Query: SELECT `value` FROM `server_config` WHERE `config` = 'double' SQLSTATE: 00000 Driver code: Error message:

Editado Maio 15, 2020 por kleyner0
Double (veja o histórico de edições)