Having a problem with downloadable products - help please!

[blueshock]

Hi. I'm having a problem with downloadable products

 

When a customer hits the confirm order button, the following scenarios occur for me:

 

1. If the cart contains *only* the downloadable product, an error (lengthy text below).

2. If the cart contains the downloadable product and at least one non-downloadable (physical) product, everythign works and the customer is allowed to download the downloadable product she has purchased.

3. If the cart contains only physical products, everything works.

 

 

The nasty error in case 1, above, is as follows:

 

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 ('3', 'Valerie Ball', '', '123 Open Way', '', 'Tucson', '85750', 'Arizona', 'United States', '520-555-1212', '[email protected]', '2', ' ', '', '', '', '', '', '', '', '', 'Valerie Ball', '', '123 Open Way', '', 'Tucson', '85750', 'Arizona', 'United States', '2', '', '', '', '', '', now(), '1', 'USD', '1.00000000')

 

[TEP STOP]

 

 

XP sp2

osC 2.2 MS2

MySQL 5.0.21

PHP 5.0.4

Apache 2.0.55

IE 6

 

Any ideas?

 

Thanks!

[kobeyn]

Hi. I'm having a problem with downloadable products

 

When a customer hits the confirm order button, the following scenarios occur for me:

 

1. If the cart contains *only* the downloadable product, an error (lengthy text below).

2. If the cart contains the downloadable product and at least one non-downloadable (physical) product, everythign works and the customer is allowed to download the downloadable product she has purchased.

3. If the cart contains only physical products, everything works.

The nasty error in case 1, above, is as follows:

 

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 ('3', 'Valerie Ball', '', '123 Open Way', '', 'Tucson', '85750', 'Arizona', 'United States', '520-555-1212', '[email protected]', '2', ' ', '', '', '', '', '', '', '', '', 'Valerie Ball', '', '123 Open Way', '', 'Tucson', '85750', 'Arizona', 'United States', '2', '', '', '', '', '', now(), '1', 'USD', '1.00000000')

 

[TEP STOP]

XP sp2

osC 2.2 MS2

MySQL 5.0.21

PHP 5.0.4

Apache 2.0.55

IE 6

 

Any ideas?

 

Thanks!

 

 

Hi I have the same problem did you find a solution ?

 

thanks