Jump to content
Jack_mcs

Links Manager II

Recommended Posts

To visit it manually, open a browser, type in the url and press enter.

 

As I recall, the problem occurred in the last version as well but you could check that support thread to be sure.

 

Jack

Share this post


Link to post
Share on other sites
i have a problem i just installed the latest version 1.7 with the update to oscommerce version rc1 using php5 it was a clean install on the link index page http://angelstoyshop.com/osCommerce/links.php i get teh error

 

1064 - You have an error in your SQL syntax near '( links_description ld, links_to_link_categories l2c, link_categories lc ) on (l' at line 1

 

select l.links_status from links l LEFT JOIN ( links_description ld, links_to_link_categories l2c, link_categories lc ) on (l.links_status = 2 and ld.language_id = '1' and l2c.links_id = l.links_id and lc.parent_id = '0')

 

[TEP STOP]

and on the admin index page http://angelstoyshop.com/..../admin/links.php i get

 

1064 - You have an error in your SQL syntax near '( links_description ld ) on ( l.links_id = ld.links_id ) ' at line 1

 

select count(*) as total from links l left join ( links_description ld ) on ( l.links_id = ld.links_id )

 

[TEP STOP]

 

in the \includes\classes\split_page_results.php the code has been changed to this $this->sql_query .= " limit " . max($offset, 0) . ", " . $this->number_of_rows_per_page;

 

what could be causing the proble and how do i solve it

 

thanks

lenard

 

Try this, from the readme.txt:

 

Possible Problems

If you get a message like

 

"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 '-20, 20' at line 1"

 

it is caused by a know code problem with mysql. To fix it, open the

admin/includes/classes/split_page_results.php file and

 

CHANGE THIS:

 

$sql_query .= " limit " . $offset . ", " . $max_rows_per_page;

 

TO THIS:

 

$sql_query .= " limit " . max($offset,0) . ", " . $max_rows_per_page;

 

OR try this, which solved a similar problem for me

 

"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 '-20, 20' at line 1"

in admin/link.php

 

find:

$where = '';

if (isset($HTTP_GET_VARS['search']) && tep_not_null($HTTP_GET_VARS['search'])) {

$keywords = tep_db_input(tep_db_prepare_input($HTTP_GET_VARS['search']));

$where = ' where ';

$search = " ld.links_title like '%" . $keywords . "%' or l.links_url like '%" . $keywords . "%'";

}

 

if ($showLinkStatus == 'All')

$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . $search . " order by " . $order;

else

$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . " l.links_status = '" . $showLinkStatus . "' and " . $search . " order by " . $order;

 

replace with:

 

$where = ' where ';

if (isset($HTTP_GET_VARS['search']) && tep_not_null($HTTP_GET_VARS['search'])) {

$keywords = tep_db_input(tep_db_prepare_input($HTTP_GET_VARS['search']));

$where = ' where ';

$search = " and ld.links_title like '%" . $keywords . "%' or l.links_url like '%" . $keywords . "%'";

}

else if ($showLinkStatus == 'All')

$where = '';

 

if ($showLinkStatus == 'All')

$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . $search . " order by " . $order;

else

$links_query_raw = "select l.links_id, l.links_url, l.links_image_url, l.links_date_added, l.links_last_modified, l.links_status, l.links_clicked, ld.links_title, ld.links_description, l.links_contact_name, l.links_contact_email, l.links_reciprocal_url, l.links_reciprocal_disable, l.links_status from " . TABLE_LINKS . " l left join ( " . TABLE_LINKS_DESCRIPTION . " ld ) on ( l.links_id = ld.links_id ) " . $where . " l.links_status = '" . $showLinkStatus . "'" . $search . " order by " . $order;

 

 

Good luck!

Share this post


Link to post
Share on other sites

Hi, I've got the contrib installed and working but when go to checkout I get the "this page contains both secure and insecure items... " message from internet explorer.

 

This only happens if i have the featured links option turned on. Is there any change I can make to the contrib so that I do not get the messages during checkout? Is it because the links being referred to in the featured links setup are not SSL?

 

Thanks for a great contrib!

Share this post


Link to post
Share on other sites
Hi, I've got the contrib installed and working but when go to checkout I get the "this page contains both secure and insecure items... " message from internet explorer.

 

This only happens if i have the featured links option turned on. Is there any change I can make to the contrib so that I do not get the messages during checkout? Is it because the links being referred to in the featured links setup are not SSL?

 

Thanks for a great contrib!

