webERP Forum

Full Version: CUSTOMER CAN'T DELETE...
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello everyone,

I have another problem, I can delete the customer or customer branch data before, but since yesterday, I can't delete it and get error code 1146.
[attachment=975]

what happened? Maybe somewhere I set myself?

Alex
Well it is saying that the table 'contracts' doesn't exist. Can you check whether this is so? If it worked before yesterday then the table must have existed then. Can it have got deleted?

Tim
(09-10-2019 11:54 PM)falkoner Wrote: [ -> ]Well it is saying that the table 'contracts' doesn't exist. Can you check whether this is so? If it worked before yesterday then the table must have existed then. Can it have got deleted?

Tim

Hi Tim,

seems lost table "contracts".

now I only can find "debtorno" in Following tables:
audittrail
custbranch
debtorsmaster

"branchcode" only in audittrail and custbranch
[attachment=976]

but now When we add a new Customer, all seems no problem.

Now how to solve it

Alex
Hi Tim,

OK, it seems a different thing.

We never used contracts function before, only sales and receive the money, so off course we haven't "contracts" table.

So if I want to delete a company or branch, does it also need to access this "contracts"?

Alex
When deleting a customer it first does a whole lot of checks to see if there are any transactions relevant to that customer. One of these checks is for any contracts. When it is unable to find the contracts it crashes out, so though you are not using the contracts functionality you still need that table - and all the others.

You can find the sql to create that table, and any others in the sql/mysql/country_sql/default.sql file.

Tim
Hi Tim

Yes, now I solved it, thanks a lot again.

Alex
Reference URL's