FrontAccounting forum — Can not release workorder

Re: Can not release workorder

null@example.com (kvvaradha) — Sat, 14 Apr 2018 13:41:47 +0000

It happens when your data is corrupted. the Work orders are connected with few tables.

workorders
wo_costing
wo_issues
wo_issue_items
wo_manufacture
wo_requirements

Here the work orders are passed among these tables. in the entries are missing in one table and it has in another table, gives you this kind of trouble.

As you said some works, than it has missing data. You should check the data's manually

Re: Can not release workorder

null@example.com (alanmi) — Sat, 14 Apr 2018 07:54:35 +0000

Already checked that and the table are missing, everything else works fine. Restored a backup from where I know the manufacturing still worked as some of the work orders have not been entered and it give me the same error.

So apart from starting from scratch anything else that I can do.

Re: Can not release workorder

null@example.com (apmuthu) — Sat, 14 Apr 2018 06:51:09 +0000

Check your database name and prefix in the config_db.php file and then check that the said tables exist.

Re: Can not release workorder

null@example.com (alanmi) — Fri, 13 Apr 2018 15:37:19 +0000

FrontAccounting 2.4.4
Current database version 2.4.1

DATABASE ERROR : The work order requirements could not be added
error code : 1146
error message : Table 'frontaccounting.0_wo_requirements' doesn't exist

Re: Can not release workorder

null@example.com (kvvaradha) — Fri, 13 Apr 2018 14:16:09 +0000

enable debugging mode and see the error on screen and put it here to advice you clearly.

Can not release workorder

null@example.com (alanmi) — Fri, 13 Apr 2018 09:29:21 +0000

I suddenly cannot do any manufacturing. I cannot produce, nothing happens when I press 'Process and Close'
The same applies for releasing a work order, nothing happens.
Any ideas.

Regards