- This topic has 8 replies, 2 voices, and was last updated 3 years, 11 months ago by
.
-
Posts
-
Hi. I can’t add new customers. I can add new invoices, but get errors when trying to add customers;
Incorrect integer value: ” for column
sinv2020.si_customers.parent_customer_idat row 1All others are set to 0, but it seems that the latest version isn’t passing that value. php.log attached.
Thanks.
I can add customers if I set a ‘parent customer’.. but if this field is blank, it gives the error above
Please try the following:
In the templates/default/customers/create.tpl file, find the “SELECT” statement for the “parent_customer_id” field. Approximately line 125. Modify the line following the “SELECT” statement remove the value setting of blank, so it looks like this:
<option value></option>If that works for you, I’ll make it a permanent fix.
No, I’m afraid not.. Same error;
[18-Dec-2020 00:03:15 Europe/London] PdoDb – debugger(): INSERT INTO
si_customers(domain_id,attention,name,department,street_address,street_address2,city,state,zip_code,country,phone,mobile_phone,fax,email,credit_card_holder_name,credit_card_expiry_month,credit_card_expiry_year,notes,custom_field1,parent_customer_id,enabled) VALUES (1, ”, ‘NAME’, ”, ”, ”, ”, ”, ”, ”, ”, ”, ”, ’email@address.com’, ”, ”, ”, ”, ”, ”, 1)
[18-Dec-2020 00:03:15 Europe/London] PdoDb – query(): Execute error.Array
(
[0] => 22007
[1] => 1366
[2] => Incorrect integer value: ” for columnsinv2020.si_customers.parent_customer_idat row 1
)..however;
<option value='0'></option>does work, and if you enter another customer into the parent customer field, it uses their value instead of 0.
Thanks. Fixes for this issue have been uploaded on github. Update to that version to get them plus other changes for datatables library security issue fix.
- You must be logged in to reply to this topic.
Recent Comments