Link Manager 3.0 Support Thread

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:

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.

%($*^ ! 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.

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

---

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?

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

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

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

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:

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