Link Manager 3.0 Support Thread

[clydejones]

Clyde I am still getting the same error using the install sql.

What should I try next?

Dale

try running this one:

# Links Manager SQL Install
# For Zen-Cart 1.3.8
# Version: 3.5.1
# Updated: 9/7/2009
# 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''), ');
INSERT INTO `configuration` VALUES (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''), ');
INSERT INTO `configuration` VALUES (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''), ');
INSERT INTO `configuration` VALUES (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''), ');
INSERT INTO `configuration` VALUES (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''), ');
INSERT INTO `configuration` VALUES (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);
INSERT INTO `configuration` VALUES (NULL, 'Display Link Description', 'LINK_LIST_DESCRIPTION', '2', 'Do you want to display the Link Description?', @configuration_group_id, 8, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (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);
INSERT INTO `configuration` VALUES (NULL, 'Link Title Minimum Length', 'ENTRY_LINKS_TITLE_MIN_LENGTH', '2', 'Minimum length of link title.', @configuration_group_id, 10, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Link Title Maximum Length', 'ENTRY_LINKS_TITLE_MAX_LENGTH', '50', 'Maximum length of link title.', @configuration_group_id, 11, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Link URL Minimum Length', 'ENTRY_LINKS_URL_MIN_LENGTH', '10', 'Minimum length of link URL.', @configuration_group_id, 12, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Link Description Minimum Length', 'ENTRY_LINKS_DESCRIPTION_MIN_LENGTH', '10', 'Minimum length of link description.', @configuration_group_id, 13, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Link Description Maximum Length', 'ENTRY_LINKS_DESCRIPTION_MAX_LENGTH', '250', 'Maximum length of link description.', @configuration_group_id, 14, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (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);
INSERT INTO `configuration` VALUES (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);
INSERT INTO `configuration` VALUES (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);
INSERT INTO `configuration` VALUES (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);
INSERT INTO `configuration` VALUES (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);
INSERT INTO `configuration` VALUES (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''),');
INSERT INTO `configuration` VALUES (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);
INSERT INTO `configuration` VALUES (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);
INSERT INTO `configuration` VALUES (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);
INSERT INTO `configuration` VALUES (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);
INSERT INTO `configuration` VALUES (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''),');
INSERT INTO `configuration` VALUES (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);
INSERT INTO `configuration` VALUES (NULL, 'Image - Link Banner Image Width', 'LINK_IMAGE_WIDTH', '150', 'The pixel width of Link images', @configuration_group_id, 27, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Image - Link Banner Image Height', 'LINK_IMAGE_HEIGHT', '30', 'The pixel height of Link images', @configuration_group_id, 28, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Default Link Banner Image', 'DEFAULT_LINK_IMAGE', 'links_default.jpg', 'Set the Default Link Image', @configuration_group_id, 29, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (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''),');
INSERT INTO `configuration` VALUES (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',
  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, 2, 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 &amp; Add-Ons for Zen Cart&trade;');

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');

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', '');

[Firedkm]

Thank you Clyde that worked!

[Jeffey]

1.3.8a with all security patches
LM version 3.1

I was recently notified and confirmed that when trying to submit a link the page simply refreshes with no errors and no submission. Also noted that when viewing all links the link category descriptions show but clicking on those also just refreshes the page.

I've spent a couple of days searching the thread but I'm unable to determine what particular solutions would work for my situation though I've tried a couple. Also tried the upgrade to new version with a test site but that breaks a number of things including my CAPTCHA on the page so I would rather stick with 3.1 which worked for my purposes.

I have done almost nothing other then security patching in quite some time (no add-ons in year(s)) and the last successful link submission was 6/7/2009 so everything was working then and I can only assume that the security_patch_v138_20090619 has something to do with it but can't figure out what to do while maintaining the security that patch provides.

Thanks.

[clydejones]

1.3.8a with all security patches
LM version 3.1

I was recently notified and confirmed that when trying to submit a link the page simply refreshes with no errors and no submission. Also noted that when viewing all links the link category descriptions show but clicking on those also just refreshes the page.

I've spent a couple of days searching the thread but I'm unable to determine what particular solutions would work for my situation though I've tried a couple. Also tried the upgrade to new version with a test site but that breaks a number of things including my CAPTCHA on the page so I would rather stick with 3.1 which worked for my purposes.

I have done almost nothing other then security patching in quite some time (no add-ons in year(s)) and the last successful link submission was 6/7/2009 so everything was working then and I can only assume that the security_patch_v138_20090619 has something to do with it but can't figure out what to do while maintaining the security that patch provides.

Thanks.

link to your site would be useful

[Jeffey]

HI Clyde and thanks for the quick pickup.

Hard to explain but I have reasons (outside of Zen Community of course, and frankly you likely don't want to know) for not providing a link.

Hope that is not a deal breaker and happy to provide any additional information though I've already checked the error logs with no results. Plus now to top things off my host is screwed up so I'm having difficulty (Sloooooow) getting to the site(s).

I've seen references to the mentioned security patch causing problems though I'm not sure how it would play in my scenario given the edits there are Admin based.

Scrambling for anything to help track it down, I guess I do have something to add; checked Firefox's error console and receive a "check_form is not defined" error for SITE/index.php?main_page=links_submit

[Jeffey]

By the way, my contact form (with subject Mod) with CAPTCHA works fine so no interaction issue there.

Just throwing out as much as I can, may help narrow things down.

[clydejones]

HI Clyde and thanks for the quick pickup.

Hard to explain but I have reasons (outside of Zen Community of course, and frankly you likely don't want to know) for not providing a link.

Hope that is not a deal breaker and happy to provide any additional information though I've already checked the error logs with no results. Plus now to top things off my host is screwed up so I'm having difficulty (Sloooooow) getting to the site(s).

I've seen references to the mentioned security patch causing problems though I'm not sure how it would play in my scenario given the edits there are Admin based.

Scrambling for anything to help track it down, I guess I do have something to add; checked Firefox's error console and receive a "check_form is not defined" error for SITE/index.php?main_page=links_submit

v3.1 is well over 2 years old and I'm pretty positive that there is a fix posted somewhere in this thread ( I just don't remember where it would be )


My recommendation would be to upgrade to the latest version and use the links_captcha_fix posted in the thread

[Jeffey]

Sweet, seems like a good start. Form does come up with Captcha field.
(For others, a search in the thread for Captcha easily found the mentioned fix)

However upon submission, form does show:
The Link Description Must contain between 10 & ENTRY_LINKS_DESCRIPTION_MAX_LENGTH characters.

and also:
Must contain less than ENTRY_LINKS_TITLE_MAX_LENGTH characters.
when submitting with a fairly short title.

Can't seem to find where the definition is wrong and both maximums in Admin are set longer then those just entered, ran the SQL update.Finally name comes back with error requiring at least 2 letters but it is longer then that.When I tried to test/fix the other two errors above the form clears the name and putting it in again regardless of length brings the same error again.

[Jeffey]

Retesting viewing links. Clicking on view all links brings up category descriptions, clicking on one of them results in:
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 '-0, MAX_DISPLAY_LINKS' at line 1
in:
[select l.links_image_url, ld.links_title, ld.links_description, ld.links_title, l.links_clicked, l.links_id from links_description ld, links l, links_to_link_categories l2lc where l.links_status = '2' and l.links_id = l2lc.links_id and ld.links_id = l2lc.links_id and ld.language_id = '1' and l2lc.link_categories_id = '8'order by ld.links_title limit -0, MAX_DISPLAY_LINKS]

Page numbering of the page is wacked: -4 -3 -2 -1 0

[clydejones]

Sweet, seems like a good start. Form does come up with Captcha field.
(For others, a search in the thread for Captcha easily found the mentioned fix)

However upon submission, form does show:
The Link Description Must contain between 10 & ENTRY_LINKS_DESCRIPTION_MAX_LENGTH characters.

and also:
Must contain less than ENTRY_LINKS_TITLE_MAX_LENGTH characters.
when submitting with a fairly short title.

Can't seem to find where the definition is wrong and both maximums in Admin are set longer then those just entered, ran the SQL update.Finally name comes back with error requiring at least 2 letters but it is longer then that.When I tried to test/fix the other two errors above the form clears the name and putting it in again regardless of length brings the same error again.

look in admin -> configuration -> links manager

Link Title Minimum Length 2
Link Title Maximum Length 50