Products module doesn't show products at all

[modorius]

I have added only 1 product to the system, I use plain {Products} tag on one of my pages and I get this message:

SELECT c.* FROM cms_module_products c WHERE c.status = 'published' ORDER BY product_name cm LIMIT 0, 100000
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 'cm LIMIT 0, 100000' at line 1

What can I do to fix this?

I use:
CMSMS 1.7
Products 2.8
CGExtensions 1.18.7
CGSimpleSmarty 1.4.4

[janb]

Have look at this one:

http://forum.cmsmadesimple.org/index.ph ... 282.0.html

I have not been able to reproduce this, but there is a workaround specifying sortby and sortorder in the tag

JanB

[modorius]

Thanks janB!

Indeed, using {Products sortby="product_name" sortorder="asc"} instead of just {Products} makes it work again.

[janb]

Great!

It'not actually a solution but a kind of workaround for a rare bug.
I have twisted my head around a couple of times tried to find out what's the problem but since i don't have this problem myself it's hard to debug.

JanB

[janb]

There is a new version of Products available (v.2.8.1) but i'm not sure what's been fixed.

Maybe you can try it and see if this fix your problem?

JanB