#8 'work order' tab causes SQL error

[David Gravereaux]

I get the following bomb when showing the work order tab:

Query failed:
SELECT wo.wo_id AS 'WO', wo.priority AS 'Priority', wo.equipment AS 'Equipment', wo.descriptive_text AS 'Description', wo.wo_status AS 'Status', wo.submit_date AS 'Submit Date', wo.complete_date AS 'Completed Date', m.lname AS 'Mechanic', m.fname, m.id, p.description as 'Priority' , m.lname, m.fname, m.id, p.description as description FROM work_orders AS wo LEFT JOIN mechanics AS m ON wo.mechanic_id = m.id LEFT JOIN priority AS p ON wo.priority = p.priority WHERE updated > 2006-12-31 15:32:20

I'll investigate further.

[David Gravereaux]

Logged In: YES
user_id=7549
Originator: YES

I found a newer fork of this project @ http://www.mycmms.org and here on SF. Search for project 'myCMMS'

Consider this issue closed for me.