Link Manager 3.0 Support Thread

Printable View

Show 100 post(s) from this thread on one page

3 Jan 2008, 02:20 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by Veronika7747

I am just starting with this mod today.. and have couple (well more than couple) of questions:

A. When I open link submit page, I get this:
ENTRY_LINKS_IMAGE ENTRY_LINKS_IMAGE_TEXT

B. Where can I make the input boxes wider?

C. When I click submit, it gives me back the submit link page. Should it bring me to a page saying something like - Your request have been submitted??

D. The email that person submitting request receives, states this text twice:

HTML Code:

Welcome to The Fine Art of Clive Kay link exchange program. Your link has been successfully submitted at The Fine Art of Clive Kay. It will be added to our listing as soon as we approve it. You will receive an email about the status of your submittal. If you have not received it within the next 48 hours, please contact us before submitting your link again.

E. Where can I change the blue background on input fields to the same colour as "Your Contact Information" (or some other than bue colour)?
(BTW I don't have form.png in includes/templates/YOUR/images folder)

F. When I try admin/extra/links check link, I get the messages that it was found and it gives the address. it would be nice:smile: if one could click on that address to get to the site to see if the reciprocal link is there.

Great add on! I hope it will eliminate tons of "fake" requests (site will be using CAPTCHA).

Thanks

URL for your site?
3 Jan 2008, 02:54 AM
Veronika7747

Re: Link Manager 3.0 release

Quote:

Originally Posted by clydejones

URL for your site?

I am still it the development stage, but I will try to upload online what ever I have up to now sometimes overnight and I will post the link.
Thanks
3 Jan 2008, 03:06 AM
clydejones

Re: Link Manager 3.0 release

Quote:

A. When I open link submit page, I get this:
ENTRY_LINKS_IMAGE ENTRY_LINKS_IMAGE_TEXT

Where exactly are you seeing this?
3 Jan 2008, 03:12 AM
clydejones

Re: Link Manager 3.0 release

Quote:

E. Where can I change the blue background on input fields to the same colour as "Your Contact Information" (or some other than bue colour)?
(BTW I don't have form.png in includes/templates/YOUR/images folder)

This should take care of this issue:

Just unzip the file and upload the links_submit.css to

includes/templates/YOUR_TEMPLATE/css

Attachment 3147
3 Jan 2008, 03:34 AM
Veronika7747

Re: Link Manager 3.0 release

Quote:

Originally Posted by clydejones

Where exactly are you seeing this?

I'll attempt to include print screen...
that does not work, not I cannot insert file either....
3 Jan 2008, 04:39 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by Veronika7747

I'll attempt to include print screen...
that does not work, not I cannot insert file either....

If you are using captcha you will need to do a file compare of the links submit files since the ones that are included with the captcha mod are older than the files in links manager.
3 Jan 2008, 05:06 AM
Veronika7747

Re: Link Manager 3.0 release

Quote:

Originally Posted by clydejones

If you are using captcha you will need to do a file compare of the links submit files since the ones that are included with the captcha mod are older than the files in links manager.

I did and hopefully did "O.K." in my mix & match. I am uploading the site now. It will be at: http://store.clivekay-artist.com soon I hope.

P.S. thanks for css (as was reading all the old posts, so that's why I referred to
form.png..)
3 Jan 2008, 05:38 AM
Veronika7747

Re: Link Manager 3.0 release

Quote:

Originally Posted by Veronika7747

I did and hopefully did "O.K." in my mix & match. I am uploading the site now. It will be at: http://store.clivekay-artist.com soon I hope.

P.S. thanks for css (as was reading all the old posts, so that's why I referred to
form.png..)

O.K., now that the test site is up, I have yet another question.... I have couple of pages of "old links" (one page currently shows as the last line "Arts Links" on RHS box under "More on Clive Kay" and I would like to include this link inside the "Link Manager" box with bit of space under the last line there "Submit Links". Is that possible?? I was trying to do it the same way as I did it in "More Info" box, but that did not work..

Also should I be able to put a subcategory in the link category??

Thanks for your time.
3 Jan 2008, 05:43 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by Veronika7747

I did and hopefully did "O.K." in my mix & match. I am uploading the site now. It will be at: http://store.clivekay-artist.com soon I hope.

P.S. thanks for css (as was reading all the old posts, so that's why I referred to
form.png..)

Quote:

A. When I open link submit page, I get this:
ENTRY_LINKS_IMAGE ENTRY_LINKS_IMAGE_TEXT

To correct this, open includes/templates/YOUR_TEMPLATE/templates/tpl_links_submit_default.php

find and delete the following section of code. (as I pointed out, this file in the captcha mod is older than the file in links manager.

Code:

<label class="inputLabel" for="links_image"><?php echo ENTRY_LINKS_IMAGE; ?></label> <?php echo zen_draw_input_field('links_image', 'http://') . ' ' . (zen_not_null(ENTRY_LINKS_IMAGE_TEXT) ? '<span class="alert">' . ENTRY_LINKS_IMAGE_TEXT . '</span>': ''); ?><?php echo '<a href="javascript:popupWindow(\'' . zen_href_link(FILENAME_POPUP_LINKS_HELP) . '\')">' . TEXT_LINKS_HELP_LINK . '</a>'; ?>

after making the edit save the file and upload to your server.
3 Jan 2008, 06:09 AM
Veronika7747

Re: Link Manager 3.0 release

Quote:

Originally Posted by clydejones

To correct this, open includes/templates/YOUR_TEMPLATE/templates/tpl_links_submit_default.php

find and delete the following section of code. (as I pointed out, this file in the captcha mod is older than the file in links manager.

Code:

<label class="inputLabel" for="links_image"><?php echo ENTRY_LINKS_IMAGE; ?></label> <?php echo zen_draw_input_field('links_image', 'http://') . ' ' . (zen_not_null(ENTRY_LINKS_IMAGE_TEXT) ? '<span class="alert">' . ENTRY_LINKS_IMAGE_TEXT . '</span>': ''); ?><?php echo '<a href="javascript:popupWindow(\'' . zen_href_link(FILENAME_POPUP_LINKS_HELP) . '\')">' . TEXT_LINKS_HELP_LINK . '</a>'; ?>

after making the edit save the file and upload to your server.

Thank you!:clap:
3 Jan 2008, 06:30 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by Veronika7747

Thank you!:clap:

Quote:

C. When I click submit, it gives me back the submit link page. Should it bring me to a page saying something like - Your request have been submitted??

Try this fix and see if it corrects this issue:

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

Attachment 3148
3 Jan 2008, 07:07 AM
Veronika7747

Re: Link Manager 3.0 release

Quote:

Originally Posted by clydejones

Try this fix and see if it corrects this issue:

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

Attachment 3148

Oh Clyde you are good! You are chopping down my questions really fast! Thanks again.
5 Jan 2008, 02:50 AM
Veronika7747

Re: Link Manager 3.0 release

Clyde, in which file can I increase the form field properties of the texboxes on the submit link page??
Tx
5 Jan 2008, 03:39 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by Veronika7747

Clyde, in which file can I increase the form field properties of the texboxes on the submit link page??
Tx

includes/templates/YOUR_TEMPLATE/templates/tpl_links_submit_default.php
5 Jan 2008, 11:45 PM
Veronika7747

Re: Link Manager 3.0 release

Quote:

Originally Posted by clydejones

includes/templates/YOUR_TEMPLATE/templates/tpl_links_submit_default.php

Thanks Clyde, I got it changed but I am having trouble with 2 fields which now don't show http://

Code:

<?php echo zen_draw_input_field('links_reciprocal_url', $name, ' size="40" id="links_reciprocal_url"', 'http://') . ' ' . (zen_not_null(ENTRY_LINKS_RECIPROCAL_URL_TEXT) ? '<span class="alert">' . ENTRY_LINKS_RECIPROCAL_URL_TEXT . '</span>': ''); ?>

what am I doing wrong here??

Veronika
6 Jan 2008, 01:08 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by Veronika7747

Thanks Clyde, I got it changed but I am having trouble with 2 fields which now don't show http://

Code:

<?php echo zen_draw_input_field('links_reciprocal_url', $name, ' size="40" id="links_reciprocal_url"', 'http://') . ' ' . (zen_not_null(ENTRY_LINKS_RECIPROCAL_URL_TEXT) ? '<span class="alert">' . ENTRY_LINKS_RECIPROCAL_URL_TEXT . '</span>': ''); ?>

what am I doing wrong here??

Veronika

Use these:

PHP Code:

<?php echo zen_draw_input_field('links_reciprocal_url', 'http://', 'size="40" id="links_reciprocal_url"') . ' ' . (zen_not_null(ENTRY_LINKS_RECIPROCAL_URL_TEXT) ? '<span class="alert">' . ENTRY_LINKS_RECIPROCAL_URL_TEXT . '</span>': ''); ?>

PHP Code:

<?php echo zen_draw_input_field('links_url', 'http://', 'size="40" id="links_url"') . ' ' . (zen_not_null(ENTRY_LINKS_URL_TEXT) ? '<span class="alert">' . ENTRY_LINKS_URL_TEXT . '</span>': ''); ?>
10 Jan 2008, 12:13 AM
felit0

Re: Link Manager 3.0 release

Clyde,

Just installed your module a few days ago. I having a problem where headings and buttons are coming up as such (ex: TABLE_HEADING_LINKS_TITLE). You can see the live site at http://just4electronics.com, click on "Link Exchange" on the right column to see module. Any help would be appreciated.

*Edit* In addition, I could not locate or turn on the sidebox for your module from Tools>Layout Boxes Controller. It just doesn't appear there at all.

Regards,

Rafael
10 Jan 2008, 12:21 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by felit0

Clyde,

Just installed your module a few days ago. I having a problem where headings and buttons are coming up as such (ex: TABLE_HEADING_LINKS_TITLE). You can see the live site at http://just4electronics.com, click on "Link Exchange" on the right column to see module. Any help would be appreciated.

*Edit* In addition, I could not locate or turn on the sidebox for your module from Tools>Layout Boxes Controller. It just doesn't appear there at all.

Regards,

Rafael

Looks like you didn't upload the language files and/or change all the YOUR_TEMPLATE folders to match your custom template name.
10 Jan 2008, 01:20 AM
felit0

Re: Link Manager 3.0 release

Thank you very much for the lightning quick response! It was the YOUR_TEMPLATE folders. I didn't realize there was multiple ones, I only changed /includes/templates/YOUR_TEMPLATE initially. You might want to stress that point in your install.txt file. Working flawlessly now :)

Many Thanks!!

Rafael
10 Jan 2008, 01:27 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by felit0

Thank you very much for the lightning quick response! It was the YOUR_TEMPLATE folders. I didn't realize there was multiple ones, I only changed /includes/templates/YOUR_TEMPLATE initially. You might want to stress that point in your install.txt file. Working flawlessly now :)

Many Thanks!!

Rafael

Glad to help.
11 Jan 2008, 08:59 PM
jeking

Re: Link Manager 3.0 release

Clyde,

You have a nice mod and I can see very active support too! It appears the links are only available by clicking the category. Is there a way spiders can get to the link category pages that I'm not seeing?
12 Jan 2008, 02:20 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by jeking

Clyde,

You have a nice mod and I can see very active support too! It appears the links are only available by clicking the category. Is there a way spiders can get to the link category pages that I'm not seeing?

If they "follow" the the category links then they should pick up the links on those pages.
12 Jan 2008, 04:55 AM
jeking

Re: Link Manager 3.0 release

Quote:

Originally Posted by clydejones

If they "follow" the the category links then they should pick up the links on those pages.

But the spiders can't click on the category to get to the category page. Is there any other way to get to their besides clicking?
12 Jan 2008, 05:19 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by jeking

But the spiders can't click on the category to get to the category page. Is there any other way to get to their besides clicking?

From my understanding, spiders don't need to "click". If they find an "a href" link they are smart enough to "follow" the link without "clicking"
12 Jan 2008, 06:13 AM
jeking

Re: Link Manager 3.0 release

Quote:

Originally Posted by clydejones

From my understanding, spiders don't need to "click". If they find an "a href" link they are smart enough to "follow" the link without "clicking"

On that point you are correct. But the sidebox categories are not 'a href', they are a form. My source code shows:

<form name="links" action="http://customcreationsunltd.com/shop/index.php?main_page=links" method="get"><select name="lPath" onchange="this.form.submit();" size="3" style="width: 100%">
<option value="4">Associations</option>
<option value="3">Parenting</option>
<option value="2">Shopping</option>
<option value="5">Travel</option>
</select>

Spiders can't fill out a form. I really like your contribution and need a way to automate a links page, but if the spiders can't find the links to folllow, it kind of defeats much of the purpose. I'd like to be wrong or find another way for this to work.
12 Jan 2008, 07:59 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by jeking

On that point you are correct. But the sidebox categories are not 'a href', they are a form. My source code shows:

<form name="links" action="http://customcreationsunltd.com/shop/index.php?main_page=links" method="get"><select name="lPath" onchange="this.form.submit();" size="3" style="width: 100%">
<option value="4">Associations</option>
<option value="3">Parenting</option>
<option value="2">Shopping</option>
<option value="5">Travel</option>
</select>

Spiders can't fill out a form. I really like your contribution and need a way to automate a links page, but if the spiders can't find the links to folllow, it kind of defeats much of the purpose. I'd like to be wrong or find another way for this to work.

There is also a "a href=" link on the sidebox "view all links" takes you to the links page which lists all the categories which in turn link to the page(s) which contain the links for those categories. I would assume that a spider could follow those links.
12 Jan 2008, 06:03 PM
jeking

Re: Link Manager 3.0 release

Quote:

Originally Posted by clydejones

There is also a "a href=" link on the sidebox "view all links" takes you to the links page which lists all the categories which in turn link to the page(s) which contain the links for those categories. I would assume that a spider could follow those links.

I didn't really notice that one. Yes, that one would allow it to happen

Thanks!
16 Jan 2008, 07:30 PM
highstyleinc

Re: Link Manager 3.0 release

Where o where can I find the download for links manager? I have been to the downloads section and have been through pages upon pages of threads.

TIA
16 Jan 2008, 07:42 PM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by highstyleinc

Where o where can I find the download for links manager? I have been to the downloads section and have been through pages upon pages of threads.

TIA

HERE in the downloads section
16 Jan 2008, 07:43 PM
highstyleinc

Re: Link Manager 3.0 release

Ah, yeah, I just realized this was for sideboxes which explains why I couldn't find it before. Will this help for the links in other areas of the page, such as header?
16 Jan 2008, 08:09 PM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by highstyleinc

Ah, yeah, I just realized this was for sideboxes which explains why I couldn't find it before. Will this help for the links in other areas of the page, such as header?

No. this mod is designed to exchange links with other sites.
19 Jan 2008, 12:16 AM
wsmith48

Re: Link Manager 3.0 release

I was trying to install the links manager today and I got this error --

Parse error: syntax error, unexpected $end in C:\apache2triad\htdocs\138\admin\includes\boxes\extra_boxes\links_extras_dhtml.p hp on line 9

this is a great addon and I would like to get it up and running if you could give me the low down on the error - nothing loads below the menu of admin with the error........

thanks
19 Jan 2008, 12:27 AM
wsmith48

Re: Link Manager 3.0 release

Quote:

Originally Posted by wsmith48

I was trying to install the links manager today and I got this error --

Parse error: syntax error, unexpected $end in C:\apache2triad\htdocs\138\admin\includes\boxes\extra_boxes\links_extras_dhtml.p hp on line 9

this is a great addon and I would like to get it up and running if you could give me the low down on the error - nothing loads below the menu of admin with the error........

thanks

additional info - line 9 is the ?> shabang

<?php
if (!defined('IS_ADMIN_FLAG')) {
die('Illegal Access');

$za_contents[] = array('text' => BOX_LINKS, 'link' => zen_href_link(FILENAME_LINKS, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_LINK_CATEGORIES, 'link' => zen_href_link(FILENAME_LINK_CATEGORIES, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_LINKS_CONTACT, 'link' => zen_href_link(FILENAME_LINKS_CONTACT, '', 'NONSSL'));
?>
19 Jan 2008, 12:53 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by wsmith48

additional info - line 9 is the ?> shabang

<?php
if (!defined('IS_ADMIN_FLAG')) {
die('Illegal Access');

$za_contents[] = array('text' => BOX_LINKS, 'link' => zen_href_link(FILENAME_LINKS, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_LINK_CATEGORIES, 'link' => zen_href_link(FILENAME_LINK_CATEGORIES, '', 'NONSSL'));
$za_contents[] = array('text' => BOX_LINKS_CONTACT, 'link' => zen_href_link(FILENAME_LINKS_CONTACT, '', 'NONSSL'));
?>

try this,

Just unzip the file and upload the entire admin folder to your server

Attachment 3284
19 Jan 2008, 01:25 AM
wsmith48

Re: Link Manager 3.0 release

tried it, but it didn't do the trick... still gave me the error

Parse error: syntax error, unexpected $end in C:\apache2triad\htdocs\138\admin\includes\boxes\extra_boxes\links_extras_dhtml.p hp on line 17
19 Jan 2008, 01:56 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by wsmith48

tried it, but it didn't do the trick... still gave me the error

Parse error: syntax error, unexpected $end in C:\apache2triad\htdocs\138\admin\includes\boxes\extra_boxes\links_extras_dhtml.p hp on line 17

Did you download the latest version 3.3.1 from the downloads section?

1. uninstall everything (see the included uninstall.txt)

What happens now?
19 Jan 2008, 02:09 AM
wsmith48

Re: Link Manager 3.0 release

3.3.1 is the version I downloaded - I've installed it on my development platform which is XP professional running Apache2triad server - the enviroment replicates the linux environment pretty good -
difference being, my live site is on linux, php4 and this one is on windows, php5 - would that make a difference??

I usually try everthing on my development platform first before going live with it and have found that sometimes there is a difference between the 2 platforms.
19 Jan 2008, 02:25 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by wsmith48

3.3.1 is the version I downloaded - I've installed it on my development platform which is XP professional running Apache2triad server - the enviroment replicates the linux environment pretty good -
difference being, my live site is on linux, php4 and this one is on windows, php5 - would that make a difference??

I usually try everthing on my development platform first before going live with it and have found that sometimes there is a difference between the 2 platforms.

Try this and see what happens.

Attachment 3286

I use XAMPP on windows XP php5 with no problem.
19 Jan 2008, 02:36 AM
wsmith48

Re: Link Manager 3.0 release

that appears to be the right fix, it works great now, I'll swap a link with you when I get it on the live site http://www.wlsheadliners.com

thanks again
19 Jan 2008, 02:43 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by wsmith48

that appears to be the right fix, it works great now, I'll swap a link with you when I get it on the live site http://www.wlsheadliners.com

thanks again

glad its working.
19 Jan 2008, 07:13 PM
HeathenMagic

Re: Link Manager 3.0 release

Hello Clyde,

I have had the previous versions of links manager, and just downloaded the the latest version. When I run the upgrade SQL I get this:-

Quote:

1054 Unknown column 'language_id' in 'where clause'
in:
[select testimonials_id, testimonials_image, testimonials_title, testimonials_html_text, date_added from zen_testimonials_manager where status = 1 and language_id = 1 order by rand(), testimonials_title limit 5]

It could be my setup as I don't see anyone else has the same problem. I have zen_ as my prefix, if that is anything to do with. uploaded the files twice to make sure, and renamed the folders to my template also.

Appreciate any help at all. Also, could you let me know if you accept donations and where I can send them?

Heathenmagic :smile:
19 Jan 2008, 09:19 PM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by HeathenMagic

Hello Clyde,

I have had the previous versions of links manager, and just downloaded the the latest version. When I run the upgrade SQL I get this:-

It could be my setup as I don't see anyone else has the same problem. I have zen_ as my prefix, if that is anything to do with. uploaded the files twice to make sure, and renamed the folders to my template also.

Appreciate any help at all. Also, could you let me know if you accept donations and where I can send them?

Heathenmagic :smile:

Quote:

1054 Unknown column 'language_id' in 'where clause'
in:
[select testimonials_id, testimonials_image, testimonials_title, testimonials_html_text, date_added from zen_testimonials_manager where status = 1 and language_id = 1 order by rand(), testimonials_title limit 5]

This refers to testimonial manager and not links manager and appears to be the sql statement for the testimonial manager sidebox display.
19 Jan 2008, 11:23 PM
HeathenMagic

Re: Link Manager 3.0 release

%($*^ ! Ever so sorry, I must be drunk or something! Don't know why I put it in the wrong thread. Will go to the correct thread and add it there.
19 Jan 2008, 11:58 PM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by HeathenMagic

%($*^ ! Ever so sorry, I must be drunk or something! Don't know why I put it in the wrong thread. Will go to the correct thread and add it there.

No need.

run this sql statement:

copy and paste into:

admin -> tools -> install sql patches and click the send button.

Code:

ALTER TABLE `testimonials_manager` ADD `language_id` INT( 11 ) NOT NULL DEFAULT '0' AFTER `testimonials_id` ;
20 Jan 2008, 07:27 AM
starruby

Re: Link Manager 3.0 release

Quote:

Originally Posted by clydejones

First, unzip the attached file, Change the YOUR_TEMPLATE folder to match the name of your template.

upload the entire includes folder to your server.

Second, go to admin -> configuration -> links manager -> Display Link Image & Title (set to 0)

Attachment 2867

I installed the fix as mentioned but in configuration > links manager there is no additional option for "Display link image & title"

Any idea why?
20 Jan 2008, 08:55 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by starruby

I installed the fix as mentioned but in configuration > links manager there is no additional option for "Display link image & title"

Any idea why?

have you run either the install_links_manager.sql or the upgrade_links_manager.sql
20 Jan 2008, 09:13 AM
starruby

Re: Link Manager 3.0 release

Quote:

Originally Posted by clydejones

have you run either the install_links_manager.sql or the upgrade_links_manager.sql

yes at the time of installing the main module i had run the install_links_manager.sql
It works perfectly fine, but i installed the fix for disabling image column but the fix doesnt show any option in Configuration > Links manager, for disabling image column
20 Jan 2008, 05:37 PM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by starruby

yes at the time of installing the main module i had run the install_links_manager.sql
It works perfectly fine, but i installed the fix for disabling image column but the fix doesnt show any option in Configuration > Links manager, for disabling image column

admin -> configuration -> links manager -> Display Link Image & Title

This is the 6th option on the list It may also read Display Link Title

set the option to 0
20 Jan 2008, 05:45 PM
starruby

Re: Link Manager 3.0 release

Quote:

Originally Posted by clydejones

admin -> configuration -> links manager -> Display Link Image & Title

This is the 6th option on the list It may also read Display Link Title

set the option to 0

Found it... it read display link title :frusty:

thanks for your help :smile:
30 Jan 2008, 09:16 PM
quantum

Re: Link Manager 3.0 release

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:

Code:

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
31 Jan 2008, 12:03 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by 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:

Code:

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.

Code:

# 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', 'clydejones##########################', 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', '');
31 Jan 2008, 12:52 AM
quantum

Re: Link Manager 3.0 release

Hi Clyde,

Thank you for looking at that, but I still get the same error message. When I add it in, I need to remove the following, otherwise I simply get a 'failed' error message.

# 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'.
31 Jan 2008, 01:06 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by quantum

Hi Clyde,

Thank you for looking at that, but I still get the same error message. When I add it in, I need to remove the following, otherwise I simply get a 'failed' error message.

# 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'.

What versions of php and mysql are running on your server?
31 Jan 2008, 01:22 AM
quantum

Re: Link Manager 3.0 release

Hi,

MySQL 4.1.22
PHP: 5.0.5
31 Jan 2008, 01:27 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by quantum

Hi,

MySQL 4.1.22
PHP: 5.0.5

Check your PM
2 Feb 2008, 09:06 PM
lina0962

Re: Link Manager 3.0 release

Hello, Clyde:

I downloaded your newest link manager and intalled freshly on zencart v.1.3.8. I had the same problem with Wsmith48. In the admin:

Parse error: syntax error, unexpected $end in /home/.nonsense/xxxxxx/xxxxxxxx.com/admin/includes/boxes/extra_boxes/links_extras_dhtml.php on line 17

My Server OS: Linux 2.6.18.1-grsec+e+f6b+gr219+opt+c4a+gr2b-grsec

My PHP Version: 5.2.3 (Zend: 2.2.0)

Why it still doesn't work right?

Lina
2 Feb 2008, 10:19 PM
lina0962

Re: Link Manager 3.0 release

Hello, Clyde:

One more small question about link manager.

In the admin, when I want to approve/disable a submitted link, under "Options", I cannot find the drop down menu under "Status". Instead I only see

Status: 1 Required Notify Contact:
Rating: 0 Required

I have to manually type in "2" for approve, or "3" for disable. Is this the new change you made for this new version of link manager?

Lina
3 Feb 2008, 12:45 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by lina0962

Hello, Clyde:

One more small question about link manager.

In the admin, when I want to approve/disable a submitted link, under "Options", I cannot find the drop down menu under "Status". Instead I only see

Status: 1 Required Notify Contact:
Rating: 0 Required

I have to manually type in "2" for approve, or "3" for disable. Is this the new change you made for this new version of link manager?

Lina

This should fix it.

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

Attachment 3364
3 Feb 2008, 01:49 AM
Doodlebuckets

Re: Link Manager 3.0 release

Quote:

Originally Posted by lina0962

Hello, Clyde:

I downloaded your newest link manager and intalled freshly on zencart v.1.3.8. I had the same problem with Wsmith48. In the admin:

Parse error: syntax error, unexpected $end in /home/.nonsense/xxxxxx/xxxxxxxx.com/admin/includes/boxes/extra_boxes/links_extras_dhtml.php on line 17

My Server OS: Linux 2.6.18.1-grsec+e+f6b+gr219+opt+c4a+gr2b-grsec

My PHP Version: 5.2.3 (Zend: 2.2.0)

Why it still doesn't work right?

Lina

I get this too...
3 Feb 2008, 01:56 AM
Doodlebuckets

Re: Link Manager 3.0 release

Quote:

Originally Posted by Doodlebuckets

I get this too...

OK, add a } just above the ?> at the end of the file that you see listed in the error. That fixes it :)
3 Feb 2008, 02:31 AM
Doodlebuckets

Re: Link Manager 3.0 release

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.
3 Feb 2008, 02:49 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by 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?
3 Feb 2008, 02:51 AM
Doodlebuckets

Re: Link Manager 3.0 release

Quote:

Originally Posted by clydejones

Do you have "Admin Profiles" installed?

Uh, not sure what that is, so probably no ;)
3 Feb 2008, 02:55 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by 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 3367
3 Feb 2008, 03:18 AM
Doodlebuckets

Re: Link Manager 3.0 release

Quote:

Originally Posted by 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 3367

That did it! Thanks :)
3 Feb 2008, 03:21 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by Doodlebuckets

That did it! Thanks :)

OK.glad its working
3 Feb 2008, 05:39 AM
Doodlebuckets

Re: Link Manager 3.0 release

Quote:

Originally Posted by 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:

Code:

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

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: http://www.giftsofcharacter.com/cata...=links&lPath=2
3 Feb 2008, 08:14 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by 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?
3 Feb 2008, 02:50 PM
Doodlebuckets

Re: Link Manager 3.0 release

Quote:

Originally Posted by 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.
3 Feb 2008, 03:01 PM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by 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

Code:

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(');
3 Feb 2008, 03:07 PM
Doodlebuckets

Re: Link Manager 3.0 release

[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. http://www.doodlebuckets.com/store/a...cons/error.gif ERROR: Cannot insert configuration_key "BOX_DISPLAY_VIEW_ALL_LINKS" because it already exists http://www.doodlebuckets.com/store/a...cons/error.gif ERROR: Cannot insert configuration_key "PRODUCTS_OPTIONS_TYPE_SELECT" because it already exists http://www.doodlebuckets.com/store/a...cons/error.gif ERROR: Cannot insert configuration_key "UPLOAD_PREFIX" because it already exists http://www.doodlebuckets.com/store/a...cons/error.gif ERROR: Cannot insert configuration_key "TEXT_PREFIX" because it already exists http://www.doodlebuckets.com/store/a...cons/error.gif ERROR: Cannot insert configuration_key "IH_VERSION" because it already exists http://www.doodlebuckets.com/store/a...ns/warning.gif Note: 5 statements ignored. See "upgrade_exceptions" table for additional details.
3 Feb 2008, 03:42 PM
clydejones

Re: Link Manager 3.0 release

[QUOTE=Doodlebuckets;501855]

Quote:

Originally Posted by 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. http://www.doodlebuckets.com/store/a...cons/error.gif ERROR: Cannot insert configuration_key "BOX_DISPLAY_VIEW_ALL_LINKS" because it already exists http://www.doodlebuckets.com/store/a...cons/error.gif ERROR: Cannot insert configuration_key "PRODUCTS_OPTIONS_TYPE_SELECT" because it already exists http://www.doodlebuckets.com/store/a...cons/error.gif ERROR: Cannot insert configuration_key "UPLOAD_PREFIX" because it already exists http://www.doodlebuckets.com/store/a...cons/error.gif ERROR: Cannot insert configuration_key "TEXT_PREFIX" because it already exists http://www.doodlebuckets.com/store/a...cons/error.gif ERROR: Cannot insert configuration_key "IH_VERSION" because it already exists http://www.doodlebuckets.com/store/a...ns/warning.gif 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
4 Feb 2008, 05:23 PM
Doodlebuckets

Re: Link Manager 3.0 release

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 ;)
4 Feb 2008, 05:49 PM
Doodlebuckets

Re: Link Manager 3.0 release

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?
4 Feb 2008, 06:27 PM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by 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.
4 Feb 2008, 07:17 PM
Doodlebuckets

Re: Link Manager 3.0 release

Quote:

Originally Posted by 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)
4 Feb 2008, 07:48 PM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by 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.
8 Feb 2008, 09:42 PM
Doodlebuckets

Re: Link Manager 3.0 release

Quote:

Originally Posted by 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
12 Feb 2008, 02:10 AM
Doodlebuckets

Re: Link Manager 3.0 release

http://www.giftsofcharacter.com/cata...ain_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!
12 Feb 2008, 05:21 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by Doodlebuckets

http://www.giftsofcharacter.com/cata...ain_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.
12 Feb 2008, 05:27 AM
Doodlebuckets

Re: Link Manager 3.0 release

Quote:

Originally Posted by clydejones

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.

I resized it and it's still not aligning correctly and the text for all the icons are closer to the pic below it than the one it is supposed to be with.
12 Feb 2008, 05:42 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by Doodlebuckets

I resized it and it's still not aligning correctly and the text for all the icons are closer to the pic below it than the one it is supposed to be with.

After another check: all the images (except gifts for children) are 80px high.

That image is only 64px high (cleared my browser cache and refreshed the page several times)
12 Feb 2008, 05:58 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by clydejones

After another check: all the images (except gifts for children) are 80px high.

That image is only 64px high (cleared my browser cache and refreshed the page several times)

Also make sure that the first declaration in links.css reads as follows:

.linkstext{padding: 10px 0;float:left;width:33%;text-align:center;font-size:1em;}
12 Feb 2008, 06:11 AM
Doodlebuckets

Re: Link Manager 3.0 release

It's 64px because I resized it. It was 80px the first time I showed it to you and the .css is exactly as you listed. It could be that my template has something to do with it. What parameters do I tweak to get things aligned?
12 Feb 2008, 06:22 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by Doodlebuckets

It's 64px because I resized it. It was 80px the first time I showed it to you and the .css is exactly as you listed. It could be that my template has something to do with it. What parameters do I tweak to get things aligned?

Sorry, The image was 64px the first time I looked at the site (thats why I said it appeared smaller that the other images)

This is what I see in links.css (first line)

.linkstext{padding: 10 0;float:left;width:33%;text-align:center;font-size:1em;}
12 Feb 2008, 06:40 AM
Doodlebuckets

Re: Link Manager 3.0 release

Quote:

Originally Posted by Doodlebuckets

It's 64px because I resized it. It was 80px the first time I showed it to you and the .css is exactly as you listed. It could be that my template has something to do with it. What parameters do I tweak to get things aligned?

I disabled the Children's Gifts categories and it all lines up now. I think I inserted that category later after the others were created and somehow it confused things. I changed the sort order to put it at the very end and it showed up in the same place but without a pic.
12 Feb 2008, 06:43 AM
Doodlebuckets

Re: Link Manager 3.0 release

I would also like the text to be up higher and there to be space below the text between category images.
12 Feb 2008, 06:48 AM
Doodlebuckets

Re: Link Manager 3.0 release

Quote:

Originally Posted by clydejones

Sorry, The image was 64px the first time I looked at the site (thats why I said it appeared smaller that the other images)

This is what I see in links.css (first line)

.linkstext{padding: 10 0;float:left;width:33%;text-align:center;font-size:1em;}

OK, I added the px (sorry missed that the first time) and it's still not as it should be.
12 Feb 2008, 06:51 AM
Doodlebuckets

Re: Link Manager 3.0 release

Quote:

Originally Posted by Doodlebuckets

OK, I added the px (sorry missed that the first time) and it's still not as it should be.

Ignore me, I changed the wrong thing! I really need to just go to bed LOL
12 Feb 2008, 06:57 AM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by Doodlebuckets

I would also like the text to be up higher and there to be space below the text between category images.

This should fix the spacing problem.

Just unzip the file, rename the YOUR_TEMPLATE folder to match the name of your custom template and upload the entire includes folder to your server.

Attachment 3403
12 Feb 2008, 07:02 AM
Doodlebuckets

Re: Link Manager 3.0 release

Quote:

Originally Posted by clydejones

This should fix the spacing problem.

Just unzip the file, rename the YOUR_TEMPLATE folder to match the name of your custom template and upload the entire includes folder to your server.

Attachment 3403

Splendid! It's lovely now :) Thanks Clyde ! :clap:
12 Feb 2008, 02:20 PM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by Doodlebuckets

Splendid! It's lovely now :) Thanks Clyde ! :clap:

Glad to help
14 Feb 2008, 03:31 PM
Doodlebuckets

Re: Link Manager 3.0 release

I just got an email that said they could not add their link to my site. I tested and got this error when the link is submitted:

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 's Gifts' and language_id = '1'' at line 1
in:
[select link_categories_id from link_categories_description where link_categories_name = 'Baby & Children's Gifts' and language_id = '1' ]

I got no SQL errors at install. Am running 1.3.8a on sql is version 5. Do you have a fix that will not wipe out my categories and current links?
14 Feb 2008, 04:16 PM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by Doodlebuckets

I just got an email that said they could not add their link to my site. I tested and got this error when the link is submitted:

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 's Gifts' and language_id = '1'' at line 1
in:
[select link_categories_id from link_categories_description where link_categories_name = 'Baby & Children's Gifts' and language_id = '1' ]

I got no SQL errors at install. Am running 1.3.8a on sql is version 5. Do you have a fix that will not wipe out my categories and current links?

Didn't you say that you disabled that particular category?
14 Feb 2008, 04:21 PM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by Doodlebuckets

I just got an email that said they could not add their link to my site. I tested and got this error when the link is submitted:

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 's Gifts' and language_id = '1'' at line 1
in:
[select link_categories_id from link_categories_description where link_categories_name = 'Baby & Children's Gifts' and language_id = '1' ]

I got no SQL errors at install. Am running 1.3.8a on sql is version 5. Do you have a fix that will not wipe out my categories and current links?

You have an extra apostrophe in the category name:

'Baby & Children's Gifts'

To correct this, edit the category name so it appears as follows:

'Baby & Children\'s Gifts'

You may want to make this correction to any other similar category names
14 Feb 2008, 04:44 PM
Doodlebuckets

Re: Link Manager 3.0 release

Quote:

Originally Posted by clydejones

Didn't you say that you disabled that particular category?

I did disable a category on my www.giftsofcharacter.com site but they was just because that category was aligning funny. On www.doodlebuckets.com is where I am getting this error both when someone tries to submit on the links page and when I try to add in the admin.
14 Feb 2008, 04:45 PM
Doodlebuckets

Re: Link Manager 3.0 release

Quote:

Originally Posted by clydejones

You have an extra apostrophe in the category name:

'Baby & Children's Gifts'

To correct this, edit the category name so it appears as follows:

'Baby & Children\'s Gifts'

You may want to make this correction to any other similar category names

OK! I'll give it a go...
14 Feb 2008, 04:49 PM
Doodlebuckets

Re: Link Manager 3.0 release

Quote:

Originally Posted by clydejones

You have an extra apostrophe in the category name:

'Baby & Children's Gifts'

To correct this, edit the category name so it appears as follows:

'Baby & Children\'s Gifts'

You may want to make this correction to any other similar category names

When I put in the '\ in for the ', it shows up as '\ in the category name.
14 Feb 2008, 05:08 PM
clydejones

Re: Link Manager 3.0 release

Quote:

Originally Posted by Doodlebuckets

When I put in the '\ in for the ', it shows up as '\ in the category name.

It should look like this when you do the edit

Baby & Children\'s Gifts

This tells the sql statement to keep the ' before the s and not to end the statement at that point.

You may see it on the editing screen but it should show up as

Baby & Children's Gifts on the submission screen.
14 Feb 2008, 07:25 PM
Doodlebuckets

Re: Link Manager 3.0 release

Quote:

Originally Posted by clydejones

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.

Just wanted to let ya'll know that the category images will line up perfectly if you size your pics to 80px x 80px up front. I think my problem was that some pics were rectangular and some were square. When I cropped them all and resized them to 80 x 80, everything lined up great and I don't have to disable the category that was out of whack any more :)

Show 100 post(s) from this thread on one page