/manufacturing/includes/db/work_order_issues_db.inc

We are closing this topic now, it is rather long.

Issue Items to Work Order

DATABASE ERROR : The work order issue could not be added
error code : 1064
error message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' '2', '2007/05/04', 'DEF', 1)' at line 2
sql that failed was : INSERT INTO 0_wo_issues (workorder_id, reference, issue_date, loc_code, workcentre_id) VALUES (, '2', '2007/05/04', 'DEF', 1)

There seems to be a problem with joins in version 5.0.12 of MySQL. Look at this topic, https://frontaccounting.com/punbb/viewtopic.php?id=13
This SQL statement is inside the file
/manufacturing/includes/db/work_order_requirements_db.inc in a function called get_wo_requirements:

function get_wo_requirements($woid)
{
    $sql = "SELECT ".TB_PREF."wo_requirements.*, ".TB_PREF."stock_master.description,
        ".TB_PREF."stock_master.mb_flag, 
        ".TB_PREF."locations.location_name, 
        ".TB_PREF."workcentres.name AS WorkCentreDescription FROM 
        ".TB_PREF."wo_requirements, ".TB_PREF."locations, ".TB_PREF."workcentres INNER JOIN ".TB_PREF."stock_master ON 
        ".TB_PREF."wo_requirements.stock_id = ".TB_PREF."stock_master.stock_id 
        WHERE workorder_id=$woid
        AND ".TB_PREF."locations.loc_code = ".TB_PREF."wo_requirements.loc_code
        AND ".TB_PREF."workcentres.id=CAST(workcentre AS UNSIGNED)";    

    return db_query($sql, "The work order requirements could not be retrieved");    
}

Put parentheses around the FROM tables

....... FROM (".TB_PREF."wo_requirements, ".TB_PREF."locations, ".TB_PREF."workcentres) 
INNER JOIN ".TB_PREF."stock_master ON .......

Please report if this helps!
New edited files with JOIN's from multiple tables will be put on the CVS on Sourceforge.

/includes/db/manufacturing_db.inc
/manufacturing/includes/db/work_order_requirements_db.inc

Admin

With new codes there is no error.
Thanks
shukla

function get_wo_requirements($woid)
{
    $sql = "SELECT ".TB_PREF."wo_requirements.*, ".TB_PREF."stock_master.description,
        ".TB_PREF."stock_master.mb_flag, 
        ".TB_PREF."locations.location_name, 
        ".TB_PREF."workcentres.name AS WorkCentreDescription FROM 
        ".TB_PREF."wo_requirements, ".TB_PREF."locations, ".TB_PREF."workcentres INNER JOIN ".TB_PREF."stock_master ON 
        ".TB_PREF."wo_requirements.stock_id = ".TB_PREF."stock_master.stock_id 
        WHERE workorder_id=$woid
        AND ".TB_PREF."locations.loc_code = ".TB_PREF."wo_requirements.loc_code
        AND ".TB_PREF."workcentres.id=CAST(workcentre AS UNSIGNED)";    

    return db_query($sql, "The work order requirements could not be retrieved");    
}

Put parentheses around the FROM tables

....... FROM (".TB_PREF."wo_requirements, ".TB_PREF."locations, ".TB_PREF."workcentres) 
INNER JOIN ".TB_PREF."stock_master ON .......

Please report if this helps!
New edited files with JOIN's from multiple tables will be put on the CVS on Sourceforge.

/includes/db/manufacturing_db.inc
/manufacturing/includes/db/work_order_requirements_db.inc

Admin

Work Order Requirements
DATABASE ERROR : The work order requirements could not be retrieved
error code : 1054
error message : Unknown column '0_wo_requirements.stock_id' in 'on clause'
sql that failed was : SELECT 0_wo_requirements.*, 0_stock_master.description, 0_stock_master.mb_flag, 0_locations.location_name, 0_workcentres.name AS WorkCentreDescription FROM 0_wo_requirements, 0_locations, 0_workcentres INNER JOIN 0_stock_master ON 0_wo_requirements.stock_id = 0_stock_master.stock_id WHERE workorder_id=8 AND 0_locations.loc_code = 0_wo_requirements.loc_code AND 0_workcentres.id=CAST(workcentre AS UNSIGNED)

We hope that this solves your problems.

Admin

We couldn't reproduce your first error (viewing the work order). Could you please, after downloading the affected files, tell us if the bug still exists. That is, try to enter a new work-order and view it.
If the bug still exists, please tell us exactly what you entered. That way we should be able to fix it rapidly.

Admin

DATABASE ERROR : The work order requirements could not be retrieved
error code : 1054
error message : Unknown column '0_wo_requirements.stock_id' in 'on clause'
sql that failed was : SELECT 0_wo_requirements.*, 0_stock_master.description, 0_stock_master.mb_flag, 0_locations.location_name, 0_workcentres.name AS WorkCentreDescription FROM 0_wo_requirements, 0_locations, 0_workcentres INNER JOIN 0_stock_master ON 0_wo_requirements.stock_id = 0_stock_master.stock_id WHERE workorder_id=10 AND 0_locations.loc_code = 0_wo_requirements.loc_code AND 0_workcentres.id=workcentre

When saving Work Order Entry, always showing multiple dialog box "bokade bom- cost 0", "bokade additional cost -35, acc = 1410", "bokade total- cost 35", before displaying the result screen saying "The work order been added."

Thanks in advance,
I'm looking forward to try out another enhancements.