• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[Website/php] Error On Website!

Sweddy

Well-Known Member
Joined
Feb 14, 2009
Messages
2,907
Reaction score
93
Location
Sweden
Error:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'z_forum.icon_id' in 'field list'' in D:\Program\Xampp\xampp\htdocs\latestnews.php:205 Stack trace: #0 D:\Program\Xampp\xampp\htdocs\latestnews.php(205): PDO->query('SELECT `z_forum ') #1 D:\Program\Xampp\xampp\htdocs\index.php(63): include('D:\Program\Xamp ') #2 {main} thrown in

In Line 205:

Lua:
$zapytanie = $SQL->query("SELECT `z_forum`.`icon_id`, `z_forum`.`post_topic`, `z_forum`.`author_guid`, `z_forum`.`post_date`, `z_forum`.`post_text`, `z_forum`.`id`, `z_forum`.`replies`, `players`.`name` FROM `z_forum`, `players` WHERE `section` = '1' AND `z_forum`.`id` = `first_post` AND `players`.`id` = `z_forum`.`author_guid` ORDER BY `post_date` DESC LIMIT 3;")->fetchAll();

Please Help!
 
PHP:
Unknown column 'z_forum.icon_id'
Add to database
PHP:
ALTER TABLE `z_forum` ADD `icon_id` int(3) NOT NULL DEFAULT '0';
 

Similar threads

Back
Top