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

Gesior Acc

Rivao

New Member
Joined
Mar 2, 2010
Messages
58
Reaction score
0
Dont create my new characters:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'' in C:\xampp\htdocs\pot\OTS_Player.php:187 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Player.php(187): PDO->query('INSERT INTO `pl...') #1 C:\xampp\htdocs\accountmanagement.php(952): OTS_Player->save() #2 C:\xampp\htdocs\index.php(135): include('C:\xampp\htdocs...') #3 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 187

Its like the php code dont change the id to create a new one.
 
I THINK I know what's wrong.
You have set more than one PRIMARY key in the table Players in your database :p
I think you may only have one primary key
 
You can't SET it. However a query (in gesior) is trying to do so. PRIMARY needs to be unique.
 
Back
Top