Error 500
Server Error
Exception Traces
This will only be displayed in DEVELOPMENT_MODE.| Error 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 'group by area.idarea, area.descrizione_area, area.idarea_ref, ref.descrizione_ar' at line 10 |
|---|---|
| File | /var/www/html/app/models/PDODb.php On Line 1608 |
| Stack Trace |
1 /var/www/html/app/models/PDODb.php(1608): PDOStatement->execute() 2 /var/www/html/helpers/CustomControllerHelpers.php(331): PDODb->rawQuery('select area.idarea, area.descrizione_area, ifnull(area.idarea_ref,'') as idarea_ref, ifnull(ref.descrizione_area,'') as descrizione_area_ref, ifnull(GROUP_CONCAT(DISTINCT UPPER(CONCAT('(',addetto.addetto,') ', addetto.nome,' ',addetto.cognome )) SEPARATOR ' '),'') as addetti, ifnull(UPPER(CONCAT('(',resp.addetto,') ', resp.nome,' ',resp.cognome)),'') as responsabile from area left join addetto on area.idarea=addetto.idarea left join area as ref on area.idarea_ref = ref.idarea left join addetto as resp on area.idresponsabile = resp.idaddetto where area.idtitolare= group by area.idarea, area.descrizione_area, area.idarea_ref, ref.descrizione_area, responsabile') 3 /var/www/html/app/controllers/AreaController.php(349): organigrammaSetListDetail(PDODb, Array) 4 /var/www/html/system/Router.php(196): AreaController->organigramma() 5 /var/www/html/system/Router.php(109): Router->run('area/organigramma') 6 /var/www/html/index.php(106): Router->init() |