ziggy Posted February 16, 2010 Share Posted February 16, 2010 Hi need some advicei have recently updated and found a problem....i inserted my old db into the new installation upon completion of installation ..as you do..only to find that when a pre-existing customer places a new order the only record that i have to this order is the paypal email i receive, (it does not show in the orders panel, no emails received).I then have to click into the customer tab find the customer who ordered, click into details and find the order in the orders window, (see img 1)if i then click the order it shows me the order details with a payment set to awaiting bank wire transfer, also in the order summary the product detail is 0.00 and only the shipping shows along with the total..(see img 2)further down the the order page in the product summary box no summary details appear...(see Img 3).if it is a new customer creating a new account etc it works as it should, product updated, emails received etc..any advice would be appreciated.. Thanks...hope i have provided concise and clear documentation to this problem... Link to comment Share on other sites More sharing options...
ziggy Posted February 16, 2010 Author Share Posted February 16, 2010 what's the point of a forum if nobody moderates or at least trys to help...maybe prestashop should rename this to a bulletin boardand we could all charge for being software testers... Link to comment Share on other sites More sharing options...
Radu Posted February 17, 2010 Share Posted February 17, 2010 I have not came across the same problem sorry. The help here is offered for free - in my case I just don't have the time overwritting a new installation with an old database (I don't even know what presta version did you had before and after) and then check what happens.So in my opinion help will come if someone is familiar with your problem.Till then what was the version of the prestashop for your old database? and what's the version of your new prestashop? Link to comment Share on other sites More sharing options...
ziggy Posted February 19, 2010 Author Share Posted February 19, 2010 Original install Version 1.1.x upgraded to 1.2.5 Link to comment Share on other sites More sharing options...
L. Brett Sinclair Posted February 19, 2010 Share Posted February 19, 2010 Ziggy, I hear you...but they do a "great" job moving a post submitted on the wrong forum and letting you know about it.I had all kind of problem upgrading from 1.1 to 1.2.5.- check the languages to see if you are missing some files. - if you overwrote the "mails" put the defaults one first, then overwrite them 1 by 1 and test.- I tried to check the difference between my DB and a "new" default prestashop DB: I'm still waiting for an answer on that post.- I had phantom order from Paypals (they were recorded on paypal, not presta): I deleted everything and recreated my setup in prestashop and paypal...it seems OK BUT you must keep "Consider the associated order as validated" for the status "Payment accepted"...hope that will help Link to comment Share on other sites More sharing options...
ziggy Posted February 23, 2010 Author Share Posted February 23, 2010 your right about that...its like stealth moderation...now all my orders arrive as awaiting bank payment.. and i cant view the order at all .. this is frustrating and annoying..... Link to comment Share on other sites More sharing options...
ziggy Posted February 23, 2010 Author Share Posted February 23, 2010 after some investigation ... prestashop is not writing to the ps_order_detail Table.... Link to comment Share on other sites More sharing options...
L. Brett Sinclair Posted February 23, 2010 Share Posted February 23, 2010 try to change you invoice statuses.maybe try remove the payment module you are using, ftp back the directory to your site, re-install it. Link to comment Share on other sites More sharing options...
harial Posted February 24, 2010 Share Posted February 24, 2010 Did you find out how to solve this problem? I have a similar problem though mine is not exactly the same. Link to comment Share on other sites More sharing options...
ziggy Posted February 25, 2010 Author Share Posted February 25, 2010 hi i think i did but i need more testing with live orders ...i just uninstalled the bank wire module in the payments module section.... and my test orders worked o.kbut will need to verify with real orders....to fix the cms for orders that have come through and show no detail i.e picture 3 you need to manually update the order_detail table in the db via Navicat etc.. some of the information you need will be found in the orders ps_Orders table i.e id_cart etc Hope that helps for now ... as i said before not sure if its fixed permanently...time will tell....let me know how you get on with testing this fix Link to comment Share on other sites More sharing options...
L. Brett Sinclair Posted February 25, 2010 Share Posted February 25, 2010 Ziggy, it seems consistent with me , except it was with Paypal. Once I uninstalled and re-installed and re-did the setup, it seems to work fine. Link to comment Share on other sites More sharing options...
ziggy Posted February 25, 2010 Author Share Posted February 25, 2010 did you have the same problem as me... Link to comment Share on other sites More sharing options...
L. Brett Sinclair Posted February 25, 2010 Share Posted February 25, 2010 yes, kind of : phantom orders...meaning I could seem them n my Paypal account, but nothing in Presta. Link to comment Share on other sites More sharing options...
ziggy Posted February 25, 2010 Author Share Posted February 25, 2010 and are your new test orders showing correctly.... Link to comment Share on other sites More sharing options...
ziggy Posted March 5, 2010 Author Share Posted March 5, 2010 i already have this column in my order_detail table... please see image Link to comment Share on other sites More sharing options...
muktadir Posted March 16, 2010 Share Posted March 16, 2010 so...any one else with anything else for the solution? Link to comment Share on other sites More sharing options...
eknepfler Posted March 20, 2010 Share Posted March 20, 2010 I'm having same problem with a fresh 1.2.5.0 install.Just tried a simple Paypal order and when returning to the site, it says there's no orders in the history.Validation URL is fine. Permissions are checked and fine. Link to comment Share on other sites More sharing options...
muktadir Posted March 20, 2010 Share Posted March 20, 2010 is the cart having the order? are you using paypal IPN? Link to comment Share on other sites More sharing options...
eknepfler Posted March 20, 2010 Share Posted March 20, 2010 After returning from Paypal, the order is still in the cart. I tried with and without Paypal IPN and it doesn't make any difference, though I think maybe with IPN enabled the order would disappear from the cart afterward. However, either way it doesn't show up in the backoffice orders history so it doesn't matter.I have actually resorted to editing the order-confirmation.php redirects to point to a CMS page explaining that the Prestashop paypal interface is broken and that they should not expect to see the orders show up in their history. Sad. Link to comment Share on other sites More sharing options...
muktadir Posted March 22, 2010 Share Posted March 22, 2010 I have also got reports on broken paypal. The prestashop team didn't reveal its internal mechanism. So it's hard to read the code and work out where the problem is. So we have to wait until they fix it. Link to comment Share on other sites More sharing options...
eknepfler Posted March 22, 2010 Share Posted March 22, 2010 Drag. I'd be willing to do the debugging but Paypal is so screwed up right now I can't even get a Sandbox account working again. Some known problem or something that they haven't fixed yet.Thanks for the reply and I'll be monitoring this thread Link to comment Share on other sites More sharing options...
muktadir Posted March 22, 2010 Share Posted March 22, 2010 you can search the bug tracker. I just don't understand why they are not revealing some of their architecture. It's really hard to debug prestashop. Link to comment Share on other sites More sharing options...
ziggy Posted April 14, 2010 Author Share Posted April 14, 2010 Just an update on this error ....it only occurs for me when a customer orders the last item in stock.. if i have 2 in stock and the customer orders one i have no problem what so ever....Hope this helps to resolve the issue ... obviously a db problem... Link to comment Share on other sites More sharing options...
natasha80 Posted April 16, 2010 Share Posted April 16, 2010 i tried to update from 1.1 to 1.2.5 an it was nightmare. so many problem. cart not working, all clients DB list gone, orders list gone, so many things out of place that i quited, i went back to older version, thank god i did a backup first.... 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