Torrent Strike fully modded sql problem

[dragontear]

Hello I uploaded the site on a free web host for testing, I got it installed ok
when I tried to register and create the sysop account I got this error :

SQL Error

Table 'vaigan_tb.bans' doesn't exist

(vaigan_tb is the sql DB I made and named in admincp)

in my torrent site adress .com/include/bittorrent.php, line 203


can anyone help?


thank you for the help

[johnake]

Run this sql query via phpmyadmin:

CREATE TABLE `bans` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `addedby` int(10) unsigned NOT NULL default '0',
  `comment` varchar(255) NOT NULL default '',
  `first` int(11) default NULL,
  `last` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `first_last` (`first`,`last`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;

[LoaT]

i tried that one.. the sql said "#1050 - Table 'bans' already exists "

any ideas?

[marc234]

delete the table and run neu via phpmyadmin :-)

[LoaT]

and then what? i've done what johnake wrote, no changes?