• 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!
  • 2026 staff recruitment is open! Check it out and consider applying!

fourm buged ;s

moha zakii

Owner Vinera
Joined
Feb 18, 2013
Messages
53
Reaction score
0
Location
egypto
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'players.stars' in 'field list'' in C:\xampp\htdocs\forum.php:210 Stack trace: #0 C:\xampp\htdocs\forum.php(210): PDO->query('SELECT `players...') #1 C:\xampp\htdocs\index.php(239): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\forum.php on line 210

please someone solve this problem to me ;s
 
It has not found the column : 'player.stars' in your database at 'field list'

Try adding it and then retry it. I think he other errors will disappear if you fix the first bug
 
i did player.stars on database and its still buged ..

$threads = $SQL->query("SELECT `players`.`name`, `players`.`group_id`, `players`.`stars`, `players`.`account_id`, `players`.`world_id`, `players`.`rank_id`, `players`.`vocation`, `players`.`promotion`, `players`.`level`, `z_forum`.`id`,`z_forum`.`first_post`, `z_forum`.`section`,`z_forum`.`post_text`, `z_forum`.`post_topic`, `z_forum`.`post_date`, `z_forum`.`post_smile`, `z_forum`.`author_aid`, `z_forum`.`author_guid`, `z_forum`.`last_edit_aid`, `z_forum`.`edit_date` FROM `players`, `z_forum` WHERE `players`.`id` = `z_forum`.`author_guid` AND `z_forum`.`first_post` = ".(int) $thread_id." ORDER BY `z_forum`.`post_date` LIMIT ".$posts_per_page." OFFSET ".($page * $posts_per_page))->fetchAll();
that line 210 which has the bug i dont know what to do if so u can give me the code to i can add it on my database ?
 
Alter the table players in that case?

SQL:
ALTER TABLE `players` ADD `stars` INT(11) NOT NULL DEFAULT '';
 
Last edited:
i just did on database this
CREATE TABLE IF NOT EXISTS `player_stars` (
`id` int(1) NOT NULL COMMENT '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

and its buged too so if u know the right code tell me im just noob on this :D
 
Execute the query above your post.

You're trying to add a new table called player_stars when all it needs is a new column in the players table called stars. :p
 
Back
Top