2015-06-30 13:20:15.306 ***** ERROR ***** Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pe.idResource' in 'where clause' 2015-06-30 13:20:15.317 ***** ERROR ***** For query : select pe.idProject as idProj, pe.id idPe, pe.wbs wbs, pe.wbsSortable wbsSortable, pe.priority priority, pe.idplanningmode idplanningmode, pe.validatedenddate, pe.notplannedwork, ass.* , usr.fullName as name, pe.refName refName from orgplanningelement pe, orgassignment ass, orgresource usr where pe.refType=ass.refType and pe.RefId=ass.refId and usr.id=ass.idResource and ass.plannedWork>0 and (pe.idProject not in (0) or pe.idProject is null) and (pe.idProject not in (0) or (pe.idResource='1')) and (pe.idProject not in (0) or (pe.idUser='1')) and pe.idProject in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30) and pe.idProject not in (0) order by name, pe.wbsSortable 2015-06-30 13:20:15.318 ***** ERROR ***** Strack trace : 2015-06-30 13:20:15.319 ***** ERROR ***** #0 Sql->query called at [/home/xxxxx/projeqtor/tool/jsonResourcePlanning.php:146] 2015-06-30 13:20:15.319 ***** ERROR ***** #1 include called at [/home/xxxxx/projeqtor/view/resourcePlanningList.php:284] 2015-06-30 13:20:15.319 ***** ERROR ***** #2 include called at [/home/xxxxx/projeqtor/view/resourcePlanningMain.php:37] 2015-06-30 13:27:29.531 ***** ERROR ***** Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pe.idResource' in 'where clause' 2015-06-30 13:27:29.533 ***** ERROR ***** For query : select pe.idProject as idProj, pe.id idPe, pe.wbs wbs, pe.wbsSortable wbsSortable, pe.priority priority, pe.idplanningmode idplanningmode, pe.validatedenddate, pe.notplannedwork, ass.* , usr.fullName as name, pe.refName refName from orgplanningelement pe, orgassignment ass, orgresource usr where pe.refType=ass.refType and pe.RefId=ass.refId and usr.id=ass.idResource and ass.plannedWork>0 and (pe.idProject not in (0) or pe.idProject is null) and (pe.idProject not in (0) or (pe.idResource='1')) and (pe.idProject not in (0) or (pe.idUser='1')) and pe.idProject in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30) and pe.idProject not in (0) order by name, pe.wbsSortable 2015-06-30 13:27:29.534 ***** ERROR ***** Strack trace : 2015-06-30 13:27:29.535 ***** ERROR ***** #0 Sql->query called at [/home/xxxxx/projeqtor/tool/jsonResourcePlanning.php:146] 2015-06-30 13:27:36.972 ***** ERROR ***** Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pe.idResource' in 'where clause' 2015-06-30 13:27:36.974 ***** ERROR ***** For query : select pe.idProject as idProj, pe.id idPe, pe.wbs wbs, pe.wbsSortable wbsSortable, pe.priority priority, pe.idplanningmode idplanningmode, pe.validatedenddate, pe.notplannedwork, ass.* , usr.fullName as name, pe.refName refName from orgplanningelement pe, orgassignment ass, orgresource usr where pe.refType=ass.refType and pe.RefId=ass.refId and usr.id=ass.idResource and ass.plannedWork>0 and (pe.idProject not in (0) or pe.idProject is null) and (pe.idProject not in (0) or (pe.idResource='1')) and (pe.idProject not in (0) or (pe.idUser='1')) and pe.idProject in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30) and pe.idProject not in (0) order by name, pe.wbsSortable 2015-06-30 13:27:36.974 ***** ERROR ***** Strack trace : 2015-06-30 13:27:36.975 ***** ERROR ***** #0 Sql->query called at [/home/xxxxx/projeqtor/tool/jsonResourcePlanning.php:146] 2015-06-30 13:27:36.976 ***** ERROR ***** #1 include called at [/home/xxxxx/projeqtor/view/resourcePlanningList.php:284] 2015-06-30 13:27:36.976 ***** ERROR ***** #2 include called at [/home/xxxxx/projeqtor/view/resourcePlanningMain.php:37] 2015-06-30 13:46:33.062 ***** ERROR ***** Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pe.idResource' in 'where clause' 2015-06-30 13:46:33.064 ***** ERROR ***** For query : select pe.idProject as idProj, pe.id idPe, pe.wbs wbs, pe.wbsSortable wbsSortable, pe.priority priority, pe.idplanningmode idplanningmode, pe.validatedenddate, pe.notplannedwork, ass.* , usr.fullName as name, pe.refName refName from orgplanningelement pe, orgassignment ass, orgresource usr where pe.refType=ass.refType and pe.RefId=ass.refId and usr.id=ass.idResource and ass.plannedWork>0 and (pe.idProject not in (0) or pe.idProject is null) and (pe.idProject not in (0) or (pe.idResource='1')) and (pe.idProject not in (0) or (pe.idUser='1')) and pe.idProject in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30) and pe.idProject not in (0) order by name, pe.wbsSortable 2015-06-30 13:46:33.065 ***** ERROR ***** Strack trace : 2015-06-30 13:46:33.065 ***** ERROR ***** #0 Sql->query called at [/home/xxxxx/projeqtor/tool/jsonResourcePlanning.php:146] 2015-06-30 13:46:33.065 ***** ERROR ***** #1 include called at [/home/xxxxx/projeqtor/view/resourcePlanningList.php:284] 2015-06-30 13:46:33.066 ***** ERROR ***** #2 include called at [/home/xxxxx/projeqtor/view/resourcePlanningMain.php:37] 2015-06-30 15:17:02.566 ***** ERROR ***** Exception-[42S22] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'pe.idResource' in 'where clause' 2015-06-30 15:17:02.578 ***** ERROR ***** For query : select pe.idProject as idProj, pe.id idPe, pe.wbs wbs, pe.wbsSortable wbsSortable, pe.priority priority, pe.idplanningmode idplanningmode, pe.validatedenddate, pe.notplannedwork, ass.* , usr.fullName as name, pe.refName refName from orgplanningelement pe, orgassignment ass, orgresource usr where pe.refType=ass.refType and pe.RefId=ass.refId and usr.id=ass.idResource and ass.plannedWork>0 and (pe.idProject not in (0) or pe.idProject is null) and (pe.idProject not in (0) or (pe.idResource='1')) and (pe.idProject not in (0) or (pe.idUser='1')) and pe.idProject in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30) and pe.idProject not in (0) order by name, pe.wbsSortable 2015-06-30 15:17:02.579 ***** ERROR ***** Strack trace : 2015-06-30 15:17:02.579 ***** ERROR ***** #0 Sql->query called at [/home/xxxxx/projeqtor/tool/jsonResourcePlanning.php:146] 2015-06-30 15:17:02.580 ***** ERROR ***** #1 include called at [/home/xxxxx/projeqtor/view/resourcePlanningList.php:284] 2015-06-30 15:17:02.580 ***** ERROR ***** #2 include called at [/home/xxxxx/projeqtor/view/resourcePlanningMain.php:37]