I don't have control over strict_trans_tables what can i do?

[jeremyj]

I am using ZC version 1.3.7.1 fresh install
Database: MySQL 5.0.23-community-max-nt
PHP Version: 5.2.3 (Zend: 2.2.0)
I haven't installed any add-ins

After searching through the forums I have come to the conclusion that the way to fix the below errors is to disable strict_trans_tables in mysql5. Unfortunately my hosting company will not do this. Are there any other fixes for my errors below? My hosting company has mysql4 available, would switching to this fix my problems or create more? Is there any functionality I will lose downgrading the DB?

I receive this error at checkout using Authorize.net AIM:
1264 Out of range value adjusted for column 'orders_status_id' at row 1
in:
[insert into zen_Storeorders_status_history (comments, orders_id, orders_status_id, date_added) values ('Credit Card payment. AUTH: 046267. TransID: 1605273073.' , '300135','', now() )]

I receive this error at checkout using Authorize.net AIM with DB storage:
1264 Out of range value adjusted for column 'id' at row 1
in:
[insert into zen_Storeauthorizenet (id, customer_id,order_id, response_code, response_text, authorization_type, transaction_id, sent, received, time, session_id) values ('', '73', '300135', '1', 'This transaction has been approved.', 'auth_capture', '1605271222', 'Array ( [x_login] => ******* [x_tran_key] => ******* [x_relay_response] => FALSE [x_delim_data] => TRUE [x_version] => 3.1 [x_type] => AUTH_CAPTURE [x_method] => CC [x_amount] => 0.01 [x_card_num] => *******4280 [x_exp_date] => 0709 [x_card_code] => ******* [x_email_customer] => FALSE [x_email_merchant] => FALSE [x_cust_id] => 73 [x_invoice_num] => 300135 [x_first_name] => joe [x_last_name] => test [x_company] => [x_address] => 33826 test road [x_city] => test city [x_state] => California [x_zip] => 92555 [x_country] => United States [x_phone] => 999-999-9012 [x_email] => [email protected] [x_ship_to_first_name] => joe [x_ship_to_last_name] => test [x_ship_to_address] => 33826 test road [x_ship_to_city] => test city [x_ship_to_state] => California [x_ship_to_zip] => 92555 [x_ship_to_country] => United States [x_description] => test(qty: 1) [Date] => October 31, 2007, 2:39 am [IP] => 22.171.102.91 [Session] => bfb62d510a3e73b12cc02735878f1d2a [url] => https://secure.authorize.net/gateway/transact.dll ) ', '1=1&2=1&3=1&4=This+transaction+has+been+approved.&5=091164&6=Y&7=1605271222&8=3 00135&9=test%28qty%3A+1%29&10=0.01&11=CC&12=auth_capture&13=73&14=joe&15=test&16 =&17=33826+test+road&18=test city&19=California&20=92555&21=United+States&22=951-541-9012&23=&24=test%40ca.rr.com&25=joe&26=test&27=&28=33826+test+road&29=test city&30=California&31=92555&32=United+States&33=&34=&35=&36=&37=&38=F3B24DD11AF1 84BAD29BEAA54375B71F&39=&40=&41=&42=&43=&44=&45=&46=&47=&48=&49=&50=&51=&52=&53= &54=&55=&56=&57=&58=&59=&60=&61=&62=&63=&64=&65=&66=&67=&68=&69=October+31+2007+ 2%3A39+am&70=76.171.102.91&71=bfb62d510a3e73b12cc02735878f1d2a', 'October 31, 2007, 2:39 am', 'bfb62d510a3e73b12cc02735878f1d2a')]

I received this error when I try to order a virtual product:
1264 Out of range value adjusted for column 'delivery_address_format_id' at row 1
in:
[INSERT INTO zen_Storeorders (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, payment_module_code, shipping_method, shipping_module_code, coupon_code, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, order_total, order_tax, currency, currency_value, ip_address) VALUES ('1', 'Joe Test', '', '33826 test Road', '', 'Test City', '92555', 'California', 'United States', '999-999-9012', '[email protected]', '2', ' ', '', '', '', '', '', '', '', '', 'Joe Test', '', '33826 Test Road', '', 'Test City', '92555', 'California', 'United States', '2', 'Gift Certificate/Coupon', 'GV/DC', 'Free Shipping', 'free', '', '', '', '', '', now(), '2', '0', '0', 'USD', '1.00000000', '99.159.58.234 - 99.153.58.234')]

Thank you in advance for any help you can provide

[DrByte]

Can you try using the updated AIM module, posted here:
http://www.zen-cart.com/forum/showth...023#post441023

I received this error when I try to order a virtual product:
1264 Out of range value adjusted for column 'delivery_address_format_id' at row 1
in:
[INSERT INTO zen_Storeorders (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, payment_module_code, shipping_method, shipping_module_code, coupon_code, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, order_total, order_tax, currency, currency_value, ip_address) VALUES ('1', 'Joe Test', '', '33826 test Road', '', 'Test City', '92555', 'California', 'United States', '999-999-9012', '[email protected]', '2', ' ', '', '', '', '', '', '', '', '', 'Joe Test', '', '33826 Test Road', '', 'Test City', '92555', 'California', 'United States', '2', 'Gift Certificate/Coupon', 'GV/DC', 'Free Shipping', 'free', '', '', '', '', '', now(), '2', '0', '0', 'USD', '1.00000000', '99.159.58.234 - 99.153.58.234')]

See the fix here:
http://www.zen-cart.com/forum/showpo...61&postcount=4