account won't update with time paid for

gpede · Posted: Wed Nov 14, 2007 7:39 am **Post subject: log info**

I did a fresh install and here is the only thing that shows up in the txn.log file:

PayPal : Tuesday 13th of November 2007 11:36:39 PM - Fail to update superuser account!

That's it.

G

gpede

I put 47 minutes as the amount to be added in PLAN A
I entered a basic Paypal account
I added Plan A to the shopping cart for the cost of 1.00

G

dominic · **Forum facilitator** Joined: 23 Oct 2007 Posts: 103

Please download the following file: http://patronsoft.com/firstspot/download/patch/501/ppal_ipn.zip

Then, unzip it to FirstSpot\local\ folder. The file ppal_ipn.php will be updated. Next, please perform the test and post the error log messages (with personal and network related information being removed) here again.

gpede · Posted: Wed Nov 14, 2007 2:19 pm **Post subject: unzipping**

Ok, I'll try that and let you know.

gpede · Posted: Thu Nov 15, 2007 6:13 am **Post subject: fresh install plus patch**

Did the fresh install plus applied the patch and still no-go. Do I have to do a reboot or does a "restart" do the job? I just noticed that it showed a "payment amount mismatch" probably due to the tax applied. Is there something you can do to compensate for that?

Here is the log file.....

PayPal : Wednesday 14th of November 2007 10:05:18 PM - Fail to update hello66 account due to payment amount mismatch!
mc_gross = 1.13
address_status = confirmed
payer_id = KZZNEMZCLYZTL
tax = 0.13
address_street = 123 anystreet
payment_date = 22:05:40 Nov 14, 2007 PST
payment_status = Completed
charset = windows-1252
address_zip = HoHoHO
first_name = G
mc_fee = 0.58
address_country_code = CA
address_name = my real name was here
notify_version = 2.4
custom = 2|hello66|Plan A
payer_status = unverified
business = my PAYPAL info was here, but was correct
address_country = Canada
address_city = mytown
quantity = 1
verify_sign = Ai1PaghZh5FmBLCDCTQpwG8jB264AImitBOQUW5v.cBhXNldcppCmwH8
payer_email = my correct email address was here
contact_phone =
txn_id = 1TU16667BH992201K
payment_type = instant
last_name = my correct last name was here
address_state = British Columbia
receiver_email = this email address was correct
payment_fee =
receiver_id = HT9CXD4CGYK22
txn_type = web_accept
item_name = Purchase 30 minutes on this plan
mc_currency = CAD
item_number =
residence_country = CA
receipt_id = 5303-6716-5179-1643
payment_gross =
shipping = 0.00

dominic · **Forum facilitator** Joined: 23 Oct 2007 Posts: 103

Sorry, I forgot to state that the file is just a version to show up related logs for your problem.

You're right. The tax value is added which makes the actual amount of payment shown in PayPal different from that in Shopping Cart, causing failure of updating the user account.

Please download the following file: http://patronsoft.com/firstspot/download/patch/501/local.zip

Same as before, please unzip it to FirstSpot\local\ folder. The files ppal_ipn.php and transaction.php will be updated. This time the file is really a patch for PayPal and this issue will be fixed in v5.0.1 for all types of payment gateways.

gpede · Posted: Thu Nov 15, 2007 3:55 pm **Post subject: still not working....**

Updated the files but still comes up "failed" even though it says completed in the transaction log.

Do you want a copy of the text from the log?

G

alan · **Forum facilitator** Joined: 26 Sep 2003 Posts: 4435

Yes, please post the log.
_________________
~ Patronsoft Limited ~

gpede · Posted: Thu Nov 15, 2007 7:01 pm **Post subject: log as requested**

Here is the log file....

