Error 42000
SELECT FROM_UNIXTIME(published - 28800, '%Y %M') AS `date`, FROM_UNIXTIME(published - 28800, '%Y-%m') AS `date2`, COUNT(1) AS `total` FROM `wei_blog`.`post_index` WHERE (state > '0') AND (type_id IN('1', '3')) GROUP BY `date` ORDER BY `date` DESC LIMIT 15:SQLSTATE[42000]: Syntax error or access violation: 1055 'wei_blog.post_index.published' isn't in GROUP BY
... That didn't work on you? Dang. May we suggest a search, then?
Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1055 'wei_blog.post_index.published' isn't in GROUP BY in /opt/www/wei/lib/system/db/statement.php:82 Stack trace: #0 /opt/www/wei/lib/system/db/statement.php(82): PDOStatement->execute() #1 /opt/www/wei/lib/system/db/statement.php(60): system_db_statement->_execute() #2 /opt/www/wei/lib/system/db/adapter.php(284): system_db_statement->execute() #3 /opt/www/wei/lib/system/db/select.php(264): system_db_adapter->query() #4 /opt/www/wei/lib/system/db/select.php(664): system_db_select->query() #5 /opt/www/wei/lib/blog/post/model.php(84): system_db_select->fetchAll() #6 /opt/www/wei/app/view/www/block/archived.phtml(2): blog_post_model::archived() #7 /opt/www/wei/lib/system/view/abstract.php(132): include('...') #8 /opt/www/wei/app/view/www/layout/main.phtml(30): system_view_abstract->render() #9 /opt/www/wei/lib/system/view/abstract.php(132): include('...') #10 /opt/www/wei/app/view/www/layout.phtml(35): system_view_abstract->render() #11 /opt/www/wei/lib/system/view/abstract.php(132): include('...') #12 /opt/www/wei/app/view/helper/layout.phtml(60): system_view_abstract->render() #13 /opt/www/wei/lib/system/view/abstract.php(132): include('...') #14 /opt/www/wei/lib/system/view/layout.php(108): system_view_abstract->render() #15 /opt/www/wei/lib/system/controller/action.php(193): system_view_layout->render() #16 /opt/www/wei/lib/action/index.php(117): system_controller_action->render() #17 /opt/www/wei/app/controller/www/index.php(124): action_index::exception() #18 /opt/www/wei/lib/system/controller/action.php(113): controller_www_index->action_error() #19 /opt/www/wei/lib/system/controller/dispatcher.php(58): system_controller_action->dispatch() #20 /opt/www/wei/lib/system/controller/front.php(169): system_controller_dispatcher->dispatch() #21 /opt/www/wei/app/web.php(24): system_controller_front->dispatch() #22 /opt/www/wei/htdocs/www/index.php(4): require_once('...') #23 {main} Next system_db_exception: SELECT FROM_UNIXTIME(published - 28800, '%Y %M') AS `date`, FROM_UNIXTIME(published - 28800, '%Y-%m') AS `date2`, COUNT(1) AS `total` FROM `wei_blog`.`post_index` WHERE (state > '0') AND (type_id IN('1', '3')) GROUP BY `date` ORDER BY `date` DESC LIMIT 15:SQLSTATE[42000]: Syntax error or access violation: 1055 'wei_blog.post_index.published' isn't in GROUP BY in /opt/www/wei/lib/system/db/adapter.php:286 Stack trace: #0 /opt/www/wei/lib/system/db/select.php(264): system_db_adapter->query() #1 /opt/www/wei/lib/system/db/select.php(664): system_db_select->query() #2 /opt/www/wei/lib/blog/post/model.php(84): system_db_select->fetchAll() #3 /opt/www/wei/app/view/www/block/archived.phtml(2): blog_post_model::archived() #4 /opt/www/wei/lib/system/view/abstract.php(132): include('...') #5 /opt/www/wei/app/view/www/layout/main.phtml(30): system_view_abstract->render() #6 /opt/www/wei/lib/system/view/abstract.php(132): include('...') #7 /opt/www/wei/app/view/www/layout.phtml(35): system_view_abstract->render() #8 /opt/www/wei/lib/system/view/abstract.php(132): include('...') #9 /opt/www/wei/app/view/helper/layout.phtml(60): system_view_abstract->render() #10 /opt/www/wei/lib/system/view/abstract.php(132): include('...') #11 /opt/www/wei/lib/system/view/layout.php(108): system_view_abstract->render() #12 /opt/www/wei/lib/system/controller/action.php(193): system_view_layout->render() #13 /opt/www/wei/lib/action/index.php(117): system_controller_action->render() #14 /opt/www/wei/app/controller/www/index.php(124): action_index::exception() #15 /opt/www/wei/lib/system/controller/action.php(113): controller_www_index->action_error() #16 /opt/www/wei/lib/system/controller/dispatcher.php(58): system_controller_action->dispatch() #17 /opt/www/wei/lib/system/controller/front.php(169): system_controller_dispatcher->dispatch() #18 /opt/www/wei/app/web.php(24): system_controller_front->dispatch() #19 /opt/www/wei/htdocs/www/index.php(4): require_once('...') #20 {main} thrown in /opt/www/wei/lib/system/db/adapter.php on line 286
LaurenBrofe
На нашем сайте множество анкет <a href=>индивидуалки ростов на дону</a>
回复 6年前12月23日 78.107.195.137
ElzaKab
Hi, friends!
На нашем сайте множество анкет <a href=>индивидуалки ростова</a>
Все проститутки Ростова, разместившие на нашем сайте свои фото и анкеты, тщательно проверены. К Вам приедет конкретная проститутка, которую вы нашли на сайте. Анкета может быть создана и заполнена любой информацией и не обязательно настоящей.
回复 6年前12月20日 78.107.195.137
SexyLinaEmabs
Need money free ? Click here
Free money
回复 7年前1月13日 31.204.181.238
SexyLinaEmabs
Need followers on instagram fast and free ? Click here
Free followers instagram
回复 7年前1月12日 31.204.181.238
青锋幽灵
!!!!
回复 14年前9月10日 113.219.112.45
丽菲
Happy teacher's day.
回复 14年前10月24日 110.52.223.144