items not being added to cart

[Antenociti]

We ahve a whole category of the website where items are not added to the cart when you click on "add to cart".
It takes you to the cart page but doesnt add the item, nor does it display any message error.

http://www.antenocitisworkshop.com/gbu0 ... green.html


the "packaging" item works, but not any of the products in any of the other sections.

the products are in stock, set "available to everyone"

[GreenbarnWeb]

Hi Jed,

The problem is that you have spaces in the product id’s.

See this example where the +++ indicated spaces.
http://www.antenocitisworkshop.com/gbu0 ... +++++.html

In the admin goto:
Home > Kryptronic Hybrid X Core > Database: Connections, Backups and Raw Admin > Raw Database Admin

Click the SQL Statement: Submit a Raw SQL Statement

Then use this SQL Statement:
UPDATE gbu0_prod SET id=replace(id, ' ', '')

[Antenociti]

yes that fixed the problem thanks.

What causes this though and is it likely to happen again?

[GreenbarnWeb]

Hi

Either when you insert a product via the admin you are typing in the spaces or if you a importing via the raw database admin the spaces are in the product id column.

[Antenociti]

Hi

Either when you insert a product via the admin you are typing in the spaces or if you a importing via the raw database admin the spaces are in the product id column.

imported via csv so its probalby a C&P issue from other programs.... good old invisible spaces eh.