fourm buged ;s

[moha zakii]

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

 

[SoloQ]

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

 

[moha zakii]

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 ?

 

[SoloQ]

Did you put it in the 'field list' area?
And what is the error now then?

 

[moha zakii]

put what i just maked the database name players_stars how i put the filed list on it ? or what?

 

[Ninja]

Missing the column stars.

 

[moha zakii]

Missing the column stars.

already known ;p

 

[Ninja]

Alter the table players in that case?

ALTER TABLE `players` ADD `stars` INT(11) NOT NULL DEFAULT '';

 

[moha zakii]

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

 

[Ninja]

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.

 

[moha zakii]

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.

lawl wait i will do it :*

- - - Updated - - -

hey how i add column to players table ?

 

[SoloQ]

Alter the table players in that case?

ALTER TABLE `players` ADD `stars` INT(11) NOT NULL DEFAULT '';

Feed this command in the sql database

 

[moha zakii]

Feed this command in the sql database

#1067 - Invalid default value for 'stars'

 

[Slave Ots]

bump