Excecute batch file error

Results 1 to 2 of 2
  1. #1
    Enthusiast Faib is offline
    MemberRank
    Jan 2009 Join Date
    25Posts

    Excecute batch file error

    When I try to excecute my batch file with navicat, I get this screen, but I don't think it should appear like this. should it?

    [Err] 1050 - Table 'accounts' already exists
    [Err] -- ----------------------------
    -- Table structure for accounts
    -- ----------------------------
    CREATE TABLE `accounts` (
    `id` int(11) NOT NULL auto_increment,
    `username` varchar(64) default NULL,
    `password` varchar(32) default NULL,
    `accesslevel` int(11) default '100',
    `lastip` varchar(15) default '0.0.0.0',
    `lasttime` int(11) default '0',
    `lastsvr` int(11) default '0',
    `lastchar` varchar(64) default NULL,
    `email` varchar(100) default NULL,
    `nb_donation` int(11) default '0',
    `donation` varchar(255) default '0',
    `active` int(11) default '1',
    `active_key` varchar(255) default NULL,
    `zulystorage` int(11) default '0',
    `platinum` tinyint(1) default '0',
    `online` tinyint(1) default '0',
    `login_count` int(11) default '0',
    `isSiteLogged` tinyint(1) default '0',
    PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=latin1;
    [Msg] Finished - Unsuccessfully
    --------------------------------------------------


  2. #2
    Account Upgraded | Title Enabled! perrin9028 is offline
    MemberRank
    Nov 2007 Join Date
    806Posts

    Re: Excecute batch file error

    That means you already have the table in the database. You could add DROP TABLE IF EXIST `accounts`; and it would work. Take in mind that you'll have to do that with all the pre-existing tables you want to replace. Or you could just delete all the tables there and then execute the SQL file.



Advertisement