Hi,

I have a client waiting on a site - which is running SS 2.2.1 and eCommerce 0.5.1. I have had work done on the eCommerce module so the "not adding to cart" problem is fixed.

But now that problem is fixed and I have the system interacting with the DPS server - when an order is placed - DPS receives the transaction but the site returns the following error http://www.subvert.co.nz/af-error/. I have no idea on where to start trying to fix this problem so that the order is emailed to the site manager!

Have you tried running db/build?flush=1 again?

And does the file ecommerce/code/Product.php exist?

Ran /db/build?flush=1 and checked that ecommerce/code/product.php does exist. Still same error. Cheers

And does the table Product_Live exist?

Yes it exists

it is clear that the error is in the sql statement not including the product_live in the FROM part of the select statement.

I am not sure if this is an ecommerce specific problem or something more general.

It's confusing the hell out of me as the 'Product_Live' table exists.

The table exists, but the select statement is incorrect.
It says:

select appleTable.*, pearTable.* from appleTable;

That is why I am thinking there is actually something wrong with the underlying code...

Nicolaas