Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Page 1 of 2
PayPal not working - Magento 1.7.0.1 [BUG]
 
MageClub
Guru
 
Avatar
Total Posts:  386
Joined:  2009-07-25
India
 

Just installed and did the whole site with Magento 1.7.0.1

Now, everything is set, 500 products, all images, pages, everything is set.

And then when we tested the Paypal payment order, its not working.

Shows this error. See attached.

So, how do we go about fixing this whole issue ?

If I do the order with Purchase Order, it works and saves fine. But Paypal standard or Express, both not working..

And I had the log enabled and I found this in the exception.log

2012-06-22T06:01:33+00:00 ERR (3): 
exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '13-4' for key 2' in /home/demolink/public_html/clients.demolink.biz/ubj/lib/Zend/Db/Statement/Pdo.php:228
Stack trace
:
#0 /home/demolink/public_html/clients.demolink.biz/ubj/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /home/demolink/public_html/clients.demolink.biz/ubj/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 /home/demolink/public_html/clients.demolink.biz/ubj/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 /home/demolink/public_html/clients.demolink.biz/ubj/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#4 /home/demolink/public_html/clients.demolink.biz/ubj/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `ma...', Array)
#5 /home/demolink/public_html/clients.demolink.biz/ubj/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `ma...', Array)
#6 /home/demolink/public_html/clients.demolink.biz/ubj/lib/Zend/Db/Adapter/Abstract.php(574): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `ma...', Array)
#7 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(453): Zend_Db_Adapter_Abstract->insert('mage_sales_orde...', Array)
#8 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Object(Mage_Tax_Model_Sales_Order_Tax_Item))
#9 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Tax/Model/Observer.php(144): Mage_Core_Model_Abstract->save()
#10 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Core/Model/App.php(1338): Mage_Tax_Model_Observer->salesEventOrderAfterSave(Object(Varien_Event_Observer))
#11 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Tax_Model_Observer), 'salesEventOrder...', Object(Varien_Event_Observer))
#12 /home/demolink/public_html/clients.demolink.biz/ubj/app/Mage.php(447): Mage_Core_Model_App->dispatchEvent('sales_order_sav...', Array)
#13 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Core/Model/Abstract.php(466): Mage::dispatchEvent('sales_order_sav...', Array)
#14 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Sales/Model/Abstract.php(53): Mage_Core_Model_Abstract->_afterSave()
#15 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Sales/Model/Order.php(2155): Mage_Sales_Model_Abstract->_afterSave()
#16 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Core/Model/Abstract.php(319): Mage_Sales_Model_Order->_afterSave()
#17 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Core/Model/Resource/Transaction.php(151): Mage_Core_Model_Abstract->save()
#18 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Sales/Model/Service/Quote.php(189): Mage_Core_Model_Resource_Transaction->save()
#19 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Sales/Model/Service/Quote.php(249): Mage_Sales_Model_Service_Quote->submitOrder()
#20 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Checkout/Model/Type/Onepage.php(774): Mage_Sales_Model_Service_Quote->submitAll()
#21 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Checkout/controllers/OnepageController.php(511): Mage_Checkout_Model_Type_Onepage->saveOrder()
#22 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Checkout_OnepageController->saveOrderAction()
#23 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('saveOrder')
#24 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#25 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#26 /home/demolink/public_html/clients.demolink.biz/ubj/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#27 /home/demolink/public_html/clients.demolink.biz/ubj/index.php(87): Mage::run('', 'store')
#28 {main}

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '13-4' for key 2' in /home/demolink/public_html/clients.demolink.biz/ubj/lib/Zend/Db/Statement/Pdo.php:234
Stack trace
:
#0 /home/demolink/public_html/clients.demolink.biz/ubj/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/demolink/public_html/clients.demolink.biz/ubj/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/demolink/public_html/clients.demolink.biz/ubj/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /home/demolink/public_html/clients.demolink.biz/ubj/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `ma...', Array)
#4 /home/demolink/public_html/clients.demolink.biz/ubj/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `ma...', Array)
#5 /home/demolink/public_html/clients.demolink.biz/ubj/lib/Zend/Db/Adapter/Abstract.php(574): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `ma...', Array)
#6 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(453): Zend_Db_Adapter_Abstract->insert('mage_sales_orde...', Array)
#7 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Object(Mage_Tax_Model_Sales_Order_Tax_Item))
#8 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Tax/Model/Observer.php(144): Mage_Core_Model_Abstract->save()
#9 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Core/Model/App.php(1338): Mage_Tax_Model_Observer->salesEventOrderAfterSave(Object(Varien_Event_Observer))
#10 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Core/Model/App.php(1317): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Tax_Model_Observer), 'salesEventOrder...', Object(Varien_Event_Observer))
#11 /home/demolink/public_html/clients.demolink.biz/ubj/app/Mage.php(447): Mage_Core_Model_App->dispatchEvent('sales_order_sav...', Array)
#12 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Core/Model/Abstract.php(466): Mage::dispatchEvent('sales_order_sav...', Array)
#13 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Sales/Model/Abstract.php(53): Mage_Core_Model_Abstract->_afterSave()
#14 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Sales/Model/Order.php(2155): Mage_Sales_Model_Abstract->_afterSave()
#15 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Core/Model/Abstract.php(319): Mage_Sales_Model_Order->_afterSave()
#16 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Core/Model/Resource/Transaction.php(151): Mage_Core_Model_Abstract->save()
#17 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Sales/Model/Service/Quote.php(189): Mage_Core_Model_Resource_Transaction->save()
#18 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Sales/Model/Service/Quote.php(249): Mage_Sales_Model_Service_Quote->submitOrder()
#19 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Checkout/Model/Type/Onepage.php(774): Mage_Sales_Model_Service_Quote->submitAll()
#20 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Checkout/controllers/OnepageController.php(511): Mage_Checkout_Model_Type_Onepage->saveOrder()
#21 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Checkout_OnepageController->saveOrderAction()
#22 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('saveOrder')
#23 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#24 /home/demolink/public_html/clients.demolink.biz/ubj/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#25 /home/demolink/public_html/clients.demolink.biz/ubj/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#26 /home/demolink/public_html/clients.demolink.biz/ubj/index.php(87): Mage::run('', 'store')
#27 {main}
Image Attachments
UBJbug5.1.jpg
 
Magento Community Magento Community
Magento Community
Magento Community
 
MageClub
Guru
 
Avatar
Total Posts:  386
Joined:  2009-07-25
India
 

Anyone ??

Anyone ?

 
Magento Community Magento Community
Magento Community
Magento Community
 
UKWorkStore
Jr. Member
 
Avatar
Total Posts:  13
Joined:  2012-03-31
London, United Kingdom
 

Hello

We successfully upgraded to 1.7.01 2 days ago.

PayPal continues to work fine on our site, so possibly not a bug with the actual upgrade.

Sorry I can’t be more help than that.

Regards

Brian

 
Magento Community Magento Community
Magento Community
Magento Community
 
BruceZ
Jr. Member
 
Avatar
Total Posts:  2
Joined:  2011-09-27
 

Hi All,

I met this issue either.
I enabled `Website Payments Standard` at back-end and do settings as in the attachment.
But the payment is not shown on front-end.

Image Attachments
20120625002038.png
 
Magento Community Magento Community
Magento Community
Magento Community
 
MageClub
Guru
 
Avatar
Total Posts:  386
Joined:  2009-07-25
India
 

For us, the payment gateway shows fine and works fine.
But the payment is not saved to database, so the order is not placed and thus the error.

I have already pasted the error above.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Magento Support
Jr. Member
 
Total Posts:  22
Joined:  2010-07-23
 

Please check your Vendor details in admin.  As per your attached screenshot, this error occur due to wrong paypal setting on your module.

NOTE: Also try on Sandbox/developer details.

 
Magento Community Magento Community
Magento Community
Magento Community
 
mengqing
Jr. Member
 
Total Posts:  10
Joined:  2011-09-12
 

Paypal not working for us as well, not showing on the frontend.

Reverted back to 1.7.0.0 and it is working

 
Magento Community Magento Community
Magento Community
Magento Community
 
Blacknight
Jr. Member
 
Avatar
Total Posts:  18
Joined:  2008-05-27
CALAIS
 

paypal don’t work on his version

delete app\code\core\Mage\paypal folder and upload old version paypal (paypal 1.7.0.0 work fine with magento 1.7.0.1)

delete cache files and enjoy !!

 
Magento Community Magento Community
Magento Community
Magento Community
 
tonecj
Jr. Member
 
Avatar
Total Posts:  12
Joined:  2011-09-22
 

Having the same problem too, has anyone successfully used the roll back feature? Or is there a way to downgrade to 1.7 through the Magento Connect Manager?

 
Magento Community Magento Community
Magento Community
Magento Community
 
mattdev_nz
Jr. Member
 
Avatar
Total Posts:  27
Joined:  2010-06-21
New Zealand
 

I have just been caught out and implemented exactly what Black Knight did with success
Tested with a live Paypal account and it works
This is for 1.7.0.1

 
Magento Community Magento Community
Magento Community
Magento Community
 
tonecj
Jr. Member
 
Avatar
Total Posts:  12
Joined:  2011-09-22
 

Black Night, thank you in a very big way, that worked!

 
Magento Community Magento Community
Magento Community
Magento Community
 
César Gómez
Jr. Member
 
Avatar
Total Posts:  7
Joined:  2008-12-29
Madrid
 
mengqing - 24 June 2012 07:33 PM

Paypal not working for us as well, not showing on the frontend.

Reverted back to 1.7.0.0 and it is working

I’ve the same issue but if change country to uk in PayPal config the PayPal option is showing fine on the fronted.

I don’t know why the country is a problem…

 
Magento Community Magento Community
Magento Community
Magento Community
 
Magento Support
Jr. Member
 
Total Posts:  22
Joined:  2010-07-23
 

Paypal Express Checkout: Most of paypal issues generating due magento upgrade version.

Files held: /app/code/core/Mage/Paypal/Model/Express/

problem in :  public function getCheckoutMethod()

Please refer this thread:

http://www.magentocommerce.com/boards/viewthread/276648/#t393759

Thanks!!

 
Magento Community Magento Community
Magento Community
Magento Community
 
slunt32
Jr. Member
 
Total Posts:  6
Joined:  2010-08-31
 

I’m still experiencing some issues with this, I’ve done as BlackKnight suggested and uploaded a previous version of paypal but that would not redirect to paypal using paypal standard so i switched to express checkout and now it redirects. The problem now is that payments now show as pending and don’t go anywhere from there - any ideas?

 
Magento Community Magento Community
Magento Community
Magento Community
 
modspace
Jr. Member
 
Total Posts:  6
Joined:  2012-01-22
 

Hi, I did this and when I refreshed the cache I received

Fatal error: Class ‘Mage_Paypal_Model_Resource_Setup’ not found in /home/xxx/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php on line 234

I am sure its a 1.7.0.0 version I over wrote with....

I am on 1.7.0.2, but exactly the same problem, the person pays with paypal confirms then ...it just blanks out.

I saw something similar on zencart once...it ended up being a rounding error, the reply from paypal did not exactly match the order, so IPN threw the transaction out....we hacked the code a bit and it then worked…

Sort of expected better from magento…

 
Magento Community Magento Community
Magento Community
Magento Community
 
modspace
Jr. Member
 
Total Posts:  6
Joined:  2012-01-22
 

cross post sorry but trying to get some action

Ok we have created a fresh 1.7.0.2 shop and verfied paypal works there....then we connected the fresh shop with a COPY of the DB from the shop that does not work with paypal.....the paypal modules no longer works ...

This points to the problem being in the DB and with the upgrade process from 1.7.0.0 to 1.7.0.2
We also ran the DB repair tool referencing a fresh 1.7.0.2 , it did not help

We asked payal for help...lol...funny...they tried but its a magento problem....

Sucks to be community of course....though this basic functionality should be a given....

We are trying to compare tables to see what changed....but...well yeah try finding a needle in a haystack....

Spent HOURs on this now, we were puting about 5K/month through paypal...now its zero....paypal standard wont even work

If someone from magento who has an idea could help it would be great but I suspect i would have more hope of rubbing a rusty lamp.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top
Page 1 of 2