djmarkm Posted June 27, 2013 Share Posted June 27, 2013 (edited) Hi I'm struggling with a new shop having intermittent problems with the Paypal module. PrestaShop v 1.5.4.1 / PayPal 3.5.5 Single language (GB) Server information Server information: Linux #1 SMP Thu Sep 20 05:53:15 EDT 2012 x86_64 Server software version: Apache PHP version: 5.3.24 Memory limit: 128M Max execution time: 120 Symptoms Place order Select Paypal Payment Log in to Paypal, Choose Payment and click Confirm Paypal Successfully processes the payment and passes back to payment.php eg. http://<MyDOMAIN>/shop/modules/paypal/express_checkout/payment.php?token=EC-6YF88494EN957864W&PayerID=CSD49XPTY2XJ8 This then results in a 500 Internal server error with the following in the error logs [27-Jun-2013 15:15:44 Europe/London] PHP Fatal error: Uncaught exception 'PrestaShopException' with message 'Can't load Order state status' in /home/grpross/public_html/shop/classes/PaymentModule.php:145 Stack trace: #0 /home/grpross/public_html/shop/modules/paypal/paypal.php(1235): PaymentModuleCore->validateOrder(80, 0, 7.5, 'PayPal', NULL, Array, 1, false, '82b3e8e707db789...', Object(Shop)) #1 /home/grpross/public_html/shop/modules/paypal/express_checkout/payment.php(267): PayPal->validateOrder(80, NULL, 7.5, 'PayPal', NULL, Array, 1, false, '82b3e8e707db789...', Object(Shop)) #2 /home/grpross/public_html/shop/modules/paypal/express_checkout/payment.php(283): validateOrder(Object(Customer), Object(Cart), Object(PaypalExpressCheckout)) #3 {main} thrown in /home/grpross/public_html/shop/classes/PaymentModule.php on line 145 As the processing had been interupted the cart is not promoted to an order. Other Info I've tested this on Firefox, Opera, Chrome and IE9. Before each test I have cleared browser cache/history/files/cookies During last test. IE9 / Firefox /Opera all failed as above but my Chrome test was successful !?! Attempted Resolutions Shop is NOT in maintenance Mode Checked the pr_order_state table is populated Ensured all file permissions were set to 755 Removed Paypal module and reinstall & configure (3 times) (as recommended here http://www.prestasho...-empty-message/ ) Deleted contents of /cache/smarty/compile (grasping at straws!) I had thought I had resolved this yesterday by removing and reinstalling the paypal module as test orders briefly started to going through but it stopped working again within a few hours. I'm totally lost on this one Edited June 27, 2013 by djmarkm (see edit history) Link to comment Share on other sites More sharing options...
El Patron Posted June 27, 2013 Share Posted June 27, 2013 can you post a screen shot of back office-->Orders-->Statuses should looks something like this: http://screencast.com/t/Dc3upiqfVlm it's really sort of sucky, but the order status (ID'S) are hard coded into the modules and must match...you can use the previous screen shot for comparison 2 Link to comment Share on other sites More sharing options...
djmarkm Posted June 27, 2013 Author Share Posted June 27, 2013 Hi Thanks for the screenshot. My order statuses exactly matches yours except I have an additional item at the bottom Id : 13 Authorization accepted from Paypal Order status table would seem to be ok Link to comment Share on other sites More sharing options...
djmarkm Posted June 27, 2013 Author Share Posted June 27, 2013 Screenshot attached Link to comment Share on other sites More sharing options...
El Patron Posted June 27, 2013 Share Posted June 27, 2013 I apologize, I had not installed the 3.5.5 version of paypal...when installed, I like you have ID 13 AUTHORIZATION ACCEPTED FROM PAYPAL Sorry I'm not much help...I can't find anything 'searching' that matches your problem, well you can find them but they had to do with empty or incorrect order statues. I suggest you open a bug report on the PrestaShop forge. They are pretty good about addressing them espeically when like you, you document the problem. Here is the link: http://forge.prestashop.com/secure/Dashboard.jspa post your forge problem report here. Link to comment Share on other sites More sharing options...
djmarkm Posted June 28, 2013 Author Share Posted June 28, 2013 (edited) Thanks for your help. Pointing me to order statuses has helped me realise tt's definately an order status problem. I've mentioned before that the problem was intermittent. During my testing (live payments using my personal paypal account), although all the payments were successfull with paypal, express_checkout/payment.php would crash about 70%-80% of the time. I've now just realised that the only times that express_checkout/payment.php did not crash is when the payment went through with an order status of id:11 "AWAITING PAYPAL PAYMENT" I'm assuming therefore the orders that should have had a status of ID:13 AUTHORIZATION ACCEPTED FROM PAYPAL are the ones causing this problem. Which is great because I can now point the developers in the right direction! Edited June 28, 2013 by djmarkm (see edit history) 2 Link to comment Share on other sites More sharing options...
Marco Oliveira Posted June 28, 2013 Share Posted June 28, 2013 Hello. Have you tried to put in paypal modulo permitions 755 to the folders and 644 for the files? Link to comment Share on other sites More sharing options...
djmarkm Posted June 28, 2013 Author Share Posted June 28, 2013 Hi Marco, Thanks for your reply. I had already tried folders at 755/files at 644 & Folders & files at 755. No change It's not a file permissions problem as paypal orders with status of id:11 "AWAITING PAYPAL PAYMENT" succeed but orders that should have a status of ID:13 AUTHORIZATION ACCEPTED FROM PAYPAL cause paypal.php to fault. Link to comment Share on other sites More sharing options...
El Patron Posted June 28, 2013 Share Posted June 28, 2013 please make sure to post your forge bug report here so other can 'vote' on it and or follow it. hoping this gets resolved for you in short order. The last forge report I made was fixed in 4-5 days. When documented well and responded to when there area questions the ps development team can do wonders. 1 Link to comment Share on other sites More sharing options...
djmarkm Posted June 28, 2013 Author Share Posted June 28, 2013 Forge bug report is here :- http://forge.prestashop.com/browse/PNM-1529?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel 1 Link to comment Share on other sites More sharing options...
djmarkm Posted July 1, 2013 Author Share Posted July 1, 2013 Hi All, Thought I would post an update. This has been confirmed by François Gaillard as a bug in the Paypal module (3.5.5) it's due to an unknown return code from Paypal : "Completed_Funds_Held". It has now been resolved on my shop by Francois. A module update should be issued in a few days. Thanks for your help Mark Link to comment Share on other sites More sharing options...
El Patron Posted July 1, 2013 Share Posted July 1, 2013 Hi All, Thought I would post an update. This has been confirmed by François Gaillard as a bug in the Paypal module (3.5.5) it's due to an unknown return code from Paypal : "Completed_Funds_Held". It has now been resolved on my shop by Francois. A module update should be issued in a few days. Thanks for your help Mark That is great news Mark. Please post here when the bug report has been closed/fixed. 1 Link to comment Share on other sites More sharing options...
djmarkm Posted July 2, 2013 Author Share Posted July 2, 2013 The assigned developer, Francois Gaillard has now closed this report and updated it's resolution status as Fixed. Quote:- Francois Gaillard added a comment - 02/Jul/13 9:22 AM Thank you Mark, It has been fixed and will be available soon in a new release. Once again, thanks for the help! Link to comment Share on other sites More sharing options...
amerigeau Posted September 17, 2013 Share Posted September 17, 2013 Hi,I don't know but is this post http://forge.prestashop.com/browse/PNM-1711 linked to this one ? Thanks Link to comment Share on other sites More sharing options...
djmarkm Posted September 17, 2013 Author Share Posted September 17, 2013 Hi, I don't know but is this post http://forge.prestashop.com/browse/PNM-1711 linked to this one ? Thanks No that looks like a seperate issue.(also a different sersion of the module) Mark Link to comment Share on other sites More sharing options...
khejit68 Posted October 5, 2015 Share Posted October 5, 2015 (edited) I had this error when deleted some of statuses by my boss' request. I had to reinsert status nr 2 manually via phpMyAdmin, This is weird, because this statuses should not be possible to delete. @EDIT: If someone's curious: you can always set up example prestashop, and look up this statuses in ps_order_state and ps_order_state_lang tables. Copy by id_order_state. Edited October 6, 2015 by khejit68 (see edit history) 1 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