Please help! Shop almost finished and now i have an error..

[Guest]

Dear oscommerce user;

 

First thank you all, with this forum i have created a oscommerce webshop for the first time! Oscommerce is Super!

 

Here is the problem:

 

When I open my webshop, www.goodies4you.nl/shop/ i get the following error:

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 1

 

select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '4' order by date_expected desc limit

 

But also when for example you hit "Formule 1 Pitspoes Kostuum - Code: E20389" i wil get following error:

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 1

 

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '725' and opa.orders_id = opb.orders_id and opb.products_id != '725' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit

 

I know this is a lot of information, but i really hope someone can help me fix this problem, because i have no idea at all. Been busy with this for 8hours now.

 

All the help/ suggestions are welcome. Thank you in advance.

 

Rob V.

[djmonkey1]

Try this post:

 

http://www.oscommerce.com/forums/index.php?sho...mp;#entry697026