ariopp Posted June 6, 2009 Share Posted June 6, 2009 Hi,Randomly, my products are now not showing anymore.I did not edit any code or anything.I simply made a test order, and now, when I click on any product, it comes out blank on the right side of my screen.Any idea why it is not working? Link to comment Share on other sites More sharing options...
ariopp Posted June 6, 2009 Author Share Posted June 6, 2009 I just emulated the problem:I did a checkout, with PICKUP delivery option and CASH ON DELIVERY payment option, and that is when the products stopped showing.PLEASE can someone try the same and let me know if it does the same thing to themAnd if it does, can anyone work out how to fix it?Thanks! Link to comment Share on other sites More sharing options...
ariopp Posted June 7, 2009 Author Share Posted June 7, 2009 Just found where the problem lies…It is not only caused by the cash on delivery module.Rather, when ever the progress of an order is changed to “preparation in progress”, it adds a row to the MYSQL table called “ps_product_sale”.Once that row has been added, no products will show anymore.If I manually delete that row, it works fine, but obviously I can’t manually delete it after EVERY sale, and I’m sure it is meant to be there for some reason?Please help to solve this Link to comment Share on other sites More sharing options...
Recommended Posts