PDA

View Full Version : paypal error



bmonster8899
08-26-2007, 11:07 AM
Hi encounter error at checkout_confirmation.php? what is wrong

1366 - Incorrect integer value: '' for column 'customers_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 ('1', ' ', '', '', '', '', '', '', '', '', '', '', 'test test', '', 'test test', '', 'USA', '123456', '', 'USA', '4', ' ', '', '', '', '', '', '', '', '', 'PayPal (Credit Card / Debit)', '', '', '', '', now(), '100001', 'SGD', '1.00000000')

How to solve this problem? can anyone advise me.