I am getting this error when I try and export my project tasks:
Error exporting ProjectTask:
.SELECT project_task.*, users.user_name as assigned_user_name ,project_task_cstm.component_c FROM project_task LEFT JOIN project_task_cstm ON project_task.id = project_task_cstm.id_c LEFT JOIN users ON project_task.assigned_user_id=users.id where ((project.name like 'my project%')) AND project_task.deleted=0 Query Failed:SELECT project_task.*, users.user_name as assigned_user_name ,project_task_cstm.component_c FROM project_task LEFT JOIN project_task_cstm ON project_task.id = project_task_cstm.id_c LEFT JOIN users ON project_task.assigned_user_id=users.id where ((project.name like 'my project%')) AND project_task.deleted=0 ::MySQL error 1109: Unknown table 'project' in where clause
Unfortunately there's no file/line number reference so I don't even have the slightest idea where to start looking for a problem. Any ideas?


LinkBack URL
About LinkBacks



Reply With Quote
Bookmarks