Database Error
Error: SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'hydrobio.TaxonInvertebre.rang' which is not in SELECT list; this is incompatible with DISTINCT
SQL Query: SELECT DISTINCT `TaxonInvertebre`.`code_sandre`, `TaxonInvertebre`.`nom` FROM `hydrobio`.`releve_invertebre` AS `ReleveInvertebre` LEFT JOIN `hydrobio`.`taxon_invertebre` AS `TaxonInvertebre` ON (`TaxonInvertebre`.`code_sandre` = `ReleveInvertebre`.`code_sandre`) WHERE `ReleveInvertebre`.`liste_id` IN (15266, 15267, 15268, 15531, 15731, 15732, 15882, 16362, 16459, 16879, 16984, 18626, 20331, 28112, 31622) ORDER BY `TaxonInvertebre`.`rang` ASC
Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp
Stack Trace
- CORE/Cake/Model/Datasource/DboSource.php line 502 → PDOStatement->execute()
- CORE/Cake/Model/Datasource/DboSource.php line 468 → DboSource->_execute()
- CORE/Cake/Model/Datasource/DboSource.php line 715 → DboSource->execute()
- CORE/Cake/Model/Datasource/DboSource.php line 1226 → DboSource->fetchAll()
- CORE/Cake/Model/Model.php line 3053 → DboSource->read()
- CORE/Cake/Model/Model.php line 3025 → Model->_readDataSource()
- APP/Controller/ListesinvertebresController.php line 421 → Model->find()
- [internal function] → ListesinvertebresController->inventaire()
- CORE/Cake/Controller/Controller.php line 499 → ReflectionMethod->invokeArgs()
- CORE/Cake/Routing/Dispatcher.php line 193 → Controller->invokeAction()
- CORE/Cake/Routing/Dispatcher.php line 167 → Dispatcher->_invoke()
- APP/webroot/index.php line 110 → Dispatcher->dispatch()