Home : Products : Gossamer Links : Development, Plugins and Globals :

Products: Gossamer Links: Development, Plugins and Globals: Re: [Andy] related categories links: Edit Log

Here is the list of edits for this post
Re: [Andy] related categories links
Andy,

I tried this "get_links_from_related_cats" global above, but gives an error in many categories as follows (only works for some categories but shows new, updated, popular for all listings).

For example, if you click on "Computer-Technology" category on my site, it will show errors in the browser.

Code:



Failed to execute query: 'SELECT glinks_Links.* FROM glinks_CatLinks,glinks_Category,glinks_Links WHERE glinks_CatLinks.LinkID = glinks_Links.ID AND glinks_CatLinks.CategoryID = glinks_Category.ID AND ((glinks_CatLinks.CategoryID IN NULL) AND (glinks_Links.isNew = 'Yes' AND glinks_Links.isValidated = 'Yes')) ORDER BY Links_PPC_Bid DESC, Links_PPC_Bid DESC, isFeatured DESC,isPick DESC,isNew DESC,isPopular DESC,Title': 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 'NULL) AND (glinks_Links.isNew = 'Yes' AND glinks_Links.isValidated = 'Yes')) ORD' at line 1 at (eval 55) line 16.

Thanks!

Last edited by:

socrates: Feb 27, 2017, 3:46 PM

Edit Log: