Problem with Talutaren's TFS

[Lantos]

Well everything is here. \/

05/08/2009 11:59:09] > MySQL ERROR mysql_real_query: SELECT `ip`, `mask`, `time` FROM `bans` WHERE `type` = 1; Unknown column 'ip' in 'field list'
[05/08/2009 11:59:09] > MySQL ERROR mysql_real_query: SELECT `id`, `password`, `type`, `premdays`, `lastday`, `key`, `warnings` FROM `accounts` WHERE `id` = xxxxxxxx LIMIT 1; Unknown column 'type' in 'field list'

If any1 have a solution, post it here, please.

 

[Nefs]

yes you dont have these columns, paste this in your database


ALTER TABLE `accounts` ADD `ip` BIGINT( 255 ) NOT NULL DEFAULT '0'

and

ALTER TABLE `accounts` ADD `type` BIGINT( 255 ) NOT NULL DEFAULT '0'

 

[Lantos]

Ok, 1 line solved.

But still having:

[05/08/2009 12:15:41] > MySQL ERROR mysql_real_query: SELECT `ip`, `mask`, `time` FROM `bans` WHERE `type` = 1; Unknown column 'ip' in 'field list'

When I used

ALTER TABLE `accounts` ADD `ip` BIGINT( 255 ) NOT NULL DEFAULT '0'

I got an error:

#1060 - Duplicate column name 'ip'

Any ideas?;x

 

[Nefs]

this error explain, you have "ip" in your database :/

 

[Lantos]

Well i've already found it out ;p. Still waiting for solution ;x

#Edit

ok, i fixed it. For everyone having that problem you have to use commands:

ALTER TABLE `accounts` ADD `type` BIGINT( 255 ) NOT NULL DEFAULT '0'

ALTER TABLE `bans` ADD `ip` BIGINT( 255 ) NOT NULL DEFAULT '0'

ALTER TABLE `bans` ADD `mask` BIGINT( 255 ) NOT NULL DEFAULT '0'

ALTER TABLE `bans` ADD `time` BIGINT( 255 ) NOT NULL DEFAULT '0'