Error 1064 on Add to Cart via categories ->products, but no error using search box..

[mad_dexter]

When I expand the left hand nav menu to show categories in the main page, then select the categories to show products, then click add to cart for the required product, 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

delete from customers_wishlist WHERE customers_id=206 AND products_id=

[TEP STOP]

However, if I add to cart by finding products from the search function I do not get an error. Can anyone help?

Thanks.

[michael_s]

Again, an old bug that was resolved eons ago. Check the bugtracker for your fix, or update to a more current version of osCMax.

[mad_dexter]

Thanks again. Is moving to RC4 a case of copying files/directories to the server? Are my modified templates left untouched and will I have to copy the database back to the server again? Thanks.

[michael_s]

Moving to RC4 from RC3 is fairly easy, but I think it would be easier and quicker to grab the fixes you need from the bugtracker.

[mad_dexter]

There are only 2 bugfixes listed for 1064, but they arefor different problems. Should I go for the update to RC4?

[michael_s]

You are looking for the wrong thing in the bugtracker.

025: Error produced when you click on Buy Now on catalogue result page when logged in. - Bug Tracker - open source Commerce Maximized :: osCMax

[mad_dexter]

Have uploaded the bugfix from yr link into includesmodules but still get same error.

[michael_s]

Clear your browser cache and osCMax cache. The fix works.

[mad_dexter]

All working now after clearing cache. Star!! Thanks for your help.

[mad_dexter]

Just been testing again...

I don't get this error when not logged in, but I do get it when logged in as a customer.

Any ideas? Thanks.