Problem Geisor Creat Char

[cirbafe]

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'old_name' in 'where clause'' in C:\xampp\htdocs\pot\OTS_Player.php:145 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Player.php(145): PDO->query('SELECT `id` FRO...') #1 C:\xampp\htdocs\accountmanagement.php(728): OTS_Player->find('Teste') #2 C:\xampp\htdocs\index.php(130): include('C:\xampp\htdocs...') #3 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 145

When I click to create the account appears this error, I believe that there is the old table name, how do I add players to it?

 

[Shantyzz]

Same problem

 

[Feloth]

The column old_name does not exist in your players table.
Add it in your database, and it should work.

 

[Nikkster]

The column old_name does not exist in your players table.
Add it in your database, and it should work.

If you don't know how to do that, you can always re-import your database if you don't have any important characters in your db.

 

[Belthazor]

do this query on mysql database

add this
ALTER TABLE `players` ADD `old_name` bigint(255) NOT NULL DEFAULT '0';

 

[Cykotitan]

do this query on mysql database

add this
ALTER TABLE `players` ADD `old_name` bigint(255) NOT NULL DEFAULT '0';

`old_name` shouldn't be bigInteger
It should be VARCHAR, just like `name`

ALTER TABLE `players` ADD `old_name` VARCHAR(255) NOT NULL;