fishingnet Posted October 25, 2012 Share Posted October 25, 2012 (edited) PLEASE HELP !!!!! As I wrote in title, customers receives invoices containing not ordered products ! Where I have wrong? I use 1.4.8.2 and i have about 2000 items in my store (FishingNet) Need urgently your help, please !!! Bogdan Sorry for my english Edited October 26, 2012 by fishingnet (see edit history) Link to comment Share on other sites More sharing options...
fishingnet Posted October 26, 2012 Author Share Posted October 26, 2012 Hello again ! I really need your help ! Because of this situation, i had to put my shop on maintenance page and i don't want this fact take long time. Pleeeease !!! Link to comment Share on other sites More sharing options...
fishingnet Posted October 26, 2012 Author Share Posted October 26, 2012 Nobody ? Link to comment Share on other sites More sharing options...
benjamin utterback Posted October 26, 2012 Share Posted October 26, 2012 Hello fishingnet, do you have any errors that you can see in your store? Have you turned error reporting on in /config/config.inc.php and turn Display Errors "On" ? 1 Link to comment Share on other sites More sharing options...
fishingnet Posted October 26, 2012 Author Share Posted October 26, 2012 (edited) Thank you Benjamin for your reply ! Yes i have turned on error reporting in my config.inc file. I have made again an order test, the result is the same, and no errors report. On my orders page (in my account) i see order details with an extra product wich i didn't ordered. Curiously, the extra product value, is not addicted to total price, but in my invoice the price is consisted by both values of the products, and is not correct. I don't understand where i did wrong ! Any idea ? I have attached the order details in my BO, for better understanding. Bogdan Edited October 26, 2012 by fishingnet (see edit history) Link to comment Share on other sites More sharing options...
tomerg3 Posted October 26, 2012 Share Posted October 26, 2012 Did you have test orders on the site before and deleted them? It looks like that was the case, and you did not delete them properly. If the table ps_order_detail has records for id_order which does not exist yet, it means that when you cleared the ps_orders table, you did not clear all the other related tables. 1 Link to comment Share on other sites More sharing options...
fishingnet Posted October 26, 2012 Author Share Posted October 26, 2012 Yes, i have made order tests before i activated the site (two weeks ago).. I deleted this orders using a free module named "delete orders v1.1 by RSI". It looks like the module is not functioning properly and doesn't delete the related tables? What should i do now ? Link to comment Share on other sites More sharing options...
tomerg3 Posted October 26, 2012 Share Posted October 26, 2012 1) Create a backup of your DB 2) Delete every record from any table that contains id_order column, when id_order is greater than 14 (or the current last order id that was placed). 3) Manually go through ps_order_detail and delete products that were not a part of the order (you can compare them to the carts from those orders,a s they will not have the extra products). 4) Contact RSI and let them know about this bug 2 Link to comment Share on other sites More sharing options...
fishingnet Posted October 26, 2012 Author Share Posted October 26, 2012 Ok ! I will do all of this things, and let you know Link to comment Share on other sites More sharing options...
fishingnet Posted October 26, 2012 Author Share Posted October 26, 2012 (edited) It works ! :D Many thanks ! You are a GOD !!!!!! I found in my database the products i used to make the order tests before i activated my shop. I have cleaned all entries containing these products in all tables that contains id_order column, also in all tables that starts with ps_cart. I have made again a new order test and all is functioning properly. These products are not shown in the order details and invoice. Now i will write to RSI for let him know about this bug. Thank you again ! Edited October 26, 2012 by fishingnet (see edit history) Link to comment Share on other sites More sharing options...
benjamin utterback Posted October 26, 2012 Share Posted October 26, 2012 Thank you Tomer for the expert support, I will mark this thread as solved and remember this suggestion for anybody who has similar problems. Class act. 1 Link to comment Share on other sites More sharing options...
DEJANC Posted November 21, 2012 Share Posted November 21, 2012 Hi, I have same problem like fishingnet. Can someone detailed explaine me which tables to delete and where, because I dont want to mess something. Solution from tomerg3. Link to comment Share on other sites More sharing options...
fishingnet Posted November 21, 2012 Author Share Posted November 21, 2012 Hello ! First of all, please apologize for my english ! Let's start: - Backup your database. - in your phpMyAdmin, select your database. - in your left column, select the table named ps_order_detail. - on the right side of the screen appears a sum of information about orders placed in your store. - in the column with product names, identify the products witch are added to the invoices, and are not ordered. - in the column named id_order you find a number that corresponds with this products. Remember this numbers. - Delete the rows containing this numbers. - Then, go to left column again and select one by one, all tables starting with ps_order, includind the first one named ps_orders. - In these tables, repeat the steps i mentioned before. Then, be sure that you did not installed before, a wrong module for deleting orders. You are done ! I hope this will solve your problem. It worked for me ! 2 Link to comment Share on other sites More sharing options...
Recommended Posts