gavbuk Posted March 22, 2006 Posted March 22, 2006 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
Guest Posted March 22, 2006 Posted March 22, 2006 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
gavbuk Posted March 22, 2006 Author Posted March 22, 2006 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??
gavbuk Posted March 22, 2006 Author Posted March 22, 2006 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.
KB7 Posted May 16, 2006 Posted May 16, 2006 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...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.