I think that maybe my installation is hosed :( When trying to get a list of products (www.minimism.com/product) I see an empty page, but there's an error logged:

user error: You have an error in your SQL syntax near 'n.status = 1 ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 15' at line 1 query: SELECT n.nid FROM node n INNER JOIN node_access na ON (na.nid = 0 OR na.nid = n.nid) INNER JOIN ec_product p ON n.nid = p.nid WHERE na.grant_view = 1 AND CONCAT(na.realm, na.gid) IN ('all0') n.status = 1 ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 15 in /usr/local/psa/home/vhosts/minimism.com/httpdocs/includes/database.mysql.inc on line 125.

I have a couple of products added, so I would expect this page to have *some* content! Also I noticed that there is no 'access products' permission-setting for my users (referenced in another (closed) bug report)

Comments

minimism’s picture

minimism commented

Ok, I've done a little more searching and found that the query actually exists in product.module - in the "theme_product_view_collection()" function it would seem...

... does this make sense to anyone? It'd probably take me a long while to get my head around the code, so this is one for some knowledgeable person!

jasonwhat’s picture

jasonwhat commented

having same problem with latest CVS and getting this error. Everything is fine otherwise, just no pages on product listing page.

user error: 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 'n.status = 1 ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 15 query: SELECT n.nid FROM node n INNER JOIN ec_product p ON n.nid = p.nid WHERE '1' n.status = 1 ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 15 in /home/woorg/public_html/includes/database.mysql.inc on line 125.

Anonymous’s picture

(not verified) commented
Component: product.module » shipping.module

Same issue here. I cannot get products to show up and receive the same SQL error message.

matt westgate’s picture

matt westgate commented
Component: shipping.module » product.module

This is fixed now. Thanks.

Anonymous’s picture

(not verified) commented