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]
