• From: UK, Norfolk
  • Registered: 12/03/2014
  • Posts: 28

Topic: Import of Paypal transactions

Hi

When running the menu option "Import Paypal Transactions", after selecting a csv file and clicking on the "Import Paypal Transaction" button the screen goes blank and this message is displayed.

Not Acceptable!

An appropriate representation of the requested resource could not be found on this server. This error was generated by Mod_Security

The initial URL  is

http://www.xxxxxxxxxxx.co.uk/frontaccounting/modules/import_paypal/import_paypal.php

when the error message is displayed, it is

http://www.xxxxxxxxxxx.co.uk/frontaccounting/modules/import_paypal/import_paypal_update.php?filename=../../tmp/adminpaypal.csv

If I remove ../.. from the url Mod_Security does not kick in.

My host will not turn off mod sec or allow the rules to be varied.

Are there any plans to replace the dot-slash coding?

Cheers

Geoffrey

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Import of Paypal transactions

You can hardcode the dot-slash coding inside the php script and allow the full filename with path to be put in there instead.

apmuthu's Website

  • From: New Zealand, Auckland
  • Registered: 10/15/2011
  • Posts: 40

Re: Import of Paypal transactions

Sorry about that Geoffrey. I did not know mod_security existed or that the path would cause a problem.
I've updated the module to fix that. You can download it from:
  http://www.kwikpay.co.nz/download/import_paypal.zip
This version also reorganised the code to reduce memory usage, and included from paypal transaction type changes.

4 Reply by apmuthu (edited by apmuthu 12/05/2014 04:16:56 am)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Import of Paypal transactions

The download link http://www.kwikpay.co.nz/download/import_paypal.zip seems to be unavailable.

Even the domain default page http://www.kwikpay.co.nz/ is inaccessible too.

apmuthu's Website

  • From: New Zealand, Auckland
  • Registered: 10/15/2011
  • Posts: 40

Re: Import of Paypal transactions

Sorry, looks like a DNS problem at the web site. Try http://kwikpay.co.nz/download/import_paypal.zip instead.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Import of Paypal transactions

Still not available.
Check your apache conf / vhosts conf for deny/allow rules

apmuthu's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Import of Paypal transactions

Works now. Thanks.

apmuthu's Website

8 Reply by apmuthu (edited by apmuthu 12/10/2014 06:51:14 am)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Import of Paypal transactions

Typo crept into line 14 of your hooks.php:
additional => additonal

Since an unrelated file got edited, you may want to see if the relevantly changed files have issues.

Key changes seen in your v1.2 as opposed to the v1.1 available in theFARepo as import_paypal-2.3.10-2.pkg (haven't see the import_paypal-2.3.10-3.pkg yet) is the removal of the paypal_fee_act field - any reason for commenting them all out? Also the log messages pertaining to memory have been commented out as well.

Line 71 of import_paypal_update.php still refers to the variable $paypal_fee_act as global and probably not used now.

The main purpose of this version was to fix only the filename format alone.

It may be possible that you edited an older set of files.

Do you have it on github?

apmuthu's Website

9 Reply by apmuthu (edited by apmuthu 12/09/2014 01:48:21 pm)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Import of Paypal transactions

Typo crept into line 14 of your hooks.php:
additional => additonal

The above change occurred when going from import_paypal-2.3.10-2.pkg to import_paypal-2.3.10-3.pkg whilst remaining in the core v1.1 with no other changes between these versions. Practically all extensions have been affected by this change probably introduced when compiling the pkgs.

apmuthu's Website