That is probably the reason. In the includes/boxes/links.php file, change this
if (tep_db_num_rows($link_featured_query) > 0) {

to this

if ($request_type == NONSSL && tep_db_num_rows($link_featured_query) > 0) {

 

Jack

Edited by Jack_mcs

Share this post


Link to post
Share on other sites

Hi jack I have installed the Links 1.17 fine, but call me thick how to I view my pending links I got the email but where do I go in admin to view?

 

Thanks

 

Matt

Share this post


Link to post
Share on other sites

Look in admin->Links Manager->Links and select Pending from the dropdown.

 

Jack

Share this post


Link to post
Share on other sites
That is probably the reason. In the includes/boxes/links.php file, change this
if (tep_db_num_rows($link_featured_query) > 0) {

to this

if ($request_type == NONSSL && tep_db_num_rows($link_featured_query) > 0) {

 

Jack

 

Yessss! that worked! Thanks Jack. This contrib will really help make my sight "sticky". :thumbsup:

Share this post


Link to post
Share on other sites
Look in admin->Links Manager->Links and select Pending from the dropdown.

 

Jack

 

I do not seem to have that option in admin I have included a screenshot, I only have a Links tab to change settings?

 

Thanks

 

Matt

linksadmin.gif

Share this post


Link to post
Share on other sites
I do not seem to have that option in admin I have included a screenshot, I only have a Links tab to change settings?
You are looking in admin->Configuration->Links. From the screenshot, you are missing the Links section completely. You need to go back through the admin install.

 

Jack

Share this post


Link to post
Share on other sites
I do not seem to have that option in admin I have included a screenshot, I only have a Links tab to change settings?

 

Thanks

 

Matt

linksadmin.gif

 

Thanks Jack turns out I did not copy the correct code for the columns_left.php in the admin/includes duh

Share this post


Link to post
Share on other sites
Hi Jack

 

When someones adds a link to my site it sends them an email for saying where their link is for example http://golfgear4lessuk.com/links.php?lPath=8

but their actual link is at http://golfgear4lessuk.com/catalog/links.p...d=0&lPath=8.

 

How do I correct the automatically generated email to have the links correct address

 

Regards

 

Matt

What version are you using?

 

Jack

Share this post


Link to post
Share on other sites
Hi,

 

I have just installed the version 1.17 as well as the last version of ultimate SEO, but I have despite everything the bonds with: parentid=

 

What do I have to make to have url writing?

 

http://www.santenature.fr/links.php?parentid=0&lPath=1

That is because of the change in v 1.17. I plan on working on it but I can't say when.

 

Jack

Share this post


Link to post
Share on other sites
Hi I am using 1.17 8 july 07 upped by you I think

 

Matt

Try this: In admin/inks.php, find
$siteURL = sprintf("%s/links.php?lPath=%s", HTTP_CATALOG_SERVER,$category['link_categories_id']);

and replace it with

				 $siteURL = sprintf("%s%slinks.php?lPath=%s", HTTP_CATALOG_SERVER,DIR_WS_CATALOG,$category['link_categories_id']);

 

Jack

Share this post


Link to post
Share on other sites
Try this: In admin/inks.php, find
$siteURL = sprintf("%s/links.php?lPath=%s", HTTP_CATALOG_SERVER,$category['link_categories_id']);

and replace it with

				 $siteURL = sprintf("%s%slinks.php?lPath=%s", HTTP_CATALOG_SERVER,DIR_WS_CATALOG,$category['link_categories_id']);

 

Jack

 

Hi

 

I still cant get it to work I get directed to this page http://golfgear4lessuk.com/links.php?lPath=8 when it needs to be http://golfgear4lessuk.com/catalog/links.p...d=0&lPath=8.

 

Thanks

 

Matt

Share this post


Link to post
Share on other sites

Hi

 

I have just installed v1.17 and everything seems to be working just fine on the admin side, however on my catalog side all I get is the fllowing error:

 

Fatal error: Cannot redeclare tep_show_category() (previously declared in /home/private/public_html/private/includes/header.php:182) in /home/private/public_html/private/includes/boxes/categories.php on line 13

 

I have gone thru the installation 4 times already.

 

Does anyone have any idea how to fix this!

 

Thanks...


DawnMarieGifts

Share this post


Link to post
Share on other sites
Hi

 

I still cant get it to work I get directed to this page http://golfgear4lessuk.com/links.php?lPath=8 when it needs to be http://golfgear4lessuk.com/catalog/links.p...d=0&lPath=8.

 

Thanks

 

Matt

Then it sounds like your admin configure file is setup incorrectly. Look in that file and make sure DIR_WS_CATALOG is set to catalog.

 

Jack

Share this post


Link to post
Share on other sites
Hi

 

I have just installed v1.17 and everything seems to be working just fine on the admin side, however on my catalog side all I get is the fllowing error:

 

Fatal error: Cannot redeclare tep_show_category() (previously declared in /home/private/public_html/private/includes/header.php:182) in /home/private/public_html/private/includes/boxes/categories.php on line 13

 

I have gone thru the installation 4 times already.

 

Does anyone have any idea how to fix this!

 

Thanks...

See this.

 

Jack

Share this post


Link to post
Share on other sites
See this.

 

Jack

 

 

Thanks Jack, I actually fixed it by removing require left column and require right column since they are being called from the header anyways.

 

It's working great now.

 

I do have a cosmetic problem, but I'll put it in a new post so we can close this issue.

 

Again Thanks a bunch!


DawnMarieGifts

Share this post


Link to post
Share on other sites

Hi.

 

Please take a look at the screenshot; I'm trying to align it left to match my template.

 

Any help would be greatly appreciated.

 

Thank.

 

 

 

 

screenshot.jpg


DawnMarieGifts

Share this post


Link to post
Share on other sites

When you removed the left column, you may have just removed the include statement so that the table is still in there causing the space.

 

Jack

Share this post


Link to post
Share on other sites
Hi

 

I still cant get it to work I get directed to this page http://golfgear4lessuk.com/links.php?lPath=8 when it needs to be http://golfgear4lessuk.com/catalog/links.p...d=0&lPath=8.

 

Thanks

 

Matt

 

Hi Matt,

 

I also had the same problem you had and I have applied the recommended fix and it worked for me, so it is probably something in your config file.

Share this post


Link to post
Share on other sites
When you removed the left column, you may have just removed the include statement so that the table is still in there causing the space.

 

Jack

 

 

Yup!

 

Thats exactly what I did...... Got it all strait now.

 

Thanks for your help Jack.


DawnMarieGifts

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×