Link Manager 3.0 Support Thread

[Doodlebuckets]

Did you get any type of error message when you ran the install sql statement?

I don't recall. But I did uninstall and reinstall the sql and the same thing happens. I also uploaded all files again, including the fix you gave earlier.

[clydejones]

I don't recall. But I did uninstall and reinstall the sql and the same thing happens. I also uploaded all files again, including the fix you gave earlier.

try running this sql statement from admin -> tools -> install SQL patches

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

[Doodlebuckets]

[quote=clydejones;501851]try running this sql statement from admin -> tools -> install SQL patches

I get these errors and it is still blank in the admin config:

14 statements processed. ERROR: Cannot insert configuration_key "BOX_DISPLAY_VIEW_ALL_LINKS" because it already exists ERROR: Cannot insert configuration_key "PRODUCTS_OPTIONS_TYPE_SELECT" because it already exists ERROR: Cannot insert configuration_key "UPLOAD_PREFIX" because it already exists ERROR: Cannot insert configuration_key "TEXT_PREFIX" because it already exists ERROR: Cannot insert configuration_key "IH_VERSION" because it already exists Note: 5 statements ignored. See "upgrade_exceptions" table for additional details.

[clydejones]

[QUOTE=Doodlebuckets;501855]

try running this sql statement from admin -> tools -> install SQL patches

I get these errors and it is still blank in the admin config:

14 statements processed. ERROR: Cannot insert configuration_key "BOX_DISPLAY_VIEW_ALL_LINKS" because it already exists ERROR: Cannot insert configuration_key "PRODUCTS_OPTIONS_TYPE_SELECT" because it already exists ERROR: Cannot insert configuration_key "UPLOAD_PREFIX" because it already exists ERROR: Cannot insert configuration_key "TEXT_PREFIX" because it already exists ERROR: Cannot insert configuration_key "IH_VERSION" because it already exists Note: 5 statements ignored. See "upgrade_exceptions" table for additional details.

Looks like it processed all the links manager configuration options.

The other four were already in the configuration table and couldn't be inserted a second time.

See your PM

[Doodlebuckets]

I have fixed the install problems I was having with LM. I had a previous install of LM that I never completely uninstalled (I had forgotten about this and didn't realize that when I upgraded to 1.3.8a and imported my old database that I imported old versions of mods too). And I had to go through and delete all the old tables from the previous version and reinstall the sql for the new version. Now it works perfectly! I suggest for anyone having sql errors during install that you try the Upgrade of LM rather than New install ;)

[Doodlebuckets]

Can you tell me if there is supposed to be a way for link partners to upload images when they submit a link or are we supposed to upload pics from admin for each link partner?

Also, my click counts are not recording clicks. Is this supposed to be functioning now or perhaps in a future release?

[clydejones]

Can you tell me if there is supposed to be a way for link partners to upload images when they submit a link or are we supposed to upload pics from admin for each link partner?

Also, my click counts are not recording clicks. Is this supposed to be functioning now or perhaps in a future release?

You'll have to upload the images from admin. I'll work on something for a future release that will allow users to upload images.

The click count worked when Links Manager was using the "redirect" method but that was abandoned in favor of "direct links". again this is something to be worked on for a future release.

[dealbyethan.com]

I am going to move about 1000 links to this link manager module because it is integrated with Zencart. Is there an easy way to add/import all these links in bulk? If not, what about using phpmyadmin? I look at the table structures and it seems likely but I am not sure how to use it. Please advise. Thanks in advance.

[clydejones]

I am going to move about 1000 links to this link manager module because it is integrated with Zencart. Is there an easy way to add/import all these links in bulk? If not, what about using phpmyadmin? I look at the table structures and it seems likely but I am not sure how to use it. Please advise. Thanks in advance.

In order to get your current links into links manager you will have to use phpmyadmin.

First - You will have to export the links information from the original database tables.

Second - You'll need to structure that information so that it can be imported into the Links Manager tables.

Once both of these steps are completed you could construct an sql statement from the newly structured information that could be run to insert the links into Links Manager.

Hope this helps.

If you need additional assistance PM me.