dj sunny omkar Posted June 7, 2011 Share Posted June 7, 2011 after the customers orders i am not able to see what they have ordered for .the products for which the customer have ordered is not showing up can some help with this. i think it is a Db related issues please explain with steps to resolve this problem. i am not very good with DB but can manage to follow the instructions .I have attached the picture that will explain the problem better. Link to comment Share on other sites More sharing options...
PrestaDesigner.com Posted June 8, 2011 Share Posted June 8, 2011 Hello,You didn't mentioned anything about prestashop (what version it is). Also what changes you have made (i.e - installing modules, update prestashop) before facing this issues? Link to comment Share on other sites More sharing options...
shokinro Posted June 8, 2011 Share Posted June 8, 2011 please checkout this thread, hope you can find some clues.http://www.prestashop.com/forums/viewthread/74250/ Link to comment Share on other sites More sharing options...
muratssu Posted June 14, 2011 Share Posted June 14, 2011 Yes this a big problem of mine too..I use Version 1.4.2 and it doesnt show order details...If there is anyone who has an idea please help...thx Link to comment Share on other sites More sharing options...
olea Posted June 14, 2011 Share Posted June 14, 2011 Have you upgraded from 1.2 or 1.3 ? Link to comment Share on other sites More sharing options...
muratssu Posted June 14, 2011 Share Posted June 14, 2011 Hello;I have upgraded from 1.2.5 to 1.4.2 with Rocky.I am suspicious about the COD with fee module too. Because it only appears during the cash on delivery type orders. and not all the time. only sometimes.Do you have any experience?thanks Link to comment Share on other sites More sharing options...
olea Posted June 14, 2011 Share Posted June 14, 2011 Yes, we have fixed such issue as of today.It was linked to the mailalert module.In 1.2, when a customer registers to be notify when a product is available again, there is no check that his email is valid (well formatted)After upgrade into 1.4, each time this product stock is modified, hooks try to send email notification to each customer being registered to this product.But it may be stucked due to invalid email.Check the emails format in table ps_mailalert_customer_oos and remove all incorrect ones Link to comment Share on other sites More sharing options...
muratssu Posted June 14, 2011 Share Posted June 14, 2011 Thanks for your feedback. I am not sure if the "order details not showing" is related to mailalert module but i want to try.Can you describe me how 2 do it? where is this ps_mailalert_customer_oos exactly?thanks Link to comment Share on other sites More sharing options...
olea Posted June 14, 2011 Share Posted June 14, 2011 Yes, in our case, it was linked to the mailalert module.While validating an order, the content of the cart is set into the order_detail table. But the loop over the cart product may be stopped due to an incorrect mailsent, and order_detail is empty.To check your table, you have to use phpMyAdmin and go to the given table Link to comment Share on other sites More sharing options...
muratssu Posted June 15, 2011 Share Posted June 15, 2011 Hello Olea;Rocky and i did what you have suggested. We will see if it works.If sth is wrong , i will write back from here. If i dont write, it means no errors occured.Thank you indeed for your help.Murat Link to comment Share on other sites More sharing options...
olea Posted June 15, 2011 Share Posted June 15, 2011 Have you seen incorrect emails in this table ? Link to comment Share on other sites More sharing options...
muratssu Posted June 15, 2011 Share Posted June 15, 2011 There were 4 emails there and 1 of them was wrong. Link to comment Share on other sites More sharing options...
olea Posted June 15, 2011 Share Posted June 15, 2011 For information :http://forge.prestashop.com/browse/PSCFI-2278 Link to comment Share on other sites More sharing options...
Recommended Posts