Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

matthewholland

Archived
  • Posts

    4
  • Joined

  • Last visited

Profile Information

  • Real Name
    matthew holland

matthewholland's Achievements

  1. okay thanks for the reply. I went ahead and upgraded to mysql 5.0.21 from dev.mysql.com, and I still have the same issue requarding 1264 - Out of range value adjusted for column 'delivery_address_format_id' at row 1 do I need to change the field type?
  2. I have a small problem in that when I purchase a gift voucher it works fine but shipping is added. No big deal...So I followed the documentation and goto admin-configuration-downloads-enable download. Now at the checkout confirmation i press confirm order and I get the 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', 'matt holland', '', '311 w edgewood dr', '', 'friendswood', '77546', 'Texas', 'United States', '2819921700', 'mattatcyberbay.net', '2', ' ', '', '', '', '', '', '', '', '', 'matt holland', '', '311 w edgewood dr', '', 'friendswood', '77546', 'Texas', 'United States', '2', 'Check/Money Order', '', '', '', '', now(), '1', 'USD', '1.00000000')
  3. I am using qbi 2.10 and I was wondering, is their a way to import all my quickbooks items into osc? I have no items in osc right now, and when I import my items.iif file it wants to match against nothing. I have 540 quickbooks items so I was hoping to not have to re-type them into osc...
×
×
  • Create New...