New Zenner
- Join Date:
- Nov 2007
- Posts:
- 4
- Plugin Contributions:
- 0
I don't have control over strict_trans_tables what can i do?
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=300135&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=F3B24DD11AF184BAD29BEAA54375B71F&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
