search

uzerpllp / uzerp

uzERP - Open Source Business Management
http://www.uzerp.com
Other
55 stars 25 forks source link

Error when substituting item in structure #262

Closed steveblamey closed 2 years ago

steveblamey commented 2 years ago

When substituting an stock item in a structure, saving results in the an error:

SELECT COUNT(DISTINCT id)FROM mf_structuresoverview WHERE (usercompanyid = '1' AND (stitem_id = '' AND start_date <= '2022-10-25') AND (end_date >= '2022-10-25' OR end_date is NULL)) : ERROR: invalid input syntax for type integer: "" LINE 1: ...rview WHERE (usercompanyid = '1' AND (stitem_id = '' AND sta...

steveblamey commented 2 years ago

MfstructuresController::testCircularRef not called correctly from MfstructuresController::substitute. First param is structure object and should be structure record id (integer).