[doug-gb]

Hi,

#1 When I was testing my Paypal setup the payment went through, however towards the end of the process a PHP message was displayed from thanks.php

Notice: Query failed:

Notice: You have an error in your SQL syntax near " at line 1 SQL: SELECT title, price FROM class_products WHERE id= in ..website/classifieds/includes/MYSQL.php on line 120

Apparently ID had no value.

#2 In the in the Paypal details of the transaction it indicated "NO Address Provided"

Is it possible for the customer address to be passed to Paypal so that I can have the customers' address?

I would be grateful for any advice on these issues.

Doug

[suzkaw]

Doug,

To you now what version you are running?

[doug-gb]

Sorry Eric, I should have said:

Developer 3.0.14

Many thanks, Doug

[suzkaw]

Do you have the developer edition?

If so can you open the thanks.php page and go to line 148 and change:
$emailnotify = "Y"; to:
$emailnotify = "N";

[doug-gb]

Hi Eric

I have amended line 148 thanks.php line as described, and the error messages are not now displayed. Is there problem then, when $emailnotify = "Y"; in the original code?

Please, have you any advice on issue #2 "No Address Provided" to Paypal as described in my first email?

Thank you
Doug
Developer V3.0.14

[suzkaw]

That was a bug in the file.

For the address issue. Do you have that have the address as being seen and required through the administration?

[doug-gb]

If I understand you correctly, yes I would like the customer's Classifieds registered address to be passed to Paypal so that it it can be seen in the transaction in Paypal and in the payment notification which Paypal sends to us. Could this be done?

Thank you for your continued help, Eric

Doug

[suzkaw]

That should be sent automatically if they have an address entered. I will double check the code and make sure this is correct.

[doug-gb]

Eric,

Yes I can confirm that all the address details are entered in the account registration details, but still "No Address Provided" showing on the Paypal side.

Best regards
Doug

[doug-gb]

To everyone who is interested:

I had a problem because the Paypal transaction did not record the customer's address.

The reason I need the customer's address on the Paypal notification is because when customers pay for a particular advert package, we 'ship' them some material (a For Sale Sign) by Royal Mail, however Paypal just recorded 'No address provided'.

With Eric's very kind assistance the following changes seem to provide the solution although I shall check further that everything is working as intended.

1. Open usercheckout.php and locate:
$paymentform=displayPaypal($listingid,$grandTotal, $package);
Change to:
$paymentform=displayPaypal($listingid,$grandTotal, $package, $userinfo);

Open includes/functions_payment.php and locate:
function displayPaypal($listingid,$price,$package)
Change to:
function displayPaypal($listingid,$price,$package, $userinfo)

and go to line 44 which should looks like this:
$output.= '<input type="hidden" name="business" value="'.$extra.'" />';

Just below it add:
//added
$output.= '<input type="hidden" name="address1" value=""'.$userinfo['address'].'"">';
$output.= '<input type="hidden" name="city" value="'.$userinfo['city'].'">';
$output.= '<input type="hidden" name="state" value="'.$userinfo['state'].'">';
$output.= '<input type="hidden" name="zip" value="'.$userinfo['zip'].'">';
$output.= '<input type="hidden" name="address_override" value="0">';
//end added

and finally change this line which will now be line 60 value="1" to value="2"

$output.='<input type="hidden" name="no_shipping" value="2" />';

If anyone has any comments, advice or spots any problems with this I would be very pleased to hear from you.

Best regards, Doug