[ Closed ] Work Order

Thanks for the bug report. The last one with the debug boxes has been fixed.
Another bug, according the Issue link in Work Order Inquires, produced an empty screen, has been fixed.
Affected files:
/manufacturing/work_order_entry.php
/manufacturing/includes/work_order_issue_ui.inc
/manufacturing/includes/db/work_orders_quick_db.inc
Please check them out from the CVS repository on Sourceforge.

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

I had also also found error to get details of work order. error details given below. I am using latest checked out codes from CVS
--------------------------------------------------------------------------------------------------------------------
Work Order # 8
#     Reference     Type     Manufactured Item     Into Location     Date     Quantity
8     8     Assemble     001 - ABCD    PLACE     24/05/2007     1
This work order is closed.

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)

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