Here is the scenario,
Customer adds items to the cart,
Proceeds to checkout,
Goes through all the steps and accepts terms and conditions and clicks continue,
Reviews order and determines that they can spend more, then directly leaves the checkout process for Home or a Category, either by using the back button on the browser or a direct link.
Adds another item to the cart and proceeds to checkout,
Again goes through all the steps and clicks on continue,
Verifies the carts contents and totals, (at this point there is no indication in the cart that the items previous have been doubled)
Enters credit card info and clicks confirm.
Customer is taken to the success page.
Sounds normal right! Wrong, Looking at the sale (Sales>>Order), the items have been doubled from the previous checkout process. Mind you the customer did not enter any credit card information but did leave directly from a link or by using the back button. Either way the items get doubled. They do not get charged for the doubled items. But it is very annoying to see the invoice having double items. This happens in with stock checkout or custom checkout.
Is there a fix for this?
rjain wrote:i upgrade 1.5.4 to 1.5.5.1 but now when i use coupon and click on apply coupon then show error:
Notice: Undefined index: left in /home/xxxxx/public_html/catalog/model/checkout/coupon.php on line 60Notice: Undefined index: right in /home/xxxxx/public_html/catalog/model/checkout/coupon.php on line 60Notice: Error: Unknown column 'c.left' in 'where clause'
Error No: 1054
SELECT COUNT(*) AS total FROM `oc_product_to_category` p2c LEFT JOIN `oc_category` c ON (p2c.category_id = c.category_id) WHERE p2c.`product_id` = '147' AND c.`left` BETWEEN '0' AND '0' in /home/xxxxx/public_html/system/database/mysql.php on line 50
please tell me how to solve this problem.
cagbaazee wrote:Hi
I wanted to add a Coupon for a special promotion. When I select the Category and Save the Coupon. I test it but it display the error problem :
Notice: Undefined index: left in /home/sssssssscx/public_html/eshoppy.org/opencart/catalog/model/checkout/coupon.php on line 60Notice: Undefined index: right in /home/ssssssscx/public_html/eshoppy.org/opencart/catalog/model/checkout/coupon.php on line 60Notice: Error: Unknown column 'c.left' in 'where clause'
Error No: 1054
SELECT COUNT(*) AS total FROM `oc_product_to_category` p2c LEFT JOIN `oc_category` c ON (p2c.category_id = c.category_id) WHERE p2c.`product_id` = '10245' AND c.`left` BETWEEN '0' AND '0' in /home/rapbaycx/public_html/eshoppy.org/opencart/system/database/mysql.php on line 50
When i donot use categort, coupons is working fine, but it apply to all the items. whereas when i select the name of the products it works fine. Main Problem is when i want to select only special category , it donot works, ie example as above.
Is here problem with coupon bug.. but the way i am using version 1.5.5.1
Anyone please help it out.
Thanks
التعليمات باللغة العربية على الرابط التالي
https://www.opencartarab.com/docs
استضافة اوبن كارت العرب
https://host.opencartarab.com
Notice: Error: Unknown column 'special' in 'order clause'
Error No: 1054
SELECT p.product_id, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM product_to_category p2c LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '68' GROUP BY p.product_id ORDER BY (CASE WHEN special IS NOT NULL THEN special WHEN discount IS NOT NULL THEN discount ELSE p.price END) DESC, LCASE(pd.name) DESC LIMIT 0,15 in /usr/local/pem/vhosts/122175/webspace/httpdocs/fashioncreed.com/system/database/mysql.php on line 50
steps to regenerate the error in my site www.fashioncreed.com
step1: goto any category in men or women like tshirts
step2: select Sort By Price(Low>High)
Please let me know if I can provide more information and how I can help you help me.
edit* better description here http://forum.opencart.com/viewtopic.php?f=20&t=101991
And why is this NOT retaled to your custom theme?CayceGUW wrote:I'm not sure how to go about getting help with my issue or if it is even a bug, but in my site we have products and like to place 100% in the text where it matters. In the description if I do this it kicks me to the store front. I have a page located http://store.americanwaterservicesinc.c ... duct_id=56 that has a 100% in the description, but if I edit that description and keep the 100% in there it does not work any longer.
Please let me know if I can provide more information and how I can help you help me.
edit* better description here http://forum.opencart.com/viewtopic.php?f=20&t=101991
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
I have no such option.maturumarma wrote: step2: select Sort By Price(Low>High)
Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
i2Paq wrote:And why is this NOT retaled to your custom theme?CayceGUW wrote:I'm not sure how to go about getting help with my issue or if it is even a bug, but in my site we have products and like to place 100% in the text where it matters. In the description if I do this it kicks me to the store front. I have a page located http://store.americanwaterservicesinc.c ... duct_id=56 that has a 100% in the description, but if I edit that description and keep the 100% in there it does not work any longer.
Please let me know if I can provide more information and how I can help you help me.
edit* better description here http://forum.opencart.com/viewtopic.php?f=20&t=101991
Because I don't know how custom themes work for this system. I would love to say it is, but is there a way to test this... turning the custom theme off without losing all the current data within the system?
You want to thank me for my time! Click here to donate
Ok. It is already in the general support getting a bit of information, but no luck yet. Thanks for thinking about this problem.marvmen21 wrote:I think this topic should be moved to general support since it's not a bug. It might be template related. To test if you have issue with the default template, just go to settings and choose default. http://docs.opencart.com/display/openca ... A%3A+Store
Actually make this more fun... set it to default and it still doesn't work.. Can we really say it isn't a bug. Can someone else put 100% in a description for a product and tell me if they get the same thing or not?marvmen21 wrote:I think this topic should be moved to general support since it's not a bug. It might be template related. To test if you have issue with the default template, just go to settings and choose default. http://docs.opencart.com/display/openca ... A%3A+Store
Works fine with the '%' character in the latest CKEditor, see here for instructions on how to upgrade it.CayceGUW wrote: Actually make this more fun... set it to default and it still doesn't work.. Can we really say it isn't a bug. Can someone else put 100% in a description for a product and tell me if they get the same thing or not?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Actually I posted the other thread. I made mention of it within the first post... Like I said since the beginning I wasn't sure if it was a bug or not. That is why it is posted here.rph wrote:There's already a thread on this. It's not a bug and never should have been posted here.
JNeuhoff wrote:Works fine with the '%' character in the latest CKEditor, see here for instructions on how to upgrade it.CayceGUW wrote: Actually make this more fun... set it to default and it still doesn't work.. Can we really say it isn't a bug. Can someone else put 100% in a description for a product and tell me if they get the same thing or not?
followed these instructions and sadly did not work ...
To fix the issue, you can add code to have the cart clear itself out when someone logs in. Here is how to reproduce the issue:
When someone signs in, adds a product to their cart, and decides not to buy right then, their cart is saved to their login. When they come back, they may see an empty cart, and add the the product again as a guest. When they view the cart, it will be correct, and they will hit checkout, and login there, after they have already viewed their cart amounts.
Then opencart seems to merge the guest cart with the saved cart of last time they signed in, and they get double the amount of product.
That might be a bug actually? I know I would prefer the cart to not be saved, or at least notify them of the merge since they have already approved the amounts at that point.
rdvapors wrote:Hi this has been a problem from my first fresh install,
Here is the scenario,
Customer adds items to the cart,
Proceeds to checkout,
Goes through all the steps and accepts terms and conditions and clicks continue,
Reviews order and determines that they can spend more, then directly leaves the checkout process for Home or a Category, either by using the back button on the browser or a direct link.
Adds another item to the cart and proceeds to checkout,
Again goes through all the steps and clicks on continue,
Verifies the carts contents and totals, (at this point there is no indication in the cart that the items previous have been doubled)
Enters credit card info and clicks confirm.
Customer is taken to the success page.
Sounds normal right! Wrong, Looking at the sale (Sales>>Order), the items have been doubled from the previous checkout process. Mind you the customer did not enter any credit card information but did leave directly from a link or by using the back button. Either way the items get doubled. They do not get charged for the doubled items. But it is very annoying to see the invoice having double items. This happens in with stock checkout or custom checkout.
Is there a fix for this?
Does anyone else use auth.net with no issues? Or could this be a bug?
I have no clue how to trouble shoot this? Before I upgraded to 1.5.5.1, it was not a problem.
this is a feature called saved cart! stop complaining. this is how you think something should work! not a bug! if you want a custom cart pay for the coding yourself!joer80 wrote:I think there is a way to get the cart to double your item quantities, but I don't know that it is a bug. (It might be..)
To fix the issue, you can add code to have the cart clear itself out when someone logs in. Here is how to reproduce the issue:
When someone signs in, adds a product to their cart, and decides not to buy right then, their cart is saved to their login. When they come back, they may see an empty cart, and add the the product again as a guest. When they view the cart, it will be correct, and they will hit checkout, and login there, after they have already viewed their cart amounts.
Then opencart seems to merge the guest cart with the saved cart of last time they signed in, and they get double the amount of product.
That might be a bug actually? I know I would prefer the cart to not be saved, or at least notify them of the merge since they have already approved the amounts at that point.
Reason: [/quote] added
OpenCart®
Project Owner & Developer.
I do think it would be nice to have an option in the admin to use this saved cart feature though. That way people could uncheck it if they have problems with it.
Maybe even if the saved cart would only function if the guest cart was empty, that would be better. Or use one or the other instead of merging them silently.
Users browsing this forum: No registered users and 75 guests