Firedkm:
Clyde I went to install the links manager. When I run the install SQL i get an error.
1136 Column count doesn't match value count at row 1
in:
[INSERT INTO zen_links VALUES (1, 'http://mysticmountainnaturals.com/demotest', 'http://mysticmountainnaturals.com/demotest', 'links_image/testsite.jpg', 'Clyde Jones', 'clydejones##########################', now(), NULL, 2, 0, 0);]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
thank you
Dale
https://www.dalespuzzles.com
copy and paste the following sql statement in admin -> tools -> install sql patches and click the send button
# Links Manager SQL Install
# For Zen-Cart 1.3.8
# Version: 3.4.1
# Updated: 3/27/2008
# New configuration options are added to the zen_configuration table.
# run this sql patch using the Zen-Cart Sql Patches tool
# (admin -> tools -> install sql patches)
# For best results, cut-and-paste the code into the query field and press 'Send'.
SET @configuration_group_id=0;
SELECT (@configuration_group_id:=configuration_group_id)
FROM configuration_group
WHERE configuration_group_title= 'Links Manager'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id AND @configuration_group_id != 0;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_LINKS_STATUS';
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id AND @configuration_group_id != 0;
INSERT INTO configuration_group VALUES (NULL, 'Links Manager', 'Links Display Settings', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;
INSERT INTO `configuration` VALUES (NULL, 'Links Box - Display View All Links', 'BOX_DISPLAY_VIEW_ALL_LINKS', 'true', 'Display View All Links on Links Sidebox', @configuration_group_id, 2, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (NULL, 'Links Box - Display Submit Link', 'BOX_DISPLAY_SUBMIT_LINK', 'true', 'Display Submit Link on Sidebox', @configuration_group_id, 3, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (NULL, 'Display Description As Link', 'DISPLAY_LINK_DESCRIPTION_AS_LINK', 'false', 'Display the links description as a link', @configuration_group_id, 4, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (NULL, 'Enable Click Count', 'ENABLE_LINKS_COUNT', 'false', 'Enable links click count.', @configuration_group_id, 5, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (NULL, 'Submit Link - Require Reciprocal Page', 'SUBMIT_LINK_REQUIRE_RECIPROCAL', 'true', 'Require Reciprocal Page on Links Submit', @configuration_group_id, 6, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (NULL, 'Display Link Banner Image', 'LINK_LIST_IMAGE', '1', 'Do you want to display the Link Banner Image?', @configuration_group_id, 7, NULL, now(), NULL, NULL), (NULL, 'Display Link Description', 'LINK_LIST_DESCRIPTION', '2', 'Do you want to display the Link Description?', @configuration_group_id, 8, NULL, now(), NULL, NULL), (NULL, 'Display Link Click Count', 'LINK_LIST_COUNT', '0', 'Do you want to display the Link Click Count?', @configuration_group_id, 9, NULL, now(), NULL, NULL), (NULL, 'Link Title Minimum Length', 'ENTRY_LINKS_TITLE_MIN_LENGTH', '2', 'Minimum length of link title.', @configuration_group_id, 10, NULL, now(), NULL, NULL), (NULL, 'Link Title Maximum Length', 'ENTRY_LINKS_TITLE_MAX_LENGTH', '50', 'Maximum length of link title.', @configuration_group_id, 11, NULL, now(), NULL, NULL), (NULL, 'Link URL Minimum Length', 'ENTRY_LINKS_URL_MIN_LENGTH', '10', 'Minimum length of link URL.', @configuration_group_id, 12, NULL, now(), NULL, NULL), (NULL, 'Link Description Minimum Length', 'ENTRY_LINKS_DESCRIPTION_MIN_LENGTH', '10', 'Minimum length of link description.', @configuration_group_id, 13, NULL, now(), NULL, NULL), (NULL, 'Link Description Maximum Length', 'ENTRY_LINKS_DESCRIPTION_MAX_LENGTH', '250', 'Maximum length of link description.', @configuration_group_id, 14, NULL, now(), NULL, NULL), (NULL, 'Link Contact Name Minimum Length', 'ENTRY_LINKS_CONTACT_NAME_MIN_LENGTH', '2', 'Minimum length of link contact name.', @configuration_group_id, 15, NULL, now(), NULL, NULL), (NULL, 'Number Of Links to display on Links Page', 'MAX_DISPLAY_LINKS', '5', 'Set the number of Links to display on the Links page.', @configuration_group_id, 16, NULL, now(), NULL, NULL), (NULL, 'Links Check Phrase', 'LINKS_CHECK_PHRASE', 'yoursitename', 'Phrase to look for, when you perform a link check.', @configuration_group_id, 17, NULL, now(), NULL, NULL), (NULL, 'Links List - Scroll Box Size/Style', 'MAX_LINKS_LIST', '3', 'Number of link category names to be displayed in the scroll box window. Setting this to 1 or 0 will display a dropdown list', @configuration_group_id, 18, NULL, now(), NULL, NULL), (NULL, 'Length of Link Categories Name', 'MAX_DISPLAY_LINK_NAME_LEN', '17', 'Used in links box; maximum length of link category name to display. Longer names will be truncated.', @configuration_group_id, 19, NULL, now(), NULL, NULL), (NULL, 'Select Links Sort Order', 'DEFINE_SORT_ORDER', '1', 'Define the sort order of the links<br />1= Sort by Title<br />2= Sort by Date (Newest to Oldest)<br />3= Sort by number of clicks (highest to lowest)', @configuration_group_id, 20, NULL, now(), NULL, 'zen_cfg_select_option(array(''1'', ''2'', ''3''),'), (NULL, 'Number of Link Categories Per Row - Default is 3', 'MAX_LINK_CATEGORIES_ROW', '3', 'Used to display Link Categories per row.<br />Default is 3', @configuration_group_id, 21, NULL, now(), NULL, NULL), (NULL, 'Link Category Image Directory', 'LINK_CATEGORY_IMAGE_DIRECTORY', 'link_category/', 'Set the Directory for the Category Image', @configuration_group_id, 22, NULL, now(), NULL, NULL), (NULL, 'Image - Link Category Height', 'LINK_CATEGORY_IMAGE_HEIGHT', '80', 'The pixel width of Link Category images', @configuration_group_id, 23, NULL, now(), NULL, NULL), (NULL, 'Image - Link Category Width', 'LINK_CATEGORY_IMAGE_WIDTH', '80', 'The pixel width of Link Category images', @configuration_group_id, 24, NULL, now(), NULL, NULL), (NULL, 'Show Banner Image Field', 'SHOW_LINKS_BANNER_IMAGE', 'true', 'Show Banner Image Field', @configuration_group_id, 25, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'), (NULL, 'Link Banner Image Directory', 'LINK_IMAGE_DIRECTORY', 'links_image/', 'Set the Directory for the Link Image', @configuration_group_id, 26, NULL, now(), NULL, NULL), (NULL, 'Image - Link Banner Image Width', 'LINK_IMAGE_WIDTH', '150', 'The pixel width of Link images', @configuration_group_id, 27, NULL, now(), NULL, NULL), (NULL, 'Image - Link Banner Image Height', 'LINK_IMAGE_HEIGHT', '30', 'The pixel height of Link images', @configuration_group_id, 28, NULL, now(), NULL, NULL), (NULL, 'Default Link Banner Image', 'DEFAULT_LINK_IMAGE', 'links_default.jpg', 'Set the Default Link Image', @configuration_group_id, 29, NULL, now(), NULL, NULL), (NULL,'Only registered customers may submit a Link', 'REGISTERED_LINK', 'false', 'Only registered customers may submit a Link', @configuration_group_id, 30, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'), (NULL, 'Links - Show Store Name and Address', 'LINKS_STORE_NAME_ADDRESS', 'true', 'Include Store Name and Address', @configuration_group_id, 31, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (NULL, 'Define Links Status', 'DEFINE_LINKS_STATUS', '1', 'Enable the Defined Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', @configuration_group_id, 32, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');
INSERT INTO `configuration` VALUES (NULL, 'Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Image Handler Version', 'IH_VERSION', '2.0', 'This is used by image handler to check if the database is up to date with uploaded image handler files.', 0, 100, NULL, now(), NULL, 'zen_cfg_textarea_small(');
DROP TABLE IF EXISTS `links`;
CREATE TABLE links (
`links_id` int(11) NOT NULL auto_increment,
`links_url` varchar(255) default NULL,
`links_reciprocal_url` varchar(255) default NULL,
`links_image_url` varchar(255) default NULL,
`links_contact_name` varchar(64) default NULL,
`links_contact_email` varchar(96) default NULL,
`links_date_added` datetime NOT NULL default '0000-00-00 00:00:00',
`links_last_modified` datetime default NULL,
`links_status` tinyint(1) NOT NULL default '1',
`links_clicked` int(11) NOT NULL default '0',
`links_rating` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`links_id`),
KEY `idx_links_date_added` (`links_date_added`)
) TYPE=MyISAM ;
INSERT INTO `links` VALUES (1, 'http://mysticmountainnaturals.com/demotest', 'http://mysticmountainnaturals.com/demotest', 'links_image/testsite.jpg', 'Clyde Jones', 'clydejones##########################', now(), NULL, NULL, 2, 0, 0);
DROP TABLE IF EXISTS `links_description`;
CREATE TABLE `links_description` (
`links_id` int(11) NOT NULL auto_increment,
`language_id` int(11) NOT NULL default '1',
`links_title` varchar(64) NOT NULL default '',
`links_description` text,
PRIMARY KEY (`links_id`,`language_id`),
KEY `links_title` (`links_title`)
) ENGINE=MyISAM ;
INSERT INTO `links_description` VALUES (1, 1, 'Clyde Designs', 'Templates & Add-Ons for Zen Cart™');
DROP TABLE IF EXISTS `links_status`;
CREATE TABLE `links_status` (
`links_status_id` int(11) NOT NULL default '0',
`language_id` int(11) NOT NULL default '1',
`links_status_name` varchar(32) NOT NULL default '',
PRIMARY KEY (`links_status_id`,`language_id`),
KEY `idx_links_status_name` (`links_status_name`)
) ENGINE=MyISAM;
INSERT INTO `links_status` VALUES (1, 1, 'Pending');
INSERT INTO `links_status` VALUES (2, 1, 'Approved');
INSERT INTO `links_status` VALUES (3, 1, 'Disabled');
INSERT INTO `links_status` VALUES (1, 2, 'Pending');
INSERT INTO `links_status` VALUES (2, 2, 'Approved');
INSERT INTO `links_status` VALUES (3, 2, 'Disabled');
DROP TABLE IF EXISTS `links_to_link_categories`;
CREATE TABLE `links_to_link_categories` (
`links_id` int(11) NOT NULL auto_increment,
`link_categories_id` int(11) NOT NULL default '0',
PRIMARY KEY (`links_id`,`link_categories_id`)
) ENGINE=MyISAM;
INSERT INTO `links_to_link_categories` VALUES (1, 1);
DROP TABLE IF EXISTS `link_categories`;
CREATE TABLE `link_categories` (
`link_categories_id` int(11) NOT NULL auto_increment,
`link_categories_image` varchar(64) default NULL,
`link_categories_sort_order` int(3) default NULL,
`link_categories_date_added` datetime default NULL,
`link_categories_last_modified` datetime default NULL,
`link_categories_status` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`link_categories_id`),
KEY `idx_link_categories_date_added` (`link_categories_date_added`)
) ENGINE=MyISAM;
INSERT INTO `link_categories` VALUES (1, 'link_category/zencart.png', 1, now(), NULL, 1);
DROP TABLE IF EXISTS `link_categories_description`;
CREATE TABLE `link_categories_description` (
`link_categories_id` int(11) NOT NULL default '1',
`language_id` int(11) NOT NULL default '1',
`link_categories_name` varchar(40) NOT NULL default '',
`link_categories_description` text,
PRIMARY KEY (`link_categories_id`,`language_id`),
KEY `idx_link_categories_name` (`link_categories_name`)
) ENGINE=MyISAM;
INSERT INTO `link_categories_description` VALUES (1, 1, 'Zen-Cart Development', '');
