casper wrote:
PhreeBooks SQL Error Trace Information New Employee
Trace information for debug purposes. Phreedom release 3.3, generated 2012-01-27 10:30:11.
GET Vars = Array ( [module] => contacts [page] => main [type] => e [f0] => 1 )
POST Vars = Array ( [todo] => save [f0] => 1 [id] => [rowSeq] => [del_add_id] => [del_pmt_id] => [del_crm_note] => [payment_id] => [account_number] => [short_name] => 127.0.0.1 [gov_id_number] => [contact_first] => Павел [contact_middle] => [contact_last] => [dept_rep_id] => [gl_type_account] => Array ( [e] => 1 ) [em_primary_name] => СтройБут [em_telephone1] => [em_address_id] => [em_contact] => [em_telephone2] => [em_address1] => Кольцевая 40 [em_telephone3] => [em_address2] => Кольцевая 43 [em_telephone4] => [em_city_town] => Кировоград [em_email] => [em_state_province] => Украина [em_website] => [em_postal_code] => 2514 [em_country_code] => USA [em_notes] => )
Time: 157 ms, 6 SQLs 11 ms =>
The failing sql was: insert into admincontacts (type, short_name, inactive, contact_first, contact_middle, contact_last, store_id, gl_type_account, gov_id_number, dept_rep_id, account_number, special_terms, price_sheet, tax_id, attachments, last_update, first_date) values ('e', '127.0.0.1', '0', 'Павел', '', '', '', 'e', '', '', '', '::::', '', '', '', now(), now())
Time: 157 ms, 6 SQLs 11 ms =>
mySQL returned: 1366 Incorrect integer value: '' for column 'tax_id' at row 1
Page trace stats: Execution Time: 157 ms, 6 queries taking 11 ms
