Link Manager 3.0 Support Thread

[MeltDown]

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

ALTER TABLE `links` CHANGE `links_status` `links_status` TINYINT( 1 ) NOT NULL DEFAULT '2';

I was able to successfully run the sql patch but am still receiving the error when I run the update_links_manager.sql.

Any suggestions?

Thanks again - Tim

[clydejones]

That did it, thanks. No more errors. I did however, checked that I uploaded all the files correctly, I even downloaded a complete new zip file, but still can't show the "send now button" or the pop up help button. Any other suggestions.

By the way, I want to thank you for your time helping me out.

Here's a list of files and locations associated with links manager:
admin/link_categories.php
admin/links.php
admin/links_contact.php
admin/includes/boxes/extra_boxes/links_extras_dhtml.php
admin/includes/extra_datafiles/links_manager.php
admin/includes/functions/extra_functions/links_manager.php
admin/includes/languages/english/links.php
admin/includes/languages/english/link_categories.php
admin/includes/languages/english/links_contact.php
admin/includes/languages/english/extra_definitions/links.php
-------
includes/extra_datafiles/links_manager.php
includes/functions/links.php
includes/languages/english/extra_definitions/links_manager_defines.php
includes/languages/english/extra_definitions/YOUR_TEMPLATE/links_manager_defines.php
includes/languages/english/YOUR_TEMPLATE/links.php
includes/languages/english/YOUR_TEMPLATE/links_submit.php
includes/languages/english/YOUR_TEMPLATE/popup_links_help.php
includes/languages/english/html_includes/define_links.php
includes/languages/english/html_includes/define_links_submit.php
includes/languages/english/html_includes/YOUR_TEMPLATE/define_links.php
includes/languages/english/html_includes/YOUR_TEMPLATE/define_links_submit.php
includes/modules/pages/links
includes/modules/pages/links_submit
includes/modules/pages/popup_links_help
includes/modules/pages/redirect_links
includes/modules/link_listing.php
includes/modules/YOUR_TEMPLATE/link_listing.php
includes/modules/sideboxes/YOUR_TEMPLATE/links_box.php
includes/templates/YOUR_TEMPLATE/sideboxes/tpl_links_select.php
includes/templates/YOUR_TEMPLATE/templates/tpl_links_default.php
includes/templates/YOUR_TEMPLATE/templates/tpl_links_submit_default.php
includes/templates/YOUR_TEMPLATE/popup_links_help
includes/templates/YOUR_TEMPLATE/css/links.css
includes/templates/YOUR_TEMPLATE/css/links_submit.css
includes/templates/YOUR_TEMPLATE/buttons/english/button_links_help.gif
includes/templates/YOUR_TEMPLATE/buttons/english/button_link_help.gif
includes/templates/YOUR_TEMPLATE/buttons/english/button_submit_link.gif

[clydejones]

I was able to successfully run the sql patch but am still receiving the error when I run the update_links_manager.sql.

Any suggestions?

Thanks again - Tim

Try running this:

ALTER TABLE `links` CHANGE `links_status` `links_status` TINYINT( 1 ) NOT NULL DEFAULT '1';
ALTER TABLE `links_to_link_categories` CHANGE `links_id` `links_id` INT( 11 ) NOT NULL AUTO_INCREMENT;

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', '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,'Only registered customers may submit a Link', 'REGISTERED_LINK', 'false', 'Only registered customers may submit a Link', @configuration_group_id, 18, 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', 25, 999, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');

[MeltDown]

Try running this:

Thanks Clyde - That did work. However, I liked the simplicity of the previous version as click counts etc. are not important to me. Really, besides the anticipation and excitement that accompanies upgrading my goal was to eliminate the re-directs. In the end of it I was able to do that and keep my preferred look by using the suggested work-around.

I went the long way around but did eventually get where I wanted to go!

Thanks again - Tim

[MeltDown]

OK, just to be as much of a pain as possible, ONE more question: The load time of my site is good. The load time of the links manager, specifically the category with the most links, is quite slow. It's not horribly important but is there anyway to positively affect that?

Thanks - Tim

[clydejones]

Thanks Clyde - That did work. However, I liked the simplicity of the previous version as click counts etc. are not important to me. Really, besides the anticipation and excitement that accompanies upgrading my goal was to eliminate the re-directs. In the end of it I was able to do that and keep my preferred look by using the suggested work-around.

I went the long way around but did eventually get where I wanted to go!

Thanks again - Tim

Tim,

That work-around is included in the updated version (no more re-directs)

[clydejones]

OK, just to be as much of a pain as possible, ONE more question: The load time of my site is good. The load time of the links manager, specifically the category with the most links, is quite slow. It's not horribly important but is there anyway to positively affect that?

Thanks - Tim

As a start - Optimize the images; You have a lot of rather large images (the biggest one I found was 40kb) and right now you're loading 20 images per page.

[oxicottin]

First I would like to thank you for making this module! Now to my problem. I go into my admin/extras and I have 3 links
1) BOX_LINKS
2) BOX_LINK_CATAGORIES
3) BOX_LINK_CONTACT

When I click to see what they are im getting a 404 error "Page not found"

Im confused on where in the admin is all the items I can insert links or whatever and what exactly does link manager do...

Thanks!

[oxicottin]

Sorry It wouldnt let me edit so I had to post again. I also cant find how I insert catigories or even where the catogories list is?

Thanks!

[clydejones]

First I would like to thank you for making this module! Now to my problem. I go into my admin/extras and I have 3 links
1) BOX_LINKS
2) BOX_LINK_CATAGORIES
3) BOX_LINK_CONTACT

When I click to see what they are im getting a 404 error "Page not found"

Im confused on where in the admin is all the items I can insert links or whatever and what exactly does link manager do...

Thanks!

Make sure you have ALL the following files located as indicated:

admin/links_contact.php
admin/links_categories.php
admin/links.php
admin/includes/boxes/extra_boxes/links_extra_dhtml.php
admin/includes/extra_datafiles/links_manager.php
admin/includes/functions/extra_functions/links_manager.php
admin/includes/languages/english/links_contact.php
admin/includes/languages/english/links_categories.php
admin/includes/languages/english/links.php
admin/includes/languages/english/extra_definitions/links.php