• 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!

Help me please !

Zakhran

Pace
Joined
May 7, 2012
Messages
252
Reaction score
6
Location
Detroit, Michigan
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 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 '' at line 1' in C:\xampp\htdocs\characters.php:352 Stack trace: #0 C:\xampp\htdocs\characters.php(352): PDO->query('SELECT `id`, `d...') #1 C:\xampp\htdocs\index2.php(134): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\characters.php on line 352

If i trying to search a character appear this ^

And i go to line 352:
$player_deaths = $SQL->query('SELECT `id`, `date`, `level` FROM `player_deaths` WHERE `player_id` = '.$player->getId().' ORDER BY `date` DESC LIMIT 0,'.$config['site']['limitDeath'].';');
 
CREATE TABLE `player_deaths` (

`player_id` INT UNSIGNED NOT NULL ,
`id` TINYINT( 2 ) UNSIGNED NOT NULL DEFAULT 0,
`date` LONGBLOB NOT NULL ,
UNIQUE (
`level` ,
`ip`
)
) ENGINE = INNODB;

player_deaths copy your existing table and save it to a folder on note pad

* or other cleared the table, and paste this. if it does not erase her again and again to put the last.
Not Tested, I hope it works for you.
 
Back
Top