PayPal : Thursday 15th of November 2007 07:51:00 AM - Fail to update supertest account due to payment amount mismatch!
mc_gross = 1.13
address_status = confirmed
payer_id = KZZNEMZCLYZTL
tax = 0.13
address_street = this address was correct
payment_date = 07:51:20 Nov 15, 2007 PST
payment_status = Completed
charset = windows-1252
address_zip = this postalcode was correct
first_name = this name was correct
mc_fee = 0.58
address_country_code = CA
address_name = this had my full name in it....
notify_version = 2.4
custom = 3|supertest|Plan A
payer_status = unverified
business = this email address was correct
address_country = Canada
address_city = this city was correct
quantity = 1
verify_sign = AnGyIdDsAxYay-Hc7mYdkSPtSZvuATO2cNvsiiez50Cu6oAhfnwri4a8
payer_email = this email address was correct
contact_phone =
txn_id = 4PU59559G37241400
payment_type = instant
last_name = my last name was correct
address_state = British Columbia
receiver_email = this email address was correct
payment_fee =
receiver_id = HT9CXD4CGYK22
txn_type = web_accept
item_name = Purchase 30 minutes on this plan
mc_currency = CAD
item_number =
residence_country = CA
receipt_id = 0151-1351-9197-0731
payment_gross =
shipping = 0.00

gpede · Posted: Thu Nov 15, 2007 7:13 pm **Post subject: wrong info**

Sorry, that was the log file created before I put the update in....

Once I updated the files there was absolutely nothing new arriving into the txn.log file....completely blank.

G

gpede · Posted: Thu Nov 15, 2007 7:18 pm **Post subject: wrong, again.**

I just didn't wait long enough for the info to come through...still says payment mismatch.

Here is the log:

PayPal : Thursday 15th of November 2007 11:09:00 AM - Fail to update supertest account due to payment amount mismatch!
mc_gross = 1.13
address_status = confirmed
payer_id = KZZNEMZCLYZTL
tax = 0.13
address_street = this address was correct
payment_date = 11:08:27 Nov 15, 2007 PST
payment_status = Completed
charset = windows-1252
address_zip = this information was correct
first_name = this information was correct
mc_fee = 0.58
address_country_code = CA
address_name = this information was correct
notify_version = 2.4
custom = 4|supertest|Plan A
payer_status = unverified
business = this information was correct
address_country = Canada
address_city = this information was correct
quantity = 1
verify_sign = A5Rj3eZmL-IJk3NQf.eIlACW-e5nAFfk7AFRB8nwjp5eDEh6dAMGejTi
payer_email = this information was correct
contact_phone =
txn_id = 52914775KT828924N
payment_type = instant
last_name = Pede
address_state = British Columbia
receiver_email = this information was correct
payment_fee =
receiver_id = HT9CXD4CGYK22
txn_type = web_accept
item_name = Purchase 30 minutes on this plan
mc_currency = CAD
item_number =
residence_country = CA
receipt_id = 5460-3045-4609-8565
payment_gross =
shipping = 0.00

gpede · Posted: Thu Nov 15, 2007 7:37 pm **Post subject: got it working**

I copied the "local" folder from the Beta version over to the ver5 "local" folder which copied over all the Paypal information.

It is now working but the question is.....was there a security issue with the beta version ?

G

dominic · **Forum facilitator** Joined: 23 Oct 2007 Posts: 103

Yes, so please try not to use the files from any previous versions in Final Release.

For your PayPal account settings, is there any extra charge included besides tax rate?

Also, I would like to have a check on FirstSpot's configuration. Could you set up remote desktop / VNC connection in the FirstSpot machine and e-mail the information to dwong@patronsoft.com?

alan · **Forum facilitator** Joined: 26 Sep 2003 Posts: 4435

Under no circumstance that should you copy the files from the old beta 2.

Again, please double-check:
1) it is a clean install of v5 final
2) no customization of php and html
3) no copy files from v5 beta 2 and other version.

Otherwise, we won't be able to help you anymore.
_________________
~ Patronsoft Limited ~

gpede · Posted: Fri Nov 16, 2007 7:03 am **Post subject: re-configure**

ok, I just wanted to confirm that everything I was doing was entered correctly and that the PayPal portion of the program was working since there are variables in that part also....I didn't know if it was a FS thing or a Paypal thing that's why I did it. Now I know.

So, I'll do a re-install but you need to tell me what you want...do I re-install Server 2003 then the FS software or just uninstall FS and re-install? After I uninstall do I do a reboot of the computer or just re-install immediately?

I can't do this tonight....it's already 11pm and I work at 6 am so I can try this tomorrow evening.

Our system is behind a router so VNC won't work but I can put it on a private IP if that works for you. I'll need to know when you wish to attach so I can set it up.

I sure wish you guys had "live chat" or some way to communicate in real time. I did offer to phone you if necessary.

G.