Bravo List - Torrent Strike fully modded sql problem

Bravo List (http://www.bvlist.com/index.php)

- Torrent Strike (http://www.bvlist.com/forumdisplay.php?f=21)

- - Torrent Strike fully modded sql problem (http://www.bvlist.com/showthread.php?t=1336)

dragontear

5th November 2008 03:08

Torrent Strike fully modded sql problem

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?:sos:

:ok:thank you for the help:ok:

johnake

5th November 2008 16:07

Run this sql query via phpmyadmin:

Code:

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	30th January 2009 15:48

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

any ideas?

marc234

30th January 2009 19:58

delete the table and run neu via phpmyadmin :-)

LoaT	30th January 2009 22:23

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

All times are GMT +2. The time now is 19:21.