Solved GESIOR ACC account error

[Xavicrak]

Gesior-AAC 0.6.2
when i intent log in web pag, with accounts appear this error:



Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'reason' in 'field list'' in C:\xampp\htdocs\pot\OTS_AccountBan.php:55 Stack trace: #0 C:\xampp\htdocs\pot\OTS_AccountBan.php(55): PDO->query('SELECT `id`, `t...') #1 C:\xampp\htdocs\pot\OTS_Account.php(935): OTS_AccountBan->find('1546325') #2 C:\xampp\htdocs\accountmanagement.php(32): OTS_Account->isBanned() #3 C:\xampp\htdocs\index.php(156): include('C:\xampp\htdocs...') #4 {main} thrown in C:\xampp\htdocs\pot\OTS_AccountBan.php on line 55

help please

 

[Suxex]

Same problem here...

 

[Cronox]

change your folder
Pot.. in c:/htdocs/pot..
for this.. download and change.
pot.rar - Speedy Share - upload your files here

 

[Xavicrak]

changed and now this:

Fatal error: Call to undefined method OTS_Account::getRecoveryKey() in C:\xampp\htdocs\accountmanagement.php on line 12

:S

 

[Cronox]

ok now change your acc managament
for this:

download acc managament.. and change
accountmanagement.php - Speedy Share - upload your files here

 

[Xavicrak]

its work
thank u very much

 

[Herpicus]

Instead of downloading a PHP file, go into your accountmanagement.php and remove reason from all queries?? HERP DERP

 

[Buddex]

Thank you Cronoxs

 

[Deletera28]

helped a lot with it cronoxs, thx and like for you, don't remove the downloads, can help a lot someone with the same error

 

[nilvagner]

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'reason' in 'field list'' in C:\xampp\htdocs\pot\OTS_AccountBan.php:55 Stack trace: #0 C:\xampp\htdocs\pot\OTS_AccountBan.php(55): PDO->query('SELECT `id`, `t...') #1 C:\xampp\htdocs\pot\OTS_Account.php(935): OTS_AccountBan->find('4680786') #2 C:\xampp\htdocs\characters.php(269): OTS_Account->isBanned() #3 C:\xampp\htdocs\indexs.php(113): include('C:\xampp\htdocs...') #4 {main} thrown in C:\xampp\htdocs\pot\OTS_AccountBan.php on line 55

 

[ahmed30]

alter table `bans` add `reason` INT UNSIGNED NOT NULL DEFAULT 0

 

[10victory10]

Man i'm your fan!

Very thanks ;x problem fixed!

For the guys that don't know how to solve this problem, look this code:

ALTER TABLE `bans` ADD `reason` INT UNSIGNED NOT NULL DEFAULT 0

execute this query on your Database (phpmyadmin) and all run perfect!