object(PDOException)#37 (8) { ["message":protected]=> string(267) "SQLSTATE[42000]: Syntax error or access violation: 1064 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 'GROUP BY projectinstances.uid ORDER BY projectinstances.name ASC' at line 15" ["string":"Exception":private]=> string(0) "" ["code":protected]=> string(5) "42000" ["file":protected]=> string(52) "/home/egretwest/htdocs/Assembly/baconbytes/PDODB.php" ["line":protected]=> int(379) ["trace":"Exception":private]=> array(8) { [0]=> array(6) { ["file"]=> string(52) "/home/egretwest/htdocs/Assembly/baconbytes/PDODB.php" ["line"]=> int(379) ["function"]=> string(7) "execute" ["class"]=> string(12) "PDOStatement" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [1]=> array(6) { ["file"]=> string(52) "/home/egretwest/htdocs/Assembly/baconbytes/PDODB.php" ["line"]=> int(415) ["function"]=> string(7) "doQuery" ["class"]=> string(5) "PDODB" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> object(PDOStatement)#28 (1) { ["queryString"]=> string(880) "SELECT projectinstances.uid, projectinstances.name AS name, projectinstances.title AS title, projectinstances.seoname, projectinstances.featured, projectinstances.award, projectinstances.newsDate, GROUP_CONCAT(DISTINCT projectscategorieslink.projectcategories_uid) AS categories, GROUP_CONCAT(DISTINCT projectscategorieslink.projectcategories_uid) AS catids, (SELECT GROUP_CONCAT(pi.name) FROM widgets_wallitems_link LEFT JOIN projectinstances pi ON pi.uid = widgetID WHERE wallItemID= projectinstances.uid) as award FROM projectinstances LEFT JOIN projectscategorieslink ON projectscategorieslink.Projects_uid = projectinstances.uid WHERE GROUP BY projectinstances.uid ORDER BY projectinstances.name ASC " } } } [2]=> array(6) { ["file"]=> string(52) "/home/egretwest/htdocs/Assembly/baconbytes/PDODB.php" ["line"]=> int(442) ["function"]=> string(5) "query" ["class"]=> string(5) "PDODB" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> string(880) "SELECT projectinstances.uid, projectinstances.name AS name, projectinstances.title AS title, projectinstances.seoname, projectinstances.featured, projectinstances.award, projectinstances.newsDate, GROUP_CONCAT(DISTINCT projectscategorieslink.projectcategories_uid) AS categories, GROUP_CONCAT(DISTINCT projectscategorieslink.projectcategories_uid) AS catids, (SELECT GROUP_CONCAT(pi.name) FROM widgets_wallitems_link LEFT JOIN projectinstances pi ON pi.uid = widgetID WHERE wallItemID= projectinstances.uid) as award FROM projectinstances LEFT JOIN projectscategorieslink ON projectscategorieslink.Projects_uid = projectinstances.uid WHERE GROUP BY projectinstances.uid ORDER BY projectinstances.name ASC " [1]=> array(0) { } } } [3]=> array(6) { ["file"]=> string(55) "/home/egretwest/htdocs/application/model_core/Model.php" ["line"]=> int(77) ["function"]=> string(8) "fetchAll" ["class"]=> string(5) "PDODB" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> string(880) "SELECT projectinstances.uid, projectinstances.name AS name, projectinstances.title AS title, projectinstances.seoname, projectinstances.featured, projectinstances.award, projectinstances.newsDate, GROUP_CONCAT(DISTINCT projectscategorieslink.projectcategories_uid) AS categories, GROUP_CONCAT(DISTINCT projectscategorieslink.projectcategories_uid) AS catids, (SELECT GROUP_CONCAT(pi.name) FROM widgets_wallitems_link LEFT JOIN projectinstances pi ON pi.uid = widgetID WHERE wallItemID= projectinstances.uid) as award FROM projectinstances LEFT JOIN projectscategorieslink ON projectscategorieslink.Projects_uid = projectinstances.uid WHERE GROUP BY projectinstances.uid ORDER BY projectinstances.name ASC " [1]=> array(0) { } } } [4]=> array(6) { ["file"]=> string(63) "/home/egretwest/htdocs/application/models/ProjectsPageModel.php" ["line"]=> int(257) ["function"]=> string(5) "fetch" ["class"]=> string(5) "Model" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(880) "SELECT projectinstances.uid, projectinstances.name AS name, projectinstances.title AS title, projectinstances.seoname, projectinstances.featured, projectinstances.award, projectinstances.newsDate, GROUP_CONCAT(DISTINCT projectscategorieslink.projectcategories_uid) AS categories, GROUP_CONCAT(DISTINCT projectscategorieslink.projectcategories_uid) AS catids, (SELECT GROUP_CONCAT(pi.name) FROM widgets_wallitems_link LEFT JOIN projectinstances pi ON pi.uid = widgetID WHERE wallItemID= projectinstances.uid) as award FROM projectinstances LEFT JOIN projectscategorieslink ON projectscategorieslink.Projects_uid = projectinstances.uid WHERE GROUP BY projectinstances.uid ORDER BY projectinstances.name ASC " } } [5]=> array(6) { ["file"]=> string(60) "/home/egretwest/htdocs/application/frontend/ProjectsPage.php" ["line"]=> int(392) ["function"]=> string(19) "getDetailedProjects" ["class"]=> string(17) "ProjectsPageModel" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &array(0) { } } } [6]=> array(6) { ["file"]=> string(60) "/home/egretwest/htdocs/application/frontend/ProjectsPage.php" ["line"]=> int(72) ["function"]=> string(20) "handleProjectFilters" ["class"]=> string(12) "ProjectsPage" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &array(1) { [0]=> string(13) "project-wow_1" } } } [7]=> array(6) { ["file"]=> string(47) "/home/egretwest/htdocs/application/template.php" ["line"]=> int(88) ["function"]=> string(11) "__construct" ["class"]=> string(12) "ProjectsPage" ["type"]=> string(2) "->" ["args"]=> array(0) { } } } ["previous":"Exception":private]=> NULL ["errorInfo"]=> array(3) { [0]=> string(5) "42000" [1]=> int(1064) [2]=> string(211) "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 'GROUP BY projectinstances.uid ORDER BY projectinstances.name ASC' at line 15" } }
Notice: Undefined variable: projects in /home/egretwest/htdocs/application/models/ProjectsPageModel.php on line 265

Notice: Undefined variable: projects in /home/egretwest/htdocs/application/models/ProjectsPageModel.php on line 278

Notice: Undefined property: stdClass::$categories in /home/egretwest/htdocs/application/frontend/ProjectsPage.php on line 76

Warning: array_column() expects parameter 1 to be array, null given in /home/egretwest/htdocs/application/frontend/ProjectsPage.php on line 76

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 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 'AND wal.appID = 49 AND (publish = 1) GROUP BY ' at line 14' in /home/egretwest/htdocs/Assembly/baconbytes/PDODB.php:379 Stack trace: #0 /home/egretwest/htdocs/Assembly/baconbytes/PDODB.php(379): PDOStatement->execute() #1 /home/egretwest/htdocs/Assembly/baconbytes/PDODB.php(415): PDODB->doQuery(Object(PDOStatement)) #2 /home/egretwest/htdocs/Assembly/baconbytes/PDODB.php(442): PDODB->query('SELECT\r\n ...', Array) #3 /home/egretwest/htdocs/application/frontend/SEWBasicPage.php(61): PDODB->fetchAll('SELECT\r\n ...') #4 /home/egretwest/htdocs/application/frontend/ProjectsPage.php(91): SEWBasicPage->getWidgets(NULL, 'widget_pages_li...', 49) #5 /home/egretwest/htdocs/application/template.php(88): ProjectsPage->__construct() #6 {main in /home/egretwest/htdocs/Assembly/baconbytes/PDODB.php on line 379