Problems with RelatedContent module and UC

Posts: 104
Joined: 01/11/2008

I've installed the related content module but having a small problem. Don't know id this is UC related or the RelatedContent module.

I get this error when editing a product >> related content >> then choosing the view that grabs info for UC. If I choose any other view that doesn't contain any UC products/fields then I don't get the error.

user warning: 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 ''') AND (node.type IN ('product','product_kit'))' at line 1 query: SELECT count(node.nid) FROM node node LEFT JOIN uc_products uc_products ON node.vid = uc_products.vid WHERE (. '') AND (node.type IN ('product','product_kit')) in /home/pnwgs/domains/pnwgardensupply.com/public_html/includes/database.mysql.inc on line 172.

Thanks

Posts: 2114
Joined: 08/07/2007
AdministratoreLiTe!

I suspect that query is being generated by Views. I can't find a reference to "SELECT count(" anywhere, and I always use "AS" with my table aliases. Since the problem is in the WHERE clause, I suspect a Filter is messed up in some way. The part after the AND looks like the "Is a product" filter, so I would check your View definition around that area. If it looks alright, you may have to put an issue in to the RelatedContent queue. I can't make heads or tails out of that code to be of much help.