Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'z_forum.icon_id' in 'field list'' in \xampp\htdocs\latestnews.php:266 Stack trace: #0 \xampp\htdocs\latestnews.php(266): PDO->query('SELECT `z_forum...') #1 \xampp\htdocs\index.php(63): include('D:\xampp\htdocs...') #2 {main} thrown in \xampp\htdocs\latestnews.php on line 266

como arrumar galera... ajudem please!!

AGORA ESTA COM ESSE ERRO

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'z_forum.icon_id' in 'field list'' in \xampp\htdocs\latestnews.php:263 Stack trace: #0 \xampp\htdocs\latestnews.php(263): PDO->query('SELECT `z_forum...') #1 \xampp\htdocs\index.php(63): include('D:\xampp\htdocs...') #2 {main} thrown in \xampp\htdocs\latestnews.php on line 263

Execute isso em sua database:

CREATE TABLE `z_forum.icon_id` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`date` INT(11) NOT NULL ,
`text` TEXT NOT NULL
) ENGINE=MYISAM ;

Mano quando eu vou por isso..

CREATE TABLE `z_forum.icon_id` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`date` INT(11) NOT NULL ,
`text` TEXT NOT NULL
) ENGINE=MYISAM ;

Aparedce esse erro...

Comando SQL:

ALTER TABLE 'accounts' ADD COLUMN 'vipdays'INT NOT NULL

Mensagens do MySQL :

#1064 - 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 ''accounts' add column 'vipdays' INT NOT NULL' at line 1

Execute esse:

alter table `z_forum` add `icon_id` INT NOT NULL;  

Vlw mano deu certo

Tópico movido para a seção de dúvidas e pedidos resolvidos.