Link Manager 3.0 Support Thread

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

[hrinfo]

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

You are a legend, thanks a million

It worked perfectly. maybe in the next update you could add a read me file with the code in it for people like me

Tassos

[clydejones]

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?

If you have 6 languages then you must have added them in admin -> localization -> languages

Since you seem to have successfully run the sql statement I'm guessing everything is OK.

and Yes, I'll add a note in the readme file about adding the additional languages for the links status table.

[dealbyethan.com]

If you have 6 languages then you must have added them in admin -> localization -> languages

Since you seem to have successfully run the sql statement I'm guessing everything is OK.

and Yes, I'll add a note in the readme file about adding the additional languages for the links status table.

Hi clydejones,

I think you meant to quote what hrinfo said instead of what I said? I have a different problem. How should I fix it?

Tried running the update_links_manager.sql but got the following error.

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.

[hrinfo]

If you have 6 languages then you must have added them in admin -> localization -> languages

Since you seem to have successfully run the sql statement I'm guessing everything is OK.

and Yes, I'll add a note in the read me file about adding the additional languages for the links status table.

hi Clyde,

Jut for everyone else, you are correct in that I have added the languages admin -> localization -> languages.

And yes, the SQL statement that you provided solved the problem. I did tried and tested on a windows and a linux server and worked in both machines.

The drop down menu in Edit comes up and I can either choose Pending on Approve and everything works as it should :-)

Thanks again

Tassos