Hi,
It is indeed a mysql 5 strict mode bug, although why it uses a 'f' as the value I have no idea.
I don't have a complete fix for this yet, but this workaround should help.
You will need to edit
includes/classes/order.php.
the block of code you are looking for is circa line 623 and looks like this
Code:
$sql_data_array = array('orders_id' => $insert_id,
'title' => $zf_ot_modules[$i]['title'],
'text' => $zf_ot_modules[$i]['text'],
'value' => $zf_ot_modules[$i]['value'],
'class' => $zf_ot_modules[$i]['code'],
'sort_order' => $zf_ot_modules[$i]['sort_order']);
you should replace that with
Code:
$sql_data_array = array('orders_id' => $insert_id,
'title' => $zf_ot_modules[$i]['title'],
'text' => $zf_ot_modules[$i]['text'],
'value' => (is_numeric($zf_ot_modules[$i]['value'])) ? $zf_ot_modules[$i]['value'] : '0',
'class' => $zf_ot_modules[$i]['code'],
'sort_order' => $zf_ot_modules[$i]['sort_order']);
Make sure you back up the file first before editing, and test on a live server asap after editing.
Bookmarks