cancel
Showing results for 
Search instead for 
Did you mean: 

clearout MYSQL database (Nuke Evolution)

ESL
Grafter
Posts: 70
Registered: ‎05-08-2007

clearout MYSQL database (Nuke Evolution)

Hi All. MYSQL "newbie" here.
I am trying to install Nuke Evolution and I am getting a host of MY-SQL errors trying to run the installation script (see below). I have been running PHPBB and a coppermine gallery prior to attempting this install and wonder if it might be better to clear ot or reset my MYSQL database, but any tips would be helpful.
If I need to reset it, any pointers on how to do this, would be much appreciated.
Many Thanks.
Quote
There has been a MySQL error. MySQL Error Details:
1062: Duplicate entry '1' for key 1
INSERT INTO `nuke_banner_positions` VALUES (1, 0, 'Page Top');
There has been a MySQL error. MySQL Error Details:
1062: Duplicate entry '2' for key 1
INSERT INTO `nuke_banner_positions` VALUES (2, 1, 'Left Block');
There has been a MySQL error. MySQL Error Details:
1062: Duplicate entry '3' for key 1
INSERT INTO `nuke_banner_positions` VALUES (3, 2, 'Page Bottom');
There has been a MySQL error. MySQL Error Details:
1050: Table 'nuke_banner_terms' already exists
CREATE TABLE `nuke_banner_terms` ( `terms_body` text NOT NULL, `country` varchar(255) NOT NULL default '' ) TYPE=MyISAM;
There has been a MySQL error. MySQL Error Details:
1050: Table 'nuke_bbadvanced_username_color' already exists
CREATE TABLE `nuke_bbadvanced_username_color` ( `group_id` int(10) unsigned NOT NULL auto_increment, `group_name` varchar(255) NOT NULL default '', `group_color` varchar(6) NOT NULL default '', `group_weight` smallint(2) NOT NULL default '0', PRIMARY KEY (`group_id`) ) TYPE=MyISAM AUTO_INCREMENT=3 ;
There has been a MySQL error. MySQL Error Details:
1062: Duplicate entry '1' for key 1
INSERT INTO `nuke_bbadvanced_username_color` VALUES (1, 'Administrators', 'FFA34F', 1);
There has been a MySQL error. MySQL Error Details:
1062: Duplicate entry '2' for key 1
INSERT INTO `nuke_bbadvanced_username_color` VALUES (2, 'Moderators', '006600', 2);
There has been a MySQL error. MySQL Error Details:
1050: Table 'nuke_bbattach_quota' already exists
CREATE TABLE `nuke_bbattach_quota` ( `user_id` mediumint(8) unsigned NOT NULL default '0', `group_id` mediumint(8) unsigned NOT NULL default '0', `quota_type` smallint(2) NOT NULL default '0', `quota_limit_id` mediumint(8) unsigned NOT NULL default '0', KEY `quota_type` (`quota_type`) ) TYPE=MyISAM;
There has been a MySQL error. MySQL Error Details:
1050: Table 'nuke_bbattachments' already exists
CREATE TABLE `nuke_bbattachments` ( `attach_id` mediumint(8) unsigned NOT NULL default '0', `post_id` mediumint(8) unsigned NOT NULL default '0', `privmsgs_id` mediumint(8) unsigned NOT NULL default '0', `user_id_1` mediumint(8) NOT NULL default '0', `user_id_2` mediumint(8) NOT NULL default '0', KEY `attach_id_post_id` (`attach_id`,`post_id`), KEY `attach_id_privmsgs_id` (`attach_id`,`privmsgs_id`), KEY `post_id` (`post_id`), KEY `privmsgs_id` (`privmsgs_id`) ) TYPE=MyISAM;
There has been a MySQL error. MySQL Error Details:


This is just a sample, there is far too much to post here...
[Moderator's note by Barry Zubel: Changed code tags for quote tags so the forum doesn't stretch]
2 REPLIES 2
Peter_Vaughan
Community Veteran
Posts: 14,469
Registered: ‎30-07-2007

Re: clearout MYSQL database (Nuke Evolution)

Use the MySQL admin tool which you can find under tools on the Member Centre page. You can delete whole tables or clear then out very easily.
_lecro_
Grafter
Posts: 195
Registered: ‎30-07-2007

Re: clearout MYSQL database (Nuke Evolution)

If your still having problems with EVO drop by my site bud
www.lecro.plus.com ; Wink