Link Manager 3.0 Support Thread

[clydejones]

Hi,

Just upgraded zen cart from v1.3.7 to v1.3.9c. Thinking to reinstalling links manager. When this is done, how do I import all the old links from the previous version of links manager to the latest version?

The links are stored in the database. That being the case, you shouldn't have to reinstall links manager at all just upgrade to the most recent version.

[clydejones]

Hi Clyde,

PLEASEEEEE help as I am going crazy. I have just noticed that on a multilingual site the module breaks giving me the "Object of class queryFactoryResult could not be converted to string" in html_output.php

Let me though explain:
Zen Cart v1.38
Link manager v3.5.2
Latest Security patches applied
Multi-lingual (6 languages)
Links can be submitted no problem at all

In Admin I can go in the English language and when I do in Edit the last drop down menu that allows to change the status works perfectly. I can select Approve and Update and everything is fine.

When I change the language though to any of the other languages there is an empty drop down menu at the Edit page and if I click the Update get the queryFactoryResult error.

I have tried the html_output_admin.zip updates in the earliest posts plus search the whole forum and tried every solution that I couldfind even if they were related to different modules. Nothing works.

Any idea will greatly help

Tassos

Do you have any links that are in any of the 5 additional languages or only in English?

link to your site?

[hrinfo]

Do you have any links that are in any of the 5 additional languages or only in English?

link to your site?

Yes I have added links in the other languages and created categories for each of the languages. Everything works fine. It is only when I go to Approve the link that the error comes up.

So the link shows up but can not be approved. Also the links are different for each language so there is no mix up between them.

Tassos

[clydejones]

Yes I have added links in the other languages and created categories for each of the languages. Everything works fine. It is only when I go to Approve the link that the error comes up.

So the link shows up but can not be approved. Also the links are different for each language so there is no mix up between them.

Tassos

Try uploading the security patch from this thread and see if that corrects the problem.

[hrinfo]

Try uploading the security patch from this thread and see if that corrects the problem.

Already had the patch installed but just in case downloaded again and reinstalled. No change.


Tassos

[dealbyethan.com]

The links are stored in the database. That being the case, you shouldn't have to reinstall links manager at all just upgrade to the most recent version.

Hi

The problem is I am not sure which previous version of links manager I am currently using. Is there a way to find out? or does it not matter? Thank you.

[clydejones]

Hi

The problem is I am not sure which previous version of links manager I am currently using. Is there a way to find out? or does it not matter? Thank you.

Shouldn't make any difference.

You're using ZC 1.3.9c

Upgrade to the newest version of Links Manager (v3.5.3a).

[dealbyethan.com]

Just tried running the update_links_manager.sql but got the following error. Please advise. Thanks.

1054 Unknown column 'links_status.links_status_id' in 'where clause'
in:
[DELETE FROM zen_links_status WHERE links_status.links_status_id = 3;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[clydejones]

Just tried running the update_links_manager.sql but got the following error. Please advise. Thanks.

1054 Unknown column 'links_status.links_status_id' in 'where clause'
in:
[DELETE FROM zen_links_status WHERE links_status.links_status_id = 3;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I'm assuming that your additional language ID's are as follows:

2
3
4
5
6

if so then run the following sql statement and see if that corrects the problem.

copy and paste the following in admin -> tools -> install sql patches (and click the send button)

INSERT INTO `links_status` VALUES (1, 2, 'Pending');
INSERT INTO `links_status` VALUES (2, 2, 'Approved');
INSERT INTO `links_status` VALUES (1, 3, 'Pending');
INSERT INTO `links_status` VALUES (2, 3, 'Approved');
INSERT INTO `links_status` VALUES (1, 4, 'Pending');
INSERT INTO `links_status` VALUES (2, 4, 'Approved');
INSERT INTO `links_status` VALUES (1, 5, 'Pending');
INSERT INTO `links_status` VALUES (2, 5, 'Approved');
INSERT INTO `links_status` VALUES (1, 6, 'Pending');
INSERT INTO `links_status` VALUES (2, 6, 'Approved');

[dealbyethan.com]

Hi,

I don't think I have additional language ID's... English is the only language installed. Is it safe to run that script? If yes, do I also need to run update_links_manager.sql again?