CDbException

CDbCommand не удалось исполнить SQL-запрос: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'db1082218_advertisement.productspublish.pos' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by. The SQL statement executed was: SELECT `t`.`id` AS `t0_c0`, `t`.`cid` AS `t0_c1`, `t`.`title` AS `t0_c2`, `t`.`alias` AS `t0_c3`, `t`.`link` AS `t0_c4`, `t`.`link_title` AS `t0_c5`, `t`.`create_time` AS `t0_c6`, `t`.`status` AS `t0_c7`, `t`.`pos` AS `t0_c8`, `t`.`countproduct` AS `t0_c9`, `t`.`order_button` AS `t0_c10`, `t`.`order_text` AS `t0_c11`, `t`.`order_phone_city` AS `t0_c12`, `t`.`order_phone_mobile` AS `t0_c13`, `t`.`order_phone_whatsapp` AS `t0_c14`, `t`.`order_email` AS `t0_c15`, `t`.`order_position` AS `t0_c16`, `t`.`order_insta` AS `t0_c17`, count(productspublish.id) AS bbb FROM `tbl_company_line` `t` LEFT OUTER JOIN `tbl_company_product` `productspublish` ON (`productspublish`.`line_id`=`t`.`id`) WHERE ((t.id IN (:ycp0, :ycp1, :ycp2, :ycp3, :ycp4, :ycp5, :ycp6, :ycp7, :ycp8, :ycp9, :ycp10, :ycp11, :ycp12, :ycp13, :ycp14, :ycp15, :ycp16, :ycp17, :ycp18, :ycp19, :ycp20, :ycp21, :ycp22, :ycp23, :ycp24, :ycp25, :ycp26, :ycp27, :ycp28, :ycp29, :ycp30, :ycp31, :ycp32, :ycp33, :ycp34, :ycp35, :ycp36, :ycp37, :ycp38, :ycp39, :ycp40, :ycp41, :ycp42, :ycp43, :ycp44, :ycp45, :ycp46, :ycp47, :ycp48, :ycp49, :ycp50, :ycp51, :ycp52, :ycp53, :ycp54, :ycp55, :ycp56, :ycp57, :ycp58, :ycp59, :ycp60, :ycp61, :ycp62, :ycp63, :ycp64, :ycp65, :ycp66, :ycp67, :ycp68, :ycp69, :ycp70, :ycp71, :ycp72, :ycp73, :ycp74, :ycp75, :ycp76, :ycp77, :ycp78, :ycp79, :ycp80, :ycp81, :ycp82, :ycp83, :ycp84, :ycp85, :ycp86, :ycp87, :ycp88, :ycp89, :ycp90, :ycp91, :ycp92, :ycp93, :ycp94, :ycp95, :ycp96, :ycp97, :ycp98, :ycp99, :ycp100, :ycp101, :ycp102, :ycp103, :ycp104, :ycp105, :ycp106, :ycp107, :ycp108, :ycp109, :ycp110, :ycp111, :ycp112, :ycp113, :ycp114, :ycp115, :ycp116, :ycp117, :ycp118, :ycp119, :ycp120, :ycp121, :ycp122, :ycp123, :ycp124, :ycp125, :ycp126, :ycp127, :ycp128, :ycp129, :ycp130, :ycp131, :ycp132, :ycp133, :ycp134, :ycp135, :ycp136, :ycp137, :ycp138, :ycp139, :ycp140, :ycp141, :ycp142, :ycp143, :ycp144, :ycp145, :ycp146, :ycp147, :ycp148, :ycp149, :ycp150, :ycp151, :ycp152, :ycp153, :ycp154, :ycp155, :ycp156, :ycp157, :ycp158, :ycp159, :ycp160, :ycp161, :ycp162, :ycp163, :ycp164, :ycp165, :ycp166, :ycp167, :ycp168, :ycp169, :ycp170, :ycp171, :ycp172, :ycp173, :ycp174, :ycp175, :ycp176, :ycp177, :ycp178, :ycp179, :ycp180, :ycp181, :ycp182, :ycp183, :ycp184, :ycp185, :ycp186, :ycp187, :ycp188, :ycp189, :ycp190, :ycp191, :ycp192, :ycp193, :ycp194, :ycp195, :ycp196, :ycp197, :ycp198, :ycp199, :ycp200, :ycp201, :ycp202, :ycp203, :ycp204, :ycp205, :ycp206, :ycp207, :ycp208, :ycp209, :ycp210, :ycp211, :ycp212, :ycp213, :ycp214, :ycp215, :ycp216, :ycp217, :ycp218, :ycp219, :ycp220, :ycp221, :ycp222, :ycp223, :ycp224, :ycp225, :ycp226, :ycp227, :ycp228, :ycp229, :ycp230, :ycp231, :ycp232, :ycp233, :ycp234, :ycp235, :ycp236, :ycp237, :ycp238, :ycp239, :ycp240, :ycp241, :ycp242, :ycp243, :ycp244, :ycp245, :ycp246, :ycp247, :ycp248, :ycp249, :ycp250, :ycp251, :ycp252, :ycp253, :ycp254, :ycp255, :ycp256, :ycp257, :ycp258, :ycp259, :ycp260, :ycp261, :ycp262, :ycp263, :ycp264, :ycp265, :ycp266, :ycp267, :ycp268, :ycp269, :ycp270, :ycp271, :ycp272, :ycp273, :ycp274, :ycp275, :ycp276, :ycp277, :ycp278, :ycp279, :ycp280, :ycp281, :ycp282, :ycp283, :ycp284, :ycp285, :ycp286, :ycp287, :ycp288, :ycp289, :ycp290, :ycp291, :ycp292, :ycp293, :ycp294, :ycp295, :ycp296, :ycp297, :ycp298, :ycp299, :ycp300, :ycp301, :ycp302, :ycp303, :ycp304, :ycp305, :ycp306, :ycp307, :ycp308, :ycp309, :ycp310, :ycp311, :ycp312, :ycp313, :ycp314, :ycp315, :ycp316, :ycp317, :ycp318, :ycp319, :ycp320, :ycp321, :ycp322, :ycp323, :ycp324, :ycp325, :ycp326, :ycp327, :ycp328, :ycp329, :ycp330, :ycp331, :ycp332, :ycp333, :ycp334, :ycp335, :ycp336, :ycp337, :ycp338, :ycp339, :ycp340, :ycp341, :ycp342, :ycp343, :ycp344, :ycp345, :ycp346, :ycp347, :ycp348, :ycp349, :ycp350, :ycp351, :ycp352, :ycp353, :ycp354, :ycp355, :ycp356, :ycp357, :ycp358, :ycp359, :ycp360)) AND ((t.status=1))) AND (productspublish.status=1) GROUP BY t.id ORDER BY bbb DESC, productspublish.pos ASC LIMIT 50

