need webdisner help!!

[coolgogo]

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'type' 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('1') #2 C:\xampp\htdocs\accountmanagement.php(30): OTS_Account->isBanned() #3 C:\xampp\htdocs\index.php(135): include('C:\xampp\htdocs...') #4 {main} thrown in C:\xampp\htdocs\pot\OTS_AccountBan.php on line 55
when I try to open the accountmanagement on website

 

[Ninja]

ALTER TABLE `bans` ADD `type` tinyint(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion';

This is not the best solution, I suggest that you use a Gesior version that is compatible with the TFS version you're using.

- - - Edited - - -

Changed the query.

 

[coolgogo]

don't work

 

[Ninja]

Sorry my mistake. Please try again, I edited the post.

 

[coolgogo]

same
don't work

 

[Amiroslo]

first try adding this, if it dont work do the next step

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

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

and change your acc managament
for this:

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

 

[coolgogo]

first try adding this, if it dont work do the next step

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

Other error

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'active' in 'field list'' in C:\xampp\htdocs\pot\OTS_Account.php:794 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(794): PDO->query('SELECT `active`...') #1 C:\xampp\htdocs\pot\OTS_Account.php(771): OTS_Account->loadBan() #2 C:\xampp\htdocs\accountmanagement.php(30): OTS_Account->isBanned() #3 C:\xampp\htdocs\index.php(135): include('C:\xampp\htdocs...') #4 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 794

 

[Amiroslo]

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

 

[coolgogo]

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

now other
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'expires' in 'field list'' in C:\xampp\htdocs\pot\OTS_Account.php:794 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(794): PDO->query('SELECT `active`...') #1 C:\xampp\htdocs\pot\OTS_Account.php(771): OTS_Account->loadBan() #2 C:\xampp\htdocs\accountmanagement.php(30): OTS_Account->isBanned() #3 C:\xampp\htdocs\index.php(135): include('C:\xampp\htdocs...') #4 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 794

- - - Updated - - -

I made the same the name UNSIGNED NOT NULL DEFAULT 0
but it didn't work on

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'value' in 'where clause'' in C:\xampp\htdocs\pot\OTS_Account.php:794 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(794): PDO->query('SELECT `active`...') #1 C:\xampp\htdocs\pot\OTS_Account.php(771): OTS_Account->loadBan() #2 C:\xampp\htdocs\accountmanagement.php(30): OTS_Account->isBanned() #3 C:\xampp\htdocs\index.php(135): include('C:\xampp\htdocs...') #4 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 794

 

[Amiroslo]

ALTER TABLE `bans` ADD `value` INT(255);

 

[coolgogo]

Thanks to amiroslo it worked thank you

 

[Ninja]

Drop the whole bans table, and execute this.

CREATE TABLE `bans`
(
    `id` INT UNSIGNED NOT NULL auto_increment,
    `type` TINYINT(1) NOT NULL COMMENT '1 - ip, 2 - player, 3 - account, 4 - notation',
    `value` INT UNSIGNED NOT NULL COMMENT 'ip - ip address, player - player_id, account - account_id, notation - account_id',
    `param` INT UNSIGNED NOT NULL COMMENT 'ip - mask, player - type (1 - report, 2 - lock, 3 - ban), account - player, notation - player',
    `active` TINYINT(1) NOT NULL DEFAULT TRUE,
    `expires` INT NOT NULL DEFAULT -1,
    `added` INT UNSIGNED NOT NULL,
    `admin_id` INT UNSIGNED NOT NULL DEFAULT 0,
    `comment` TEXT NOT NULL,
    PRIMARY KEY (`id`),
    KEY `type` (`type`, `value`),
    KEY `active` (`active`)
) ENGINE = InnoDB;

 

[Amiroslo]

Thanks to amiroslo it worked thank you

Glad I helped