System Error Log Displays Many Pages of same Error

[svrabel]

File: [gui.class.php] Line: [1193] "SELECT price, sale_price, product_id,description,name, price-sale_price AS saving FROM CubeCart_inventory WHERE price > sale_price AND sale_price > 0 AND status = '1' LIMIT " - 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 '' at line 1

[bhsmither]

In admin, Store Settings, Features tab, make sure there is an integer value for the setting "Number of sale items to display".

During CubeCart's setup, it is supposed to configure the settings with a default of 10.

[svrabel]

It was blank when I checked it. Not sure how it happened, but thanks for the help.

[bhsmither]

Suggest the statement include a ternary test for an empty LIMIT clause.

[abrookbanks]

Thanks for reporting this.

[bhsmither]

See:
https://forums.cubecart.com/topic/50800-v610-no-longer-accepts-0-for-sale-items-to-display/

[abrookbanks]

Thanks again Brian.