quantum:
Hello,
I have installed V3.3.1 of the links manager and have just tried to install the sql patch but get the following error:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; SELECT @configuration_group_id:=configuration_group_id FROM configuration_g' at line 1
>
> I am using ZenCart V1.3.7.
>
> I have gone through almost all the posts in this thread, and can see similar problems, but not the same one... Any help would be appreciated!
>
> Thanks
> Andrew
Try running this:
Just copy and paste into admin -> tools -> install SQL patches and click the send button.
Links Manager SQL Install
For Zen-Cart 1.3.7
Last Updated: 27/01/2007
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;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_LINKS_STATUS';
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;
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, 1, NULL, now(), NULL, 'zen_cfg_select_option(array(NULL, ''true'', ''false''), '), (NULL, 'Links Box - Display Submit Link', 'BOX_DISPLAY_SUBMIT_LINK', 'true', 'Display Submit Link on Sidebox', @configuration_group_id, 2, 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, 3, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (NULL, 'Enable Click Count', 'ENABLE_LINKS_COUNT', 'true', 'Enable links click count.', @configuration_group_id, 4, 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, 5, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (NULL, 'Display Link Title/Image', 'LINK_LIST_IMAGE', '1', 'Do you want to display the Link Title?', @configuration_group_id, 6, NULL, now(), NULL, NULL), (NULL, 'Display Link Description', 'LINK_LIST_DESCRIPTION', '2', 'Do you want to display the Link Description?', @configuration_group_id, 7, NULL, now(), NULL, NULL), (NULL, 'Display Link Click Count', 'LINK_LIST_COUNT', '3', 'Do you want to display the Link Click Count?', @configuration_group_id, 8, NULL, now(), NULL, NULL), (NULL, 'Link Title Minimum Length', 'ENTRY_LINKS_TITLE_MIN_LENGTH', '2', 'Minimum length of link title.', @configuration_group_id, 9, NULL, now(), NULL, NULL), (NULL, 'Link URL Minimum Length', 'ENTRY_LINKS_URL_MIN_LENGTH', '10', 'Minimum length of link URL.', @configuration_group_id, 10, NULL, now(), NULL, NULL), (NULL, 'Link Description Minimum Length', 'ENTRY_LINKS_DESCRIPTION_MIN_LENGTH', '10', 'Minimum length of link description.', @configuration_group_id, 11, 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, 12, 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, 13, 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, 14, NULL, now(), NULL, NULL), (NULL, 'Length of Link Categories Name', 'MAX_DISPLAY_LINK_NAME_LEN', '20', 'Used in links box; maximum length of link category name to display. Longer names will be truncated.', @configuration_group_id, 15, 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, 16, 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, 17, NULL, now(), NULL, NULL), (NULL, 'Image - Link Category Height', 'LINK_CATEGORY_IMAGE_HEIGHT', '80', 'The pixel width of Link Category images', @configuration_group_id, 18, NULL, now(), NULL, NULL), (NULL, 'Image - Link Category Width', 'LINK_CATEGORY_IMAGE_WIDTH', '80', 'The pixel width of Link Category images', @configuration_group_id, 19, NULL, now(), NULL, NULL), (NULL, 'Image - Link Image Width', 'LINK_IMAGE_WIDTH', '150', 'The pixel width of Link images', @configuration_group_id, 20, NULL, now(), NULL, NULL), (NULL, 'Image - Link Image Height', 'LINK_IMAGE_HEIGHT', '30', 'The pixel height of Link images', @configuration_group_id, 21, 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, 22, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'), (NULL, 'Link Category Image Directory', 'LINK_CATEGORY_IMAGE_DIRECTORY', 'link_category/', 'Set the Directory for the Category Image', @configuration_group_id, 23, NULL, 'now()', NULL, NULL);
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', 25, 999, 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/testsite', 'http://mysticmountainnaturals.com/testsite', '', 'Clyde Jones', '[email protected]', now(), 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's Test Site', 'Zen Cart™ concepts & modifications');
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');
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, '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', '');
