Link Manager 3.0 Support Thread

clydejones:

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

clydejones:

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.

dealbyethan.com:

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

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.

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.

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

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?

clydejones:

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

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

Tassos

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?

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.

clydejones:

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.

clydejones:

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

dealbyethan.com:

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.

No problem on this. the links status table already had that field deleted and the sql is just reafiming that for you.

Hi clydejones

Are you saying that update_links_manager.sql was run successfully and I have finished updating links manager to the latest version?

dealbyethan.com:

Hi clydejones

Are you saying that update_links_manager.sql was run successfully and I have finished updating links manager to the latest version?

check admin -> configuration -> links manager

if the last item gives you a version number then the sql was run successfully.

You should also upload/FTP ALL the folders included in the upgrade to your server.

clydejones:

check admin -> configuration -> links manager

if the last item gives you a version number then the sql was run successfully.

You should also upload/FTP ALL the folders included in the upgrade to your server.

The last item is a version number 3.5.2 but not 3.5.3a. Does that mean it didn't upgrade completely?

When I upgraded zen cart to 1.3.9c, I planned to uninstall and reinstall links manager. So I uploaded all the files from the newinstall folder to the server (there were no links manager files from the previous version as I did this in a separate test folder). Is this okay? or do I have to include all the files in the upgrade folder as well?

dealbyethan.com:

The last item is a version number 3.5.2 but not 3.5.3a. Does that mean it didn't upgrade completely?

When I upgraded zen cart to 1.3.9c, I planned to uninstall and reinstall links manager. So I uploaded all the files from the newinstall folder to the server (there were no links manager files from the previous version as I did this in a separate test folder). Is this okay? or do I have to include all the files in the upgrade folder as well?

You should be good to go.

I keep forgetting to make that change in the sql statement, but it did upgrade completely.

If you uploaded the files from the newinstall folder then you don't need to do anything else.

If you had previous links they should be stored in the database and you should be able to see them by going to
admin -> extras -> links

Hello Clyde,

Will this fix still work for the latest link manager version on a 1.3.9c site?

Thanks.

gaffettape:

Hello Clyde,

Will this fix still work for the latest link manager version on a 1.3.9c site?

Thanks.

Should do!

Hi,

Thanks for a great mod and I like it very much. However I am having one small issue. When I go to Admin-Extras-Links I am getting an HTTP 500 Internal Server error with Page Cannot be displayed error with IE8 and blank pages using FF and Google Chrome. I have uninstalled and reinstalled and still same thing. All pages in the Mod I have checked to make sure all were uploaded and everything seems to be in check.

Any suggestions would be greatly appreciated on getting this little bug worked out.

Your help would be greatly appreciated.

KeystoneAirsoft:

Hi,

Thanks for a great mod and I like it very much. However I am having one small issue. When I go to Admin-Extras-Links I am getting an HTTP 500 Internal Server error with Page Cannot be displayed error with IE8 and blank pages using FF and Google Chrome. I have uninstalled and reinstalled and still same thing. All pages in the Mod I have checked to make sure all were uploaded and everything seems to be in check.

Any suggestions would be greatly appreciated on getting this little bug worked out.

Your help would be greatly appreciated.

You should check with your hosting company about this HTTP 500 Internal Server error.

Make sure you've uploaded ALL of the following files. and check the folder and file permissions.

admin/link_categories.php
admin/links.php
admin/links_contact.php
admin/includes/boxes/extra_boxes/links_extras_dhtml.php
admin/includes/extra_datafiles/links_manager.php
admin/includes/functions/extra_functions/links_manager.php
admin/includes/languages/english/links.php
admin/includes/languages/english/link_categories.php
admin/includes/languages/english/links_contact.php
admin/includes/languages/english/extra_definitions/links.php

Hi clydejones,

THanks for your prompt reply.

Ok I sent in a ticket with my webserver and they said they didn't see anything wrong but did make mention that they have seen some files not work due to being under a subdirectory as my ZenCart is at this time. Doesn't make sense to me but we will see when I move my site from the subdirectory to the main URL directory.

All folders are at 755 and files are at 644. No files were missing from your install per your post.

Again thanks for your prompt reply and help.