6 replies to this topic

[siyerindu]

Hi,
I was using paypal website standard in my website.Now my client want to use paypal express checkout also.I have done the installations and tried sandbox.It goes to paypal site authenticates login and when click pay now it returns to paypal login again.Can anyone tells why this happens

[hughesca]

Check your return URL with PayPal under Website Preferences.

It should be pointing to /catalog/checkout_process.php

Peace,
Chris

Edited by hughesca, 22 September 2011, 12:41.

[trauko]

I am having the exactly the same problem. I am using Checkout express, the return URL it is pointing correctly to /catalog/checkout_process.php.

The main problem is:
Everything is working fine untill I press the confirmation button to confirm the purchase, then take me inmediately back to the login page.
Does not register the order or updates the customers details and also does not updates the paypal accounts (merchant and buyer).
It's happend in live mode and in sanbox mode. There is no error messages, nothing..

Any Ideas please.....thanks in advance.

Edited by trauko, 03 October 2011, 22:55.

[DunWeb]

Sounds like a sessions problem. Ensure your cookies path is set correctly in the configure.php file and also that the options are correct in admin>> configuration>> sessions.





Chris

[trauko]

Hi Chris,
Many thanks for your replay.
Yeah, you were right. I have checked the configure.php and I had set off the cookies.
Now the checkout process continue a little bit further. Paypal express update the fake accounts on sandbox, which it is fine,
but no before to send me the following error message...

1054 - Unknown column 'delivery_date' in 'field list'

insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, delivery_date, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value) values ('5', 'Test User', '', '1 Main Terrace', '', 'Wolverhampton', 'W12 4LQ', 'West Midlands', 'United Kingdom', '', 'cgalia_1317663649_per@yahoo.com', '1', 'Test User', '', '1 Main Terrace', '', 'Wolverhampton', 'W12 4LQ', 'West Midlands', 'United Kingdom', '1', '', 'Test User', '', '1 Main Terrace', '', 'Wolverhampton', 'W12 4LQ', 'West Midlands', 'United Kingdom', '1', 'PayPal (including Credit and Debit Cards)', '', '', '', '', now(), '4', 'GBP', '1.00000000').

As fa as I understand paypal try to update my database orders and apparently there is a field missing ( 'delivery_date ') in my database??
Of course after this I am not getting any update in my orders files.
What should I do??
Sorry I am not an expert in PHP...any help would greatly appreciate.....Thanks in advance..

[web-project]

trauko, on 04 October 2011, 11:40, said:

Hi Chris,
Many thanks for your replay.
Yeah, you were right. I have checked the configure.php and I had set off the cookies.
Now the checkout process continue a little bit further. Paypal express update the fake accounts on sandbox, which it is fine,
but no before to send me the following error message...

1054 - Unknown column 'delivery_date' in 'field list'

insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, delivery_date, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value) values ('5', 'Test User', '', '1 Main Terrace', '', 'Wolverhampton', 'W12 4LQ', 'West Midlands', 'United Kingdom', '', 'cgalia_1317663649_per@yahoo.com', '1', 'Test User', '', '1 Main Terrace', '', 'Wolverhampton', 'W12 4LQ', 'West Midlands', 'United Kingdom', '1', '', 'Test User', '', '1 Main Terrace', '', 'Wolverhampton', 'W12 4LQ', 'West Midlands', 'United Kingdom', '1', 'PayPal (including Credit and Debit Cards)', '', '', '', '', now(), '4', 'GBP', '1.00000000').

As fa as I understand paypal try to update my database orders and apparently there is a field missing ( 'delivery_date ') in my database??
Of course after this I am not getting any update in my orders files.
What should I do??
Sorry I am not an expert in PHP...any help would greatly appreciate.....Thanks in advance..

you skipped one of installation steps, you need to add the delivery_date field into order database.

[trauko]

Thanks Alex,

That's what I thought. There was no mention about to alter a database though.
I have changed the database and now the process goes all the way.
Just a bit disappointed that Paypal Express is not keeping the Product's description at their end. Do I really need IPN module for this??

Many thanks for your help...