Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

problem by checkout


Recommended Posts



i have installed the oscommerce and try to make checkout with credit card nummer(411111.....) but after I click the continue button I get the following error. I have installed the paypal ipn and tried with this but still have the same 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_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value) values ('2', 'ann', '', 'neckar', '', 'xxx', '12345', 'Hessen', 'Germany', '0163 11111111', '[email protected]', '5', ' ', '', '', '', '', '', '', '', '', 'ann', '', 'neckar', '', 'xxx', '12345', 'Hessen', 'Germany', '5', 'Credit/Debit Card (via PayPal)', '', '', '', '', now(), '5', 'EUR', '1.00000000')


can anyone help me?


thanks a lot


my OSC version is : oscommerce-2.2ms2

Link to comment
Share on other sites


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

  • Create New...