Hi there
if I try ot insert a new customer , I recevie this error mesage after clicking "confirm data":
Your new Card hasn't been inserted.If I open mydql debugs:
I can see that this query is performd :
INSERT INTO cc_card (username, useralias, uipass, credit, id_group, id_seria, lastname, firstname, email, address, city, state, country, zipcode, phone, fax, company_name, company_website, typepaid, tariff, id_didgroup, id_timezone, language, currency, status, block, lock_pin, simultaccess, runservice, credit_notification, notify_email, id_campaign, enableexpire, expirationdate, expiredays, sip_buddy, iax_buddy, autorefill, initialbalance, invoiceday, vat, discount, restriction) values ('9933367729', '098563644051546', '69716cffhbh5qtfcaflu', '0', '1', '-1', 'customer A', 'spacher',
'[email protected]', 'via roma', 'canicatti', 'Agrigento', 'TGO', '0100', '3939393938', '090', 'no spa', 'none', '0', '1', '1', '67', 'en', 'USD', '1', '0', '0', '1', '0', '-1', '0', '-1', '0', '2026-10-10 11:45:38', '0', '1', '1', '0', '0', '1', '0', '0.00', '0')
and if I try this query the error raised is :
ERROR 1364 (HY000): Field 'redial' doesn't have a default valueMoreover if for example I forget to fill in zip code or coutnry, the isnertion fail silently for the same reasoine (no default value ) .
How can I populate redial value while inserting new customer?
thanks a lot for your support
mine operating confiurations is:
a2billing 2.2.0 + php7 + mysql 5.7.15 + UBUNTU 16.06