Welcome to the RaGEZONE - MMORPG development forums.

Excecute batch file error

This is a discussion on Excecute batch file error within the Rose Online forums, part of the MMO and MMORPG Developments category; When I try to excecute my batch file with navicat, I get this screen, but I don't think it should ...

Results 1 to 2 of 2
  1. #1
    Member
    Rank
    Member
    Join Date
    Jan 2009
    Posts
    25
    Liked
    0

    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
    トライアド
    Rank
    Member +
    Join Date
    Nov 2007
    Posts
    809
    Liked
    9

    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.

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •