Link Manager 3.0 Support Thread

I am not getting the links manager to show up in my Extras (admin). I have the Links Manager in my Configuration, but that's it.

Doodlebuckets:

I am not getting the links manager to show up in my Extras (admin). I have the Links Manager in my Configuration, but that's it.

Do you have "Admin Profiles" installed?

clydejones:

Do you have "Admin Profiles" installed?

Uh, not sure what that is, so probably no ;)

Doodlebuckets:

Uh, not sure what that is, so probably no ;)

That's a mod that allows you to assign different admin functions to different people.

try this and see if it helps.

just unzip the file and upload the entire admin folder to your server.

[Attachment no longer available]

clydejones:

That's a mod that allows you to assign different admin functions to different people.

try this and see if it helps.

just unzip the file and upload the entire admin folder to your server.

[Attachment no longer available]

That did it! Thanks :)

Doodlebuckets:

That did it! Thanks :)

OK.glad its working

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 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

I got LM working on my first site.  Now I am getting this same thing on my other site...see:  <http://www.doodlebuckets.com/store/index.php?main_page=links&lPath=1>

And my configuration in admin for LM comes up blank...none of the configurables show up and as far as I know, I've installed it exactly as I did the first site:  <http://www.giftsofcharacter.com/catalog/index.php?main_page=links&lPath=2>

Doodlebuckets:

....I got LM working on my first site. Now I am getting this same thing on my other site...see: http://www.doodlebuckets.com/store/i...=links&lPath=1

And my configuration in admin for LM comes up blank...none of the configurables show up and as far as I know, I've installed it exactly as I did the first site:

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

clydejones:

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.

Doodlebuckets:

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

[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.

[QUOTE=Doodlebuckets;501855]> clydejones:

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

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

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?

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?

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.

clydejones:

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.

OK, that's cool. I'll just turn the click count off for now. Do you need sponsors for these items or do you just need more hours in the day ? ;o)

Doodlebuckets:

OK, that's cool. I'll just turn the click count off for now. Do you need sponsors for these items or do you just need more hours in the day ? ;o)

More hours in the day would be nice.

clydejones:

More hours in the day would be nice.

Can't help ya there! But I did want to share that I have started a thread for people to find link partners. The idea is to submit one's link to everyone who posts their link directory and then post one's own directory for future posters to then know where to add their links. It's a bear trying to search through the zen showcase. Not every one is using this great mod! But for those that are, you can post your link directory here:

http://www.zen-cart.com/forum/showthread.php?t=87709

http://www.giftsofcharacter.com/catalog/index.php?main_page=links Check out my links page! It's looking great, I just LOVE this mod :) Can you tell me how to get the Gifts For Dad link to line up like it's supposed to and to get the text near the pic above it? Is it a change that I need to make in the links.css file and if so, what do I tinker with? Thanks!

Doodlebuckets:

http://www.giftsofcharacter.com/catalog/index.php?main_page=links Check out my links page! It's looking great, I just LOVE this mod :) Can you tell me how to get the Gifts For Dad link to line up like it's supposed to and to get the text near the pic above it? Is it a change that I need to make in the links.css file and if so, what do I tinker with? Thanks!

With just a quick look, it appears that the image for "gifts for Children" is NOT the same size (height) as the rest of the images.

That means that whatever follows that image is going to be bumped up a little and won't clear to the next line.

Make sure your images are all the same height and I think that should solve the problem.