/var/www/vhosts/customer/uralsk24.kz/httpdocs/protected/framework/db/CDbCommand.php(528)

516             return $result;
517         }
518         catch(Exception $e)
519         {
520             if($this->_connection->enableProfiling)
521                 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query');
522             $errorInfo = $e instanceof PDOException ? $e->errorInfo : null;
523             $message = $e->getMessage();
524             Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',
525                 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
526             if(YII_DEBUG)
527                 $message .= '. The SQL statement executed was: '.$this->getText().$par;
528             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
529                 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
530         }
531     }
532 
533     /**
534      * Builds a SQL SELECT statement from the given query specification.
535      * @param array $query the query specification in name-value pairs. The following
536      * query options are supported: {@link select}, {@link distinct}, {@link from},
537      * {@link where}, {@link join}, {@link group}, {@link having}, {@link order},
538      * {@link limit}, {@link offset} and {@link union}.
539      * @return string the SQL statement
540      * @since 1.1.6

Stack Trace

#6
+
 /var/www/vhosts/customer/uralsk24.kz/httpdocs/protected/controllers/CompanyController.php(107): CActiveRecord->findAll(CDbCriteria)
102         $criteria->group = 't.id';
103         $count = CompanyLine::model()->count($criteria);
104         $pages = new CPagination($count);
105         $pages->pageSize = 50;
106         $pages->applyLimit($criteria);
107         $models = CompanyLine::model()->findAll($criteria);
108         
109         $this->render('section',array(
110             'models'=>$models,
111             'pages'=>$pages,
112         ));
#21
+
 /var/www/vhosts/customer/uralsk24.kz/httpdocs/index.php(6): CApplication->run()
1 <?php
2 $yii=dirname(__FILE__).'/protected/framework/yii.php';
3 $config=dirname(__FILE__).'/protected/config/main.php';
4 define('YII_DEBUG', true);
5 require_once($yii);
6 Yii::createWebApplication($config)->run();
2024-03-19 19:03:39 Apache Yii Framework/1.1.12