FrontAccounting forum — Error in Creating New Customer Account

Re: Error in Creating New Customer Account

null@example.com (apmuthu) — Wed, 22 Feb 2017 02:31:44 +0000

Compare the schemas and see if there are any other changes.
Is there any upgrade sql in the "sql" folder that drops the auto_increment attribute?

The only PHP file that refers to the AUTO_INCREMENT attribute is admin/db/maintenance_db.inc in both versions.

Whilst "inactive' is not needed unless it's default / NULL property has changed, the primary key is needed if the AUTO_INCREMENT is absent.

Re: Error in Creating New Customer Account

null@example.com (timelyfiasco) — Wed, 22 Feb 2017 02:00:22 +0000

I found a backup last month that is working and compared the sqls. In crm_contacts, the auto_increment in ID disappeared which is causing the error. Trying to fix it right now.

Re: Error in Creating New Customer Account

null@example.com (stefan) — Tue, 21 Feb 2017 10:02:26 +0000

What says the debugger?

Re: Error in Creating New Customer Account

null@example.com (timelyfiasco) — Tue, 21 Feb 2017 03:10:25 +0000

Hi apmuthu, thanks for helping again. I dont think it's because of the browser cache or the sys_types. also, I can create a new supplier without any problem.

When I change the sql I am able to insert a new row. But the original FA file is like mine so this can't be the reason. Can it be because I used mysql workbench from Ubuntu 16 to overwrite my database in mysql 5.5 php 5.5.9 Ubuntu 14 server?

        
"INSERT INTO ".TB_PREF."debtors_master (name, debtor_ref, address, tax_id,
dimension_id, dimension2_id, curr_code, credit_status, payment_terms, discount, 
pymt_discount,credit_limit, sales_type, notes)

        
INSERT INTO 0_debtors_master (debtor_no, name, debtor_ref, address, tax_id, curr_code, sales_type, dimension_id, dimension2_id, credit_status, payment_terms, discount, pymt_discount, credit_limit, notes, inactive)

I added debtor_no, inactive.

Re: Error in Creating New Customer Account

null@example.com (apmuthu) — Mon, 20 Feb 2017 18:28:38 +0000

Logout, clear your browser cache, login again and then see if you get the same error. You may have used the browser's back button instead of the "back" link on the web page.

It is also possible that your sys_types table may be corrupted or inconsistent. The next_reference field is your target to investigate. This is generally used for transactions and may not apply to new customer creation.

The function add_customer() is defined in sales/includes/db/customers_db.inc - check out the sql in it and manually execute it in some mysql client and see what gives.

Error in Creating New Customer Account

null@example.com (timelyfiasco) — Mon, 20 Feb 2017 11:38:04 +0000

"The entered information is a duplicate. Please go back and enter different values."
I got this message when I tried to add a new customer. The names are unique. Does anyone know how to fix this?