Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Paypal App - Duplicate Tables - Please confirm


Mort-lemur

Recommended Posts

Hi,

 

On my development site which is 2.3.4 I have the paypal app installed and activated, although I have never added any live or sandbox credentials to it.

 

During an upgrade to the site it has been seen that there are 100's of duplicate entries in the database. (actually around 1000)

 

Could someone who is using the app please have a look at their database configuration table and check for duplicates of entries beginning with: OSCOM_APP_PAYPAL

 

Many Thanks

 

 

Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.

Link to comment
Share on other sites

I don't have the paypal app, but have the same symptoms for a few of my settings.

 

This sql will list duplucate configuration keys

use phpmyadmin or similar to run the sql query and find out exactly

 

select configuration_key, count(*) from configuration group by configuration_key having count(*) > 1

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Link to comment
Share on other sites

@@bruyndoncx thanks carine, I expect a few duplicates when installing / uninstalling mods etc so I will run that sql - but I did not expect to see some rows duplicated 50 times or so as with the paypal app. hence why I want to know if its just me or something others may be seeing.

 

Many Thanks

 

By the way thats a really useful piece of code - you should post it in the tips and tricks section :)

Edited by Mort-lemur

Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.

Link to comment
Share on other sites

I haven't experienced that with the App. Care was taken to properly migrate the old PayPal module parameters to the new App parameters and it also cleans itself up when modules are installed/uninstalled.

 

After removing all parameters from the database, have you tried clicking around the App to see where the problem occurs?

:heart:, osCommerce

Link to comment
Share on other sites

@@Harald Ponce de Leon Thanks Harald,

 

I have removed all the duplicates and clicked around the various options, but it has not created any more duplicates as yet - maybe it was something I did during the install that caused the problem - I will keep my eye on it over the next few days and see how it goes - I would still like someone who is actually using the app to check their config table for duplicate app rows.

 

Many Thanks

Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.

Link to comment
Share on other sites

do you have different installations running against the same database - I think that is where I got my duplicates

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Link to comment
Share on other sites

I just installed Paypal App (PS module) on a older Bootstrapped ...

 

I ran this:

 

select configuration_key, count(*) from configuration group by configuration_key having count(*) > 1

 

and got:

 

MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0037 sec )

Link to comment
Share on other sites

very odd then - I will watch it over the coming weeks.

 

Many Thanks

Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.

Link to comment
Share on other sites

@@Mort-lemur

 

These error occured when installation fails or non-standard installation was runned. I have these duplicates if I develop modules and non fixed constant used, deleted or modified between developings.
Its natural if you are a developer, but you should handle this in configuration table.

 

Probably you canceled or semi finalished the app installation when runned app setup with during errors.

 

 

(Somewhere is a commit to prevent this on the github with modules when unistall.)

Edited by Gergely
github note

:blink:
osCommerce based shop owner with minimal design and focused on background works. When the less is more.
Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store.

Link to comment
Share on other sites

@@Gergely Thanks for that - I have now deleted all the duplicates

Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.

Link to comment
Share on other sites

@@bruyndoncx thanks carine, I expect a few duplicates when installing / uninstalling mods etc so I will run that sql - but I did not expect to see some rows duplicated 50 times or so as with the paypal app. hence why I want to know if its just me or something others may be seeing.

 

Many Thanks

 

By the way thats a really useful piece of code - you should post it in the tips and tricks section :)

Added to tips and tricks

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...