Deleting items from shopping cart--error showing

[DarkAngel]

Deleting the items goes thru just fine but at the bottom of the page I got this when testing something then deleting the items:

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 '' at line 6
in:
[select p.products_id, pd.products_name, products_date_available as date_expected, p.master_categories_id from zen_products p, zen_products_description pd where p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1' and p.products_date_available >20130422235959 order by date_expected desc limit ]

Idea on how to fix?

[gilby]

Deleting the items goes thru just fine but at the bottom of the page I got this when testing something then deleting the items:

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 '' at line 6
in:
[select p.products_id, pd.products_name, products_date_available as date_expected, p.master_categories_id from zen_products p, zen_products_description pd where p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1' and p.products_date_available >20130422235959 order by date_expected desc limit ]

Idea on how to fix?

The end of the query should show a number
eg: date_expected desc limit 1

right syntax to use near '' at line 6

Notice the empty value between the '' (2 single quotes)
Probably a variable that is not defined or has an empty value. So it doesn't show the limit value in the query.

[DarkAngel]

ok, I did it again and there is nothing directly after that ending "limit"

so is there a way to fix this or does it intrude on anything to leave as is.

[gilby]

ok, I did it again and there is nothing directly after that ending "limit"

so is there a way to fix this or does it intrude on anything to leave as is.

On a hunch go to....
admin/configuration/maximum Values/Upcoming Products

See if there is a numeric value there. Default is 10
My hunch is that there is a non numeric value there.

[DarkAngel]

YES!!!! Thanks, that did the trick. I did not have any number there since we do not have the coming soon/expected showing. It never worked in the beginning --- if I remember right when the customers would choose it for their carts then the item was released...it would not download so I would have to send them the zip... something like that or they

Have not tried it since...lol heap big chicken I is.