wishlist cannot install

[soso838]

the DB_PREFIX is zen_, I changed already. but as I mention about
, I can not actually update the wishlist.sql
I try to upload from Admin, it shows many errors

# WishList v0.8 SQL Load for MySQL databases
-- CREATE Wish list CONFIGURATION GROUP --
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM zen_configuration_group
WHERE configuration_group_title= 'Wish list';
DELETE FROM zen_configuration WHERE configuration_group_id = @t4;
DELETE FROM zen_configuration_group WHERE configuration_group_id = @t4;

INSERT INTO zen_configuration_group VALUES (NULL, 'Wish list', 'Settings for Wish list', '110', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM zen_configuration_group
WHERE configuration_group_title= 'Wish list';

INSERT INTO zen_configuration VALUES (NULL, 'Wishlist Module Switch', 'UN_DB_MODULE_WISHLISTS_ENABLED', 'true', 'Set this option true or false to enable or disable the wishlist', @t4, 710, now(), now(), NULL, "zen_cfg_select_option(array('true', 'false'),");
INSERT INTO zen_configuration VALUES (NULL, 'Wishlist sidebox header link', 'UN_DB_SIDEBOX_LINK_HEADER', 'true', 'Set this option true or false to make the sidebox header a link to the wishlist page.', @t4, 711, now(), now(), NULL, "zen_cfg_select_option(array('true', 'false'),");
INSERT INTO zen_configuration VALUES (NULL, 'Wishlist allow multiple lists', 'UN_DB_ALLOW_MULTIPLE_WISHLISTS', 'true', 'Set this option true or false to allow for more than 1 wishlist', @t4, 712, now(), now(), NULL, "zen_cfg_select_option(array('true', 'false'),");
INSERT INTO zen_configuration VALUES (NULL, 'Wishlist display category filter', 'UN_DB_DISPLAY_CATEGORY_FILTER', 'false', 'Set this option true or false to enable a category filter', @t4, 713, now(), now(), NULL, "zen_cfg_select_option(array('true', 'false'),");
INSERT INTO zen_configuration VALUES (NULL, 'Wishlist default name', 'DEFAULT_WISHLIST_NAME', 'Default', 'Enter the name you want to be assigned to the initial wishlist.', @t4, 714, now(), now(), NULL, NULL);
INSERT INTO zen_configuration VALUES (NULL, 'Wishlist show list after product addition', 'DISPLAY_WISHLIST', 'false', 'Set this option true or false to show the wishlist after a product was added to the wishlist', @t4, 715, now(), now(), NULL, "zen_cfg_select_option(array('true', 'false'),");
INSERT INTO zen_configuration VALUES (NULL, 'Wishlist display max items in extended view', 'UN_MAX_DISPLAY_EXTENDED', '10', 'Enter the maximum amount of products you want to show in extended view.<br />default = 10', @t4, 716, now(), now(), NULL, NULL);
INSERT INTO zen_configuration VALUES (NULL, 'Wishlist display max items in compact view', 'UN_MAX_DISPLAY_COMPACT', '20', 'Enter the maximum amount of products you want to show in extended view.<br />default = 20', @t4, 717, now(), now(), NULL, NULL);
INSERT INTO zen_configuration VALUES (NULL, 'Wishlist default view Switch', 'UN_DEFAULT_LIST_VIEW', 'extended', 'Set the default view of the list to compact or extended view', @t4, 718, now(), now(), NULL, "zen_cfg_select_option(array('compact', 'extended'),");
INSERT INTO zen_configuration VALUES (NULL, 'Wishlist allow multiple products to cart', 'UN_DB_ALLOW_MULTIPLE_PRODUCTS_CART_COMPACT', 'false', 'Set this option true or false to allow multiple products to be moved in the cart via checkboxes in compact view', @t4, 719, now(), now(), NULL, "zen_cfg_select_option(array('true', 'false'),");

# --------------------------------------------------------
#
# Table structure for table un_wishlists
#
# avoid data loss when reinstall (this will give a table exists error)
# if you want the table to be removed, then reinstalled; uncomment line below
#DROP TABLE IF EXISTS `zen_un_wishlists`;
CREATE TABLE IF NOT EXISTS `zen_un_wishlists` (
`id` int(11) NOT NULL auto_increment,
`customers_id` int(11) NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`name` varchar(255) default NULL,
`comment` varchar(255) default NULL,
`default_status` tinyint(1) NOT NULL default '0',
`public_status` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
INSERT INTO zen_un_wishlists VALUES (1, 0, now(), now(), 'donotuse', 'donotuse', 0, 0);

# --------------------------------------------------------
#
#April 2011 v0.8 added column
#added column for attributes, if you need to just add the column to an existing table use:
#alter table zen_un_products_to_wishlists add column attributes VARCHAR(255);
#in the sql patch tool in zen cart
#
# Table structure for table zen_un_products_to_wishlists
#

# avoid data loss when reinstall (this will give a table exists error)
# if you want the table to be removed, then reinstalled; uncomment line below
#DROP TABLE IF EXISTS `zen_un_products_to_wishlists`;
CREATE TABLE IF NOT EXISTS `zen_un_products_to_wishlists` (
`products_id` int(11) NOT NULL default '0',
`un_wishlists_id` int(11) NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`quantity` int(2) NOT NULL default '1',
`priority` int(1) NOT NULL default '2',
`comment` varchar(255) default NULL,
`attributes` varchar(255) default NULL,
PRIMARY KEY (`products_id`,`un_wishlists_id`)
) ENGINE=MyISAM;

[Wulf359]

With your code above I made one change and it installed flawlessly.... I removed the zen_

# WishList v0.8 SQL Load for MySQL databases
-- CREATE Wish list CONFIGURATION GROUP --
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Wish list';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

INSERT INTO configuration_group VALUES (NULL, 'Wish list', 'Settings for Wish list', '110', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Wish list';

INSERT INTO configuration VALUES (NULL, 'Wishlist Module Switch', 'UN_DB_MODULE_WISHLISTS_ENABLED', 'true', 'Set this option true or false to enable or disable the wishlist', @t4, 710, now(), now(), NULL, "cfg_select_option(array('true', 'false'),");
INSERT INTO configuration VALUES (NULL, 'Wishlist sidebox header link', 'UN_DB_SIDEBOX_LINK_HEADER', 'true', 'Set this option true or false to make the sidebox header a link to the wishlist page.', @t4, 711, now(), now(), NULL, "cfg_select_option(array('true', 'false'),");
INSERT INTO configuration VALUES (NULL, 'Wishlist allow multiple lists', 'UN_DB_ALLOW_MULTIPLE_WISHLISTS', 'true', 'Set this option true or false to allow for more than 1 wishlist', @t4, 712, now(), now(), NULL, "cfg_select_option(array('true', 'false'),");
INSERT INTO configuration VALUES (NULL, 'Wishlist display category filter', 'UN_DB_DISPLAY_CATEGORY_FILTER', 'false', 'Set this option true or false to enable a category filter', @t4, 713, now(), now(), NULL, "cfg_select_option(array('true', 'false'),");
INSERT INTO configuration VALUES (NULL, 'Wishlist default name', 'DEFAULT_WISHLIST_NAME', 'Default', 'Enter the name you want to be assigned to the initial wishlist.', @t4, 714, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Wishlist show list after product addition', 'DISPLAY_WISHLIST', 'false', 'Set this option true or false to show the wishlist after a product was added to the wishlist', @t4, 715, now(), now(), NULL, "cfg_select_option(array('true', 'false'),");
INSERT INTO configuration VALUES (NULL, 'Wishlist display max items in extended view', 'UN_MAX_DISPLAY_EXTENDED', '10', 'Enter the maximum amount of products you want to show in extended view.<br />default = 10', @t4, 716, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Wishlist display max items in compact view', 'UN_MAX_DISPLAY_COMPACT', '20', 'Enter the maximum amount of products you want to show in extended view.<br />default = 20', @t4, 717, now(), now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Wishlist default view Switch', 'UN_DEFAULT_LIST_VIEW', 'extended', 'Set the default view of the list to compact or extended view', @t4, 718, now(), now(), NULL, "cfg_select_option(array('compact', 'extended'),");
INSERT INTO configuration VALUES (NULL, 'Wishlist allow multiple products to cart', 'UN_DB_ALLOW_MULTIPLE_PRODUCTS_CART_COMPACT', 'false', 'Set this option true or false to allow multiple products to be moved in the cart via checkboxes in compact view', @t4, 719, now(), now(), NULL, "cfg_select_option(array('true', 'false'),");

# --------------------------------------------------------
#
# Table structure for table un_wishlists
#
# avoid data loss when reinstall (this will give a table exists error)
# if you want the table to be removed, then reinstalled; uncomment line below
#DROP TABLE IF EXISTS `un_wishlists`;
CREATE TABLE IF NOT EXISTS `un_wishlists` (
`id` int(11) NOT NULL auto_increment,
`customers_id` int(11) NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`name` varchar(255) default NULL,
`comment` varchar(255) default NULL,
`default_status` tinyint(1) NOT NULL default '0',
`public_status` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
INSERT INTO un_wishlists VALUES (1, 0, now(), now(), 'donotuse', 'donotuse', 0, 0);

# --------------------------------------------------------
#
#April 2011 v0.8 added column
#added column for attributes, if you need to just add the column to an existing table use:
#alter table un_products_to_wishlists add column attributes VARCHAR(255);
#in the sql patch tool in zen cart
#
# Table structure for table un_products_to_wishlists
#

# avoid data loss when reinstall (this will give a table exists error)
# if you want the table to be removed, then reinstalled; uncomment line below
#DROP TABLE IF EXISTS `un_products_to_wishlists`;
CREATE TABLE IF NOT EXISTS `un_products_to_wishlists` (
`products_id` int(11) NOT NULL default '0',
`un_wishlists_id` int(11) NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`quantity` int(2) NOT NULL default '1',
`priority` int(1) NOT NULL default '2',
`comment` varchar(255) default NULL,
`attributes` varchar(255) default NULL,
PRIMARY KEY (`products_id`,`un_wishlists_id`)
) ENGINE=MyISAM;