Hi;
After recent update, I get an error when copying BOM from existing items to new item. Worked before, now get the following error:
Database Error 1054 :
Unknown column 'decimalplaces' in 'field list'
Database SQL Failure : The SQL that failed was INSERT INTO bom SELECT 'TH-PMNT-401' AS parent, sequence, component, workcentreadded, loccode, effectiveafter, effectiveto, quantity, autoissue, remark, digitals, decimalplaces FROM bom WHERE parent='TH-PMNT-404';
Failed on multiple products; BOM's and item details look correct; maybe something to do with the remarks field.
Pls advise if need to add or edit some info to correct the error.
Thank you very much for any advice. very appreciated.
RE: Error 1054 when copying BOM to another product
Hi,
It's fixed in the trunk. Please refer to the attachment.
Best regards!
Exson
(02-24-2017, 02:24 PM)archer62 Wrote: Hi;
After recent update, I get an error when copying BOM from existing items to new item. Worked before, now get the following error:
Database Error 1054 :
Unknown column 'decimalplaces' in 'field list'
Database SQL Failure : The SQL that failed was INSERT INTO bom SELECT 'TH-PMNT-401' AS parent, sequence, component, workcentreadded, loccode, effectiveafter, effectiveto, quantity, autoissue, remark, digitals, decimalplaces FROM bom WHERE parent='TH-PMNT-404';
Failed on multiple products; BOM's and item details look correct; maybe something to do with the remarks field.
Pls advise if need to add or edit some info to correct the error.
Thank you very much for any advice. very appreciated.
RE: Error 1054 when copying BOM to another product
Hi Exson;
tks very much for your help, after updating, I get this error:
Database Error 1136 :
Column count doesn't match value count at row 1
Database SQL Failure : The SQL that failed was
INSERT INTO bom SELECT 'TH-PMNT-801' AS parent, sequence, component, workcentreadded, loccode, effectiveafter, effectiveto, quantity, autoissue, remark, digitals, digitals FROM bom WHERE parent='TH-PMNT-808';
tks again for your help.
(02-24-2017, 02:57 PM)Exsonqu_Qu Wrote: Hi,
It's fixed in the trunk. Please refer to the attachment.
Best regards!
Exson
(02-24-2017, 02:24 PM)archer62 Wrote: Hi;
After recent update, I get an error when copying BOM from existing items to new item. Worked before, now get the following error:
Database Error 1054 :
Unknown column 'decimalplaces' in 'field list'
Database SQL Failure : The SQL that failed was INSERT INTO bom SELECT 'TH-PMNT-401' AS parent, sequence, component, workcentreadded, loccode, effectiveafter, effectiveto, quantity, autoissue, remark, digitals, decimalplaces FROM bom WHERE parent='TH-PMNT-404';
Failed on multiple products; BOM's and item details look correct; maybe something to do with the remarks field.
Pls advise if need to add or edit some info to correct the error.
Thank you very much for any advice. very appreciated.
RE: Error 1054 when copying BOM to another product
In my opinion this field shouldn't be in the bom table. The sequence number of the item should be an integer. This complex solution to a non existent problem should be removed IMO