goctan Posted November 12, 2015 Share Posted November 12, 2015 Hello everyone,When a customer orders everything goes perfectly,except that there is no record about the details (purchased products, ...). It's like Prestashop no longer wrote in the ps_order_detail table ...I'm on PrestaShop 1.6.1.1 Link to comment Share on other sites More sharing options...
El Patron Posted November 12, 2015 Share Posted November 12, 2015 Hi, this is 'almost' always a result of invalid 'order status', see back office-->orders-->statuses I would recreate the issue with PrestaShop debug mode enabled, then you should see php error at order completion. This will give you a lot more information that you have now and possible you can find existing solution. Link to comment Share on other sites More sharing options...
goctan Posted November 12, 2015 Author Share Posted November 12, 2015 Really fast response! I tried but no error messages, and I can see the order validated in the BO. The order appears in the "ps_order" table too. I found this message in the log tab >>> "No cart- Error : Validate cart -> Ref carte: 10172 |Rslt Mac : O |CIC : PAY-OK of : 0.15" Link to comment Share on other sites More sharing options...
El Patron Posted November 12, 2015 Share Posted November 12, 2015 holy moly, in all honesty I don't have a clue....but I'm happy to stick with you and apologize in advance for playing 20 questions. so the order 'is' recorded but not the detail of the order, i.e. product list, correct? what is the payment method? Link to comment Share on other sites More sharing options...
goctan Posted November 12, 2015 Author Share Posted November 12, 2015 (edited) Yes that's right. I use a Credit Card module and the Bankwire module (which finish orders on a 505 page ...) Edited November 12, 2015 by goctan (see edit history) Link to comment Share on other sites More sharing options...
goctan Posted November 13, 2015 Author Share Posted November 13, 2015 Nobody can help me :/ ? Link to comment Share on other sites More sharing options...
goctan Posted November 13, 2015 Author Share Posted November 13, 2015 (edited) So I tried to : - enable debug mode - disable every caches - update to Prestashop 1.6.1.2 - activate just native modules - activate the default template Nothing works ... nothing in the order_details table ... I think it's my database which has a problem, but where... Edited November 13, 2015 by goctan (see edit history) Link to comment Share on other sites More sharing options...
El Patron Posted November 13, 2015 Share Posted November 13, 2015 Nobody can help me :/ ? your response 'i use a credit card module' fell on deaf ears. We can't search for similar issue on that information. when posting think what would I need to know to help? also if you feel the need to 'bump', then revisit your post and look at it from perspective of community member, i.e. what detail would help... Link to comment Share on other sites More sharing options...
goctan Posted November 13, 2015 Author Share Posted November 13, 2015 I try to give all the informations I have, but I do not even know where the problem may come, so I don't know what to say. I think I will have to find by myself, thank you for trying. Link to comment Share on other sites More sharing options...
El Patron Posted November 13, 2015 Share Posted November 13, 2015 what is 'name' of your payment module? Link to comment Share on other sites More sharing options...
goctan Posted November 13, 2015 Author Share Posted November 13, 2015 "Crédit Mutuel - CIC Payment", But I have the same problem with the BankWire module. Link to comment Share on other sites More sharing options...
El Patron Posted November 13, 2015 Share Posted November 13, 2015 when did this start? after an upgrade? or are you just starting out with 1.6.1.1? what is the error message from bankwire? Link to comment Share on other sites More sharing options...
goctan Posted November 14, 2015 Author Share Posted November 14, 2015 (edited) Ok sorry. I start from the beginning. I had a shop on Prestashop 1.4, that I upgraded to 1.6 with the 1-click-upgrade module (juste to have the good number of columns in the tables of the database) Then I exported all the tables (of the upgraded Prestashop) relevant to the orders and customers with this PHP code : <?php system("mysqldump --host=databasename.mysql.db --user=xxxxxxxxxxxx --password=xxxxxxxxxxxx --default-character-set=utf8 --no-create-db --opt --tables databasename ps_access ps_address ps_cart ps_cart_product ps_cmcic_reference ps_customer ps_customer_group ps_orders ps_order_carrier ps_order_detail ps_order_detail_tax ps_order_history ps_order_invoice ps_order_invoice_payment ps_order_payment -r databasename.sql"); ?> and after installing a clean version of Prestashop 1.6.1.1, I imported the .sql in phpmyadmin. No errors. But now I have tryed to buy with the bankwire module (to test), I have this error (attached file): [PrestaShopDatabaseException] Unknown column 'original_wholesale_price' in 'field list' So now I'm pretty sure that the problem comes from my database, I think Prestashop can't write in the table order_details ... Edited November 14, 2015 by goctan (see edit history) 1 Link to comment Share on other sites More sharing options...
goctan Posted November 14, 2015 Author Share Posted November 14, 2015 (edited) Indeed, this column dind't exist in my database, I don't know why. I added the column original_wholesale_price in the order_details table and it would seem to work... Problem solved. Thank you El Patron for trying! Edited November 14, 2015 by goctan (see edit history) 1 Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
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