Offical OpenCart v1.5.0 RC2 Bug Thread

Daniel wrote:you do this manually from the admin > orders. there is a icon you click to add their transaction. maybe i need to make it a bit clearer and add it to the order list page.

same with reward points.

helenmarie wrote:I think i found a bug? I have done a fresh install to test it out.

Everything adds to the cart fine from the category page except for the Apple Monitor 30" which has a special price applied to it, and when you click Add to cart it redirects you to the product page and doesnt add it to your cart?

EDIT: Is this happening because it has product options attached to it? If so, should it read 'Product Detail's as opposed to 'Add To Cart'?

leewan wrote:I updated open cart 1.4.9.4 to this v1.5.0 RC2 and received this

on the admin page
Error: Unknown column 'store_id' in 'where clause'
Error No: 1054
SELECT * FROM setting WHERE store_id = '0'

and this on the homepage

Error: Unknown column 'store_id' in 'where clause'
Error No: 1054
SELECT * FROM setting WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC

How to fix that

leewan wrote:I updated open cart 1.4.9.4 to this v1.5.0 RC2 and received this

on the admin page
Error: Unknown column 'store_id' in 'where clause'
Error No: 1054
SELECT * FROM setting WHERE store_id = '0'

and this on the homepage

Error: Unknown column 'store_id' in 'where clause'
Error No: 1054
SELECT * FROM setting WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC

How to fix that

davidbushnell wrote:Just ideas

JasonSGN wrote:I found small issue with Reward Points. Here are the steps to recreate:

1. Add an item to your shopping cart that uses Reward Points
2. Use Rewards Points towards the purchase of the item
3. Remove the item from your shopping cart (customer changes mind on purchase)
4. Add another item that does NOT use Rewards Points to your cart. The previous Reward Points you applied towards the previous item still appear in cart without offering any type of discount on the current item and no way to remove the wasted points.

Possible solution: Could you clear the Rewards Points when the cart is emptied?

you problem is your using a shared ssl certifacte.

you can not do this. even prestashop won't allow this. session can not be transferred over multiple domains.

opencartisalright wrote:

JasonSGN wrote:I found small issue with Reward Points. Here are the steps to recreate:

1. Add an item to your shopping cart that uses Reward Points
2. Use Rewards Points towards the purchase of the item
3. Remove the item from your shopping cart (customer changes mind on purchase)
4. Add another item that does NOT use Rewards Points to your cart. The previous Reward Points you applied towards the previous item still appear in cart without offering any type of discount on the current item and no way to remove the wasted points.

Possible solution: Could you clear the Rewards Points when the cart is emptied?

Confirmed.

opencartisalright wrote:

davidbushnell wrote:Just ideas

And great ideas they are, however they should go in the Feature Request thread. As this is a bug thread it should be solely for that purpose...reporting bugs with RC2.

davidbushnell wrote:Apologies. Is there a thread for this already set up? I don't think it will let me set this up.

Thanks.

Error: Invalid use of group function
Error No: 1111
SELECT op.product_id FROM oc_order_product op LEFT JOIN `oc_order` o ON (op.order_id = o.order_id) LEFT JOIN `oc_product` p ON (op.product_id = p.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE o.order_status_id > '0' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' GROUP BY op.product_id ORDER BY SUM(op.quantity) DESC LIMIT 4

SELECT op.product_id, SUM(op.quantity) as sum FROM oc_order_product op LEFT JOIN `oc_order` o ON (op.order_id = o.order_id) LEFT JOIN `oc_product` p ON (op.product_id = p.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE o.order_status_id > '0' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' GROUP BY op.product_id ORDER BY sum DESC LIMIT 4

davidbushnell wrote:Just a suggestion rather than a bug fix. If possible, an optional password might feature on Stage 6 of a Guest Checkout. After entering all their data a guest checkout could be given the option to register simply by choosing a password. Seen this on a few online shops. Thought it would be useful on here.

Checkout_1306320518210.png

JasonSGN wrote:I've run through most of the features in RC2 and Revision 314 and have been very happy with the results. A lot of the issues that have been mentioned are now fixed and work perfectly.

I did find one minor issue: I've updated both english.php files in /catalog/language/english/ and /admin/language/english so that the data_format_short is m/d/y but it it still displays as d/m/y when viewing a customer's rewards and transactions history on the catalog side. It displays the correctly in the admin area.