Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Payment Success Errors - Paypal


gavbuk

Recommended Posts

Posted

Hi

 

I've recently setup oscommerce on a server running IIS 6, PHP 5.1 and MySQL 5. I'm pretty much a newbie, although I have produced one or two sites of varying kinds.

 

I have experienced a few issues during setup and resolved most, however I have now come to the point of testing my Payment options...paypal to be specific.

 

I've used both the standard version of the pre-process version, both of which give the following error:

 

 

 

1264 - Out of range value adjusted for column 'delivery_address_format_id' at row 1

 

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, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_f................and so on

 

 

The standard paypal payment gives this error when returning from Paypal. The pre-process one gives it right at the end of checkout, prior to payment....

 

 

I'm really stuck.......has anyone got any ideas???

 

Thanks in advance

Posted

The problem with bleeding edge environments is that you must update the software you wish to run on it :-"

 

Most people have an environment that is compatible with the software they wish to run :)

 

Matti

Posted
The problem with bleeding edge environments is that you must update the software you wish to run on it :-"

 

Most people have an environment that is compatible with the software they wish to run :)

 

Matti

 

 

Thanks for the reply....but what is actually wrong with the setup that I am using??

Posted

After a bit more testing...I've just noticed that this only happens when I have a single item in the cart. More than one item goes straight through and works.

  • 1 month later...
Posted
After a bit more testing...I've just noticed that this only happens when I have a single item in the cart. More than one item goes straight through and works.

 

I seem to have this same problem when the cart contains oonly downloadable items, like software or eBooks. If I add even one physical item, then *ALL* items are handled properly, including the downloads. Strange...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...