View Issue Details

IDProjectCategoryView StatusLast Update
0004561module PayPalmodule PayPal - subpublic2013-01-07 16:47
Reporterleofonic Assigned To 
PriorityhighSeveritymajorReproducibilitysometimes
Status resolvedResolutionno change required 
Product Version2.0.2 
Target Version2.0.4Fixed in Version2.0.4 
Summary0004561: Paypal does not work after installation unless database entries are removed manually
DescriptionThere are several threads in german forum that describe the issue that paypal 2.0.2 does not work after installation unless the following sql is executed:

DELETE FROM `oxconfig` WHERE `OXVARNAME` LIKE 'paypalsettingscachevalidto' OR `OXVARNAME` LIKE 'paypal_blPortletEnabled' OR `OXVARNAME` LIKE 'paypal_aSettings'

Recently i had an installation where paypal 2.0.2 was installed and did not appear (no logos, no payment method paypal), executed this sql, and paypal worked right away.
TagsNo tags attached.

Activities

dainius.bigelis

2012-10-01 09:41

reporter   ~0007510

There is a logic, which sets the params, and the time when it expires. So if you install module and the old cache is still not expired - you will notice the changes of new installation only after the cache will expire.
By deleting those options from DB you trigger expiration and the options are refreshed with latest values for current installation.
We decided to improve the logic, that it would reset the expiration time, if module is Disabled. Maybe also on some other actions when it's needed.

leofonic

2012-10-01 19:24

reporter   ~0007521

In my case it was a fresh installation and i waited 2 days, paypal did not appear.

leofonic

2012-10-12 13:05

reporter   ~0007604

Additional info: The suggested solution to delete the paypal entries in DB was supplied by user spinelab (Mirko) in german forum: http://forum.oxid-esales.com/showthread.php?p=100006#post100006

In this thread you can also see several other people who confirm that paypal did not appear until executing the SQL.

If you do a search in Forum for "paypalsettingscachevalidto" you will also find several other threads where people stated that deleting the entries helped.

In this thread http://forum.oxid-esales.com/showthread.php?p=100249 Mirko suggests that this problem happens only on a fresh installation of 2.0.2 or an Update from 1.x Version

ndeet

2012-10-15 19:05

reporter   ~0007619

Hi, can confirm this bug.

Fresh install oxid CE 4.6.5, php 5.3, paypal module 2.0.2

After installation the paypal payment option was only VISIBLE if the module itself was DISABLED in backend - but it did not work and no paypal logo was shown. If I enabled the module the payment option was hidden on checkout????

The quickfix to delete oxconfig params of paypal module worked for me too.

rimvydas_paskevicius

2013-01-07 16:47

reporter   ~0008234

This problem is fixed since PayPal version 2.0.3 but only for shop version 5.x as there is implemented modules events handling. On module activation/deactivation event PayPal settings are reseted, so this problem does not exist. 4.6.x shops does not has this event handling so after updating you should manually execute this sql:

DELETE FROM `oxconfig` WHERE `OXVARNAME` = 'paypalsettingscachevalidto';

It will reset all cached data and all setting will be renewed. No need to delete "blPortletEnabled" or "paypal_aSettings" as these options depends on cache validation time.

PayPal installation documentation also will be updated.