sending Reviews error

[Lackew]

when doing a product review and click submit this error comes up.

1064 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 '-0, 0' at line 9
in:
[SELECT r.reviews_id, left(rd.reviews_text, 100) AS reviews_text, r.reviews_rating, r.date_added, p.products_id, pd.products_name, p.products_image, r.customers_name FROM zen_reviews r, zen_reviews_description rd, zen_products p, zen_products_description pd WHERE p.products_status = '1' AND p.products_id = r.products_id AND r.reviews_id = rd.reviews_id AND p.products_id = pd.products_id AND pd.language_id = 1 AND rd.languages_id = 1 AND r.status = 1 ORDER BY r.reviews_id DESC limit -0, 0]

I am using Zen Cart 1.3.8a
on a Linux server

[DrByte]

You've misconfigured your admin settings.

Admin->Configuration->Maximum Values->New Product Reviews Per Page ... you've set that to 0, which is causing the error you're seeing.


One should usually *not* set a "0" on most Maximum Values settings.

[Lackew]

hmmmmmmmmmm this is what I have but dont see what you mentioned:

Address Book Entries 5
Search Results Per Page 20
Prev/Next Navigation Page Links 5
Products on Special 0
New Products Module 20
Upcoming Products 0
Manufacturers List - Scroll Box Size/Style 0
Manufacturers List - Verify Product Exist 0
Music Genre List - Scroll Box Size/Style 3
Record Company List - Scroll Box Size/Style 3
Length of Record Company Name 15
Length of Music Genre Name 15
Length of Manufacturers Name 15
New Product Reviews Per Page 0
Random Product Reviews for SideBox 0
Random New Products for SideBox 0
Random Products On Special for SideBox 0
Categories To List Per Row 3
New Products Listing- Number Per Page 0
Best Sellers For Box 0
Also Purchased Products 0
Recent Purchases Box- NOTE: box is disabled 0
Customer Order History List Per Page 10
Maximum Display of Customers on Customers Page 20
Maximum Display of Orders on Orders Page 20
Maximum Display of Products on Reports 20
Maximum Categories Products Display List 10
Products Attributes - Option Names and Values Display 10
Products Attributes - Attributes Controller Display 30
Products Attributes - Downloads Manager Display 30
Featured Products - Number to Display Admin 10
Maximum Display of Featured Products - Main Page 0
Maximum Display of Featured Products Page 0
Products Listing- Number Per Page 10
Random Featured Products for SideBox 0
Maximum Display of Specials Products - Main Page 0
New Product Listing - Limited to ... 0
Maximum Display of Products All Page 10
Maximum Display of Language Flags in Language Side Box 0
Maximum File Upload Size 2048000
Allowed Filename Extensions for uploading jpg,jpeg,gif,png,eps,cdr,ai,pdf,tif,tiff,bmp,zip
Maximum Orders Detail Display on Admin Orders Listing 0
Maximum PayPal IPN Display on Admin Listing 20
Maximum Display Columns Products to Multiple Categories Manager 3
Maximum Display EZ-Pages 20
New Products Module
Number of new products to display in a category

[DrByte]

Address Book Entries 5
Search Results Per Page 20
Prev/Next Navigation Page Links 5
Products on Special 0
New Products Module 20
Upcoming Products 0
Manufacturers List - Scroll Box Size/Style 0
Manufacturers List - Verify Product Exist 0
Music Genre List - Scroll Box Size/Style 3
Record Company List - Scroll Box Size/Style 3
Length of Record Company Name 15
Length of Music Genre Name 15
Length of Manufacturers Name 15
New Product Reviews Per Page 0
Random Product Reviews for SideBox 0
Random New Products for SideBox 0
Random Products On Special for SideBox 0
Categories To List Per Row 3
... snip

Right there in the list

[Lackew]

OMG guess I looked too hard, rflmao
thank you sooooooooooooooooo much

would you happen to know how to hide the dowload attribute on a products page????????

[DrByte]

would you happen to know how to hide the dowload attribute on a products page????????

I suspect the easiest would be to use some CSS styling to hide it.
But that's an entirely separate topic than the one currently being discussed in this thread.