Hideks Framework

Error

Ops!!

PDOException: SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'planetsex.filmes.fi_publicado' which is not in SELECT list; this is incompatible with DISTINCT in /var/www/html/planetsex.com.br/vendor/php-activerecord/php-activerecord/lib/Connection.php:322 Stack trace: #0 /var/www/html/planetsex.com.br/vendor/php-activerecord/php-activerecord/lib/Connection.php(322): PDOStatement->execute(Array) #1 /var/www/html/planetsex.com.br/vendor/php-activerecord/php-activerecord/lib/Table.php(218): ActiveRecord\Connection->query('SELECT distinct...', Array) #2 /var/www/html/planetsex.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/planetsex.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/planetsex.com.br/vendor/php-activerecord/php-activerecord/lib/Model.php(1395): call_user_func_array('static::find', Array) #6 /var/www/html/planetsex.com.br/application/models/Filme.php(63): ActiveRecord\Model::all(Array) #7 /var/www/html/planetsex.com.br/application/controllers/Garotas.php(190): Filme::listarFilmesAtriz(Object(Garotas), 0, 8, '70') #8 /var/www/html/planetsex.com.br/vendor/hidekscorporation/hideksframework/library/Hideks/Controller/Front.php(54): Garotas->selecionadoAction() #9 /var/www/html/planetsex.com.br/vendor/hidekscorporation/hideksframework/library/Hideks/Application/FrontController.php(93): Hideks\Controller\Front->dispatch() #10 /var/www/html/planetsex.com.br/vendor/hidekscorporation/hideksframework/library/Hideks/Application/Main.php(46): Hideks\Application\FrontController->dispatch() #11 /var/www/html/planetsex.com.br/vendor/hidekscorporation/hideksframework/library/Hideks/Application.php(84): Hideks\Application\Main->run() #12 /var/www/html/planetsex.com.br/public/index.php(28): Hideks\Application->run() #13 {main}

  • File: /vendor/php-activerecord/php-activerecord/lib/Connection.php

  • Line: 325

Learn more

Trace Route

# Function File Line
12 ActiveRecord\Connection->query(SELECT distinct(fi_id), fi_titulo, fi_descricao, fi_descricao_pequena FROM cenas_modelos LEFT JOIN cenas ON ce_id = c_m_ce_id LEFT JOIN filmes ON ce_fi_idFilmes = 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, fi_descricao_pequena FROM cenas_modelos LEFT JOIN cenas ON ce_id = c_m_ce_id LEFT JOIN filmes ON ce_fi_idFilmes = 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 63
6 Filme::listarFilmesAtriz(Array) /application/controllers/Garotas.php 190
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