amnesiak Posted December 16, 2011 Share Posted December 16, 2011 Hi, I have a weird problem. Sometimes when order is made a non ordered product is added to new order. When I look to BO in my orders, when I look at original basket the order shows correctly (that is how I know what costumer really ordered). The order confirmation mail send to costumer shows the correct price calculation (what was actually ordered), but the non ordered product is also shown among those ordered products. I noticed that sometimes if product is deleted from basket and then the checkout is made the product that was deleted also shows in new order. I`m using ver 1.4.4.1. I also have ajax function enabled in basket modul. I˙m not really sure what is causing the problem. Any suggestions? Link to comment Share on other sites More sharing options...
Carl Favre Posted December 16, 2011 Share Posted December 16, 2011 Hello amnesiak, Are you using the default PrestaShop theme or a custom one? Link to comment Share on other sites More sharing options...
amnesiak Posted December 16, 2011 Author Share Posted December 16, 2011 I`m using default theme. my site www.sesalec.net edit: I added the code to show old price under the new one in homefeatured and products.list. but I don`t think thats the case, because the problems showed up recently. I˙m also getting this: a mulitiple statuses added when order is made, but could not be related as in this case the ordered products were ok. Link to comment Share on other sites More sharing options...
tomerg3 Posted December 16, 2011 Share Posted December 16, 2011 Did you make any other changes? Did you manually delete orders from the shop at some point? Can you post an image of an order (BO) and of the matching Cart for that order? Link to comment Share on other sites More sharing options...
amnesiak Posted December 16, 2011 Author Share Posted December 16, 2011 1. I have installed module shiptopay which adds some new files in override folder. (but when this module is disabled and old override folder is backuped the problem with random products was still there). I then reset modules bankwire, cash on delivery and ship to pay and then it works ok for some time. 2. Yes I manually delete my test orders changing vieworder with "deleteorder" in my internet browser. 3. In this image the first product is a "ghost" product that shouldn`t be there. The price is calculated right. Link to comment Share on other sites More sharing options...
tomerg3 Posted December 16, 2011 Share Posted December 16, 2011 #2 is most likely the culprit, as it probably left old product info in one of the database tables, and now new orders (with the same order ID as the deleted orders) have those old products assigned to them. There are a few ways to handle this, it really depends on how many orders you had deleted Link to comment Share on other sites More sharing options...
amnesiak Posted December 16, 2011 Author Share Posted December 16, 2011 I have deleted more than 100 orders. Link to comment Share on other sites More sharing options...
tomerg3 Posted December 16, 2011 Share Posted December 16, 2011 First off, make a backup of your database. Then, check what is the highest id_order number in ps_orders. Then check if there are any records in ps_order_detail with an id_order that is greater the the last on in ps_orders. If you find any, delete them. You can then manually delete the extra products for the existing orders from that table 1 Link to comment Share on other sites More sharing options...
amnesiak Posted December 16, 2011 Author Share Posted December 16, 2011 Ok thanks for helping me out. The highest id_orders is 197 and the highest id_order_detail is 223 So I delete id_order_detail from 223 to 198 Link to comment Share on other sites More sharing options...
tomerg3 Posted December 16, 2011 Share Posted December 16, 2011 Yes, do that, which would affect new orders, and you will have to manually delete product for older orders Don't forget to keep a backup! Link to comment Share on other sites More sharing options...
amnesiak Posted December 16, 2011 Author Share Posted December 16, 2011 "Yes, do that, which would affect new orders, and you will have to manually delete product for older orders" You mean in BO in orders, will this effect the order price? Link to comment Share on other sites More sharing options...
tomerg3 Posted December 16, 2011 Share Posted December 16, 2011 I don't think it will, it will just remove the extra products that were not really a part of the order Link to comment Share on other sites More sharing options...
amnesiak Posted December 16, 2011 Author Share Posted December 16, 2011 I delete id_order detail to 198, but now it does not show ordered products at some orders, the price is still there. The products are gone for last 4 orders, but I can live with that if it will work from now on. The original basket still show the products. Link to comment Share on other sites More sharing options...
tomerg3 Posted December 16, 2011 Share Posted December 16, 2011 you can always restore and try again, maybe you accidentally delete them,, Link to comment Share on other sites More sharing options...
amnesiak Posted December 16, 2011 Author Share Posted December 16, 2011 when restoring database, I should delete current one and then import the backup databse? Link to comment Share on other sites More sharing options...
tomerg3 Posted December 16, 2011 Share Posted December 16, 2011 I don't know how you made the backup, so I can't tell you how to restore it. Do not delete the current table, rename it instead... Link to comment Share on other sites More sharing options...
amnesiak Posted December 16, 2011 Author Share Posted December 16, 2011 I used this instructions. I created new database, but when I try importing it I get this error. Link to comment Share on other sites More sharing options...
tomerg3 Posted December 16, 2011 Share Posted December 16, 2011 You need to select the database you want to restore to. Link to comment Share on other sites More sharing options...
amnesiak Posted December 16, 2011 Author Share Posted December 16, 2011 Now I get this error: Module shiptopay uses latin1_swedish_ci. All other tables use uf8 How to resolve this? Link to comment Share on other sites More sharing options...
tomerg3 Posted December 16, 2011 Share Posted December 16, 2011 The error in the image is access denied. If you are not familiar with a database, you should probably find a developer / sysadmin to help you out. Link to comment Share on other sites More sharing options...
amnesiak Posted December 16, 2011 Author Share Posted December 16, 2011 What does it mean access denied? I dont know enyone who can help me out, I really appreciate your help. Why can`t I import the database? Link to comment Share on other sites More sharing options...
tomerg3 Posted December 16, 2011 Share Posted December 16, 2011 I don't know, maybe someone changed the permissions, try asking your host, as that is a server level permissions Link to comment Share on other sites More sharing options...
Famke Posted June 30, 2021 Share Posted June 30, 2021 I have something similar. But the difference is very big in my database: id_order is 2411, id_order_detail is 10384. Maybe it's because it started with order references like QRJHEKGOE and at some point I changed to numbers, but still it's only since yesterday I got this problem. It's like he add's or repeats old orders, inclusive the note/message Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now