Shop Error

Hi Drew,

Yes I have set up all the config stuff that was required. Want me to screenshot it?

This is the first time / place we have had the shop app running so haven't had anything working anywhere else yet.

My screenshot didn't work :/ Does this help?

Debug Message
[1] SELECT * FROM perch2_pages WHERE pagePath='/products/product.php' LIMIT 1
[1] SELECT * FROM perch2_shop_cart WHERE cartID=9
[1] SELECT * FROM perch2_shop_cart WHERE cartID=9
[6] SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='status' AND idx.indexValue='1')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
[6] SELECT DISTINCT idx.itemID FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='parentID' AND idx.indexValue='')) GROUP BY idx.itemID HAVING COUNT(idx.itemID)=1
[1] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch2_shop_index idx JOIN perch2_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch2_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='_id' AND idx.itemID IN ('1', '2', '3', '4', '5', '6') AND idx.itemID IN ('1', '2', '3', '4', '5', '6') WHERE 1=1 AND ((idx.indexKey='slug' AND idx.indexValue='some-other-bag-test005')) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey ) as tbl WHERE (productDeleted IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
[25] SELECT DISTINCT settingID, settingValue FROM perch2_settings WHERE userID=0
Using template: /addons/apps/perch_shop/templates/shop/products/product.html
[4] SELECT catID, catPath FROM perch2_categories

Also is it anything to do with the form action? I didn't want the page to redirect anywhere, I just wanted to add a product tot he cart and for the page to stay where it was so I didn't add an action.

Okay that's what I presumed.

However still getting these error messages. Do you think it is something to do with the way I have setup the shop settings? Can't get any output for cart now. Get the errors when 'adding to cart' and trying to view the cart.

I only have a few test products configured at the moment. Was reading another thread that was saying something about the tax locations? I deleted the data from the database tables as someone mentioned that had fixed things for them but no joy still not working when adding products to cart and still getting the errors :(

When I've run into errors like this during development... (changing product templates, etc.), If I go clear the cookies for the browser, that sometimes helps get me back on track as far as cart issues go.

Thanks for the reply! To me it doesn't really seem to be a template thing. The templates were working fine before I added a product. Once I added a product this is when I hit the errors.

Seems to be a tax thing, possibly the way I have set them up. However I did follow the docs when doing this so I can't see what I have done wrong.

Well I have no idea why but I configured some more tax locations and groups and now it seems to work?

This now seems to be resolved.