PDOException: SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'buttman.filmes.fi_publicado' which is not in SELECT list; this is incompatible with DISTINCT in /var/www/html/buttman.com.br/vendor/php-activerecord/php-activerecord/lib/Connection.php:322 Stack trace: #0 /var/www/html/buttman.com.br/vendor/php-activerecord/php-activerecord/lib/Connection.php(322): PDOStatement->execute(Array) #1 /var/www/html/buttman.com.br/vendor/php-activerecord/php-activerecord/lib/Table.php(218): ActiveRecord\Connection->query('SELECT distinct...', Array) #2 /var/www/html/buttman.com.br/vendor/php-activerecord/php-activerecord/lib/Table.php(209): ActiveRecord\Table->find_by_sql('SELECT distinct...', Array, false, NULL) #3 /var/www/html/buttman.com.br/vendor/php-activerecord/php-activerecord/lib/Model.php(1567): ActiveRecord\Table->find(Array) #4 [internal function]: ActiveRecord\Model::find('all', Array) #5 /var/www/html/buttman.com.br/vendor/php-activerecord/php-activerecord/lib/Model.php(1395): call_user_func_array('static::find', Array) #6 /var/www/html/buttman.com.br/application/models/Filme.php(245): ActiveRecord\Model::all(Array) #7 /var/www/html/buttman.com.br/application/controllers/Garotas.php(186): Filme::listarFilmesAtriz(Object(Garotas), 0, 8, '13') #8 /var/www/html/buttman.com.br/vendor/hidekscorporation/hideksframework/library/Hideks/Controller/Front.php(54): Garotas->selecionadoAction() #9 /var/www/html/buttman.com.br/vendor/hidekscorporation/hideksframework/library/Hideks/Application/FrontController.php(93): Hideks\Controller\Front->dispatch() #10 /var/www/html/buttman.com.br/vendor/hidekscorporation/hideksframework/library/Hideks/Application/Main.php(46): Hideks\Application\FrontController->dispatch() #11 /var/www/html/buttman.com.br/vendor/hidekscorporation/hideksframework/library/Hideks/Application.php(84): Hideks\Application\Main->run() #12 /var/www/html/buttman.com.br/public/index.php(28): Hideks\Application->run() #13 {main}
File: /vendor/php-activerecord/php-activerecord/lib/Connection.php
Line: 325
| # | Function | File | Line |
|---|---|---|---|
| 12 | ActiveRecord\Connection->query(SELECT distinct(fi_id), fi_titulo, fi_descricao FROM cenas_modelos LEFT JOIN filmes_cenas ON c_m_ce_id = f_c_ce_id LEFT JOIN filmes ON fi_id = f_c_fi_id WHERE fi_ativo = 1 and fi_publicado <= NOW() and c_m_mo_id = ? ORDER BY fi_publicado desc LIMIT 0,8) | /vendor/php-activerecord/php-activerecord/lib/Table.php | 218 |
| 11 | ActiveRecord\Table->find_by_sql(SELECT distinct(fi_id), fi_titulo, fi_descricao FROM cenas_modelos LEFT JOIN filmes_cenas ON c_m_ce_id = f_c_ce_id LEFT JOIN filmes ON fi_id = f_c_fi_id WHERE fi_ativo = 1 and fi_publicado <= NOW() and c_m_mo_id = ? ORDER BY fi_publicado desc LIMIT 0,8) | /vendor/php-activerecord/php-activerecord/lib/Table.php | 209 |
| 10 | ActiveRecord\Table->find(Array) | /vendor/php-activerecord/php-activerecord/lib/Model.php | 1567 |
| 9 | ActiveRecord\Model::find(all) | ||
| 8 | call_user_func_array(static::find) | /vendor/php-activerecord/php-activerecord/lib/Model.php | 1395 |
| 7 | ActiveRecord\Model::all(Array) | /application/models/Filme.php | 245 |
| 6 | Filme::listarFilmesAtriz(Array) | /application/controllers/Garotas.php | 186 |
| 5 | Garotas->selecionadoAction() | /vendor/hidekscorporation/hideksframework/library/Hideks/Controller/Front.php | 54 |
| 4 | Hideks\Controller\Front->dispatch() | /vendor/hidekscorporation/hideksframework/library/Hideks/Application/FrontController.php | 93 |
| 3 | Hideks\Application\FrontController->dispatch() | /vendor/hidekscorporation/hideksframework/library/Hideks/Application/Main.php | 46 |
| 2 | Hideks\Application\Main->run() | /vendor/hidekscorporation/hideksframework/library/Hideks/Application.php | 84 |
| 1 | Hideks\Application->run() | /public/index.php | 28 |
| # | Function | File | Line |