News error

[pieter quak]

atal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1 no such table: server_motd' in C:\xampp\htdocs\latestnews.php:8 Stack trace: #0 C:\xampp\htdocs\latestnews.php(8): PDO->query('SELECT `players...') #1 C:\xampp\htdocs\index.php(70): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\latestnews.php on line 8


Whatt?!!? :O

this is what i get when i try to enter the site..

How do i fixx it? :O

 

[Denyy]

No table in data base "server_motd"

And what you got in latestnews.php on line 8 ??

 

[pieter quak]

how do i create the table?

$query = $SQL->query('SELECT `players`.`name`,`players`.`id`,`players`.`level`, `players`.`experience`, `server_motd`.`id`, `server_motd`.`text` FROM `players`,`server_motd` WHERE `players`.`group_id` < '.$config['site']['players_group_id_block'].' AND `players`.`name` != "Account Manager" ORDER BY `players`.`level` DESC, `players`.`experience` DESC, `server_motd`.`id` DESC LIMIT 1;')->fetch();


Thats line 8

 

[Zer0xe]

how do i create the table?

CREATE TABLE `server_motd`
(
	`id` INT UNSIGNED NOT NULL,
	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
	`text` TEXT NOT NULL,
	UNIQUE (`id`, `world_id`)
) ENGINE = InnoDB;

INSERT INTO `server_motd` VALUES (1, 0, 'Welcome to The Forgotten Server!');

Maybe?

 

[pieter quak]

I LOVE YOUUUU

aghahaha

Thanks man

 

[pieter quak]

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1 no such table: server_motd' in C:\xampp\htdocs\latestnews.php:8 Stack trace: #0 C:\xampp\htdocs\latestnews.php(8): PDO->query('SELECT `players...') #1 C:\xampp\htdocs\index.php(70): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\latestnews.php on line 8

This again

 

[Zer0xe]

Do you use MYSQL or SQLITE as a Database Type?
As Gesior only support MYSQL Database Type.

-Zer0xe