CDbException

CDbCommand не удалось исполнить SQL-запрос: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/MYRCjMKG' (Errcode: 2 - No such file or directory). The SQL statement executed was: SELECT COUNT(*) FROM (SELECT `t`.`ads_id` AS `t0_c0`, `t`.`ads_group_id` AS `t0_c1`, `t`.`ads_type` AS `t0_c2`, `t`.`ads_name` AS `t0_c3`, `t`.`ads_description` AS `t0_c4`, `t`.`ads_image` AS `t0_c5`, `t`.`ads_status` AS `t0_c6`, `t`.`date_add` AS `t0_c7`, `t`.`ads_manager_id` AS `t0_c8`, `t`.`marka_id` AS `t0_c9`, `t`.`model_id` AS `t0_c10`, `t`.`category_name` AS `t0_c11`, `t`.`search_name` AS `t0_c12`, `t`.`search_articul` AS `t0_c13`, `t`.`search_product_id` AS `t0_c14`, `t`.`search_cross` AS `t0_c15`, `t`.`search_origin` AS `t0_c16`, `t`.`search_type` AS `t0_c17`, `t`.`search_status` AS `t0_c18`, `t`.`search_sklad` AS `t0_c19`, `t`.`search_photo` AS `t0_c20`, `t`.`default_sort` AS `t0_c21`, `t`.`search_await` AS `t0_c22`, `t`.`photo` AS `t0_c23`, `t`.`relevance` AS `t0_c24`, `t`.`sort` AS `t0_c25`, `t`.`search_manufacturer` AS `t0_c26`, `t`.`ads_description1` AS `t0_c27`, `t`.`meta_description` AS `t0_c28`, `t`.`meta_title` AS `t0_c29`, `t`.`ads_type_redirect` AS `t0_c30`, `t`.`ads_redirect_id` AS `t0_c31`, `groups`.`ads_id` AS `t1_c0`, `groups`.`group_id` AS `t1_c1` FROM `oc_ads` `t` LEFT JOIN `oc_ads_to_group` `groups` ON (`groups`.`ads_id`=`t`.`ads_id`) WHERE ((groups.group_id=:ycp0) AND (ads_status=1)) GROUP BY t.ads_id) sq

/home/admin/web/acomplect.com/public_html/framework/db/CDbCommand.php(543)

531         {
532             if($this->_connection->enableProfiling)
533                 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query');
534 
535             $errorInfo=$e instanceof PDOException ? $e->errorInfo : null;
536             $message=$e->getMessage();
537             Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',
538                 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
539 
540             if(YII_DEBUG)
541                 $message.='. The SQL statement executed was: '.$this->getText().$par;
542 
543             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
544                 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
545         }
546     }
547 
548     /**
549      * Builds a SQL SELECT statement from the given query specification.
550      * @param array $query the query specification in name-value pairs. The following
551      * query options are supported: {@link select}, {@link distinct}, {@link from},
552      * {@link where}, {@link join}, {@link group}, {@link having}, {@link order},
553      * {@link limit}, {@link offset} and {@link union}.
554      * @throws CDbException if "from" key is not present in given query parameter
555      * @return string the SQL statement

Stack Trace

#8
+
 /home/admin/web/acomplect.com/public_html/themes/default/views/ads/index.php(33): CDataProvider->getData()
28         }
29         if (!Yii::app()->params['keywords']) {
30             Yii::app()->params['keywords'] = $keywords;
31         }
32 
33         if ($d = $ads->getData()) {
34             foreach ($d as $v) {
35                 Yii::app()->params['description'] .= ',' . $v->ads_name;
36             }
37         }
38 
#13
+
 /home/admin/web/acomplect.com/public_html/protected/controllers/AdsController.php(471): CController->render("index", array("ads" => CActiveDataProvider, "current" => AdsGroup, "breadcrumbs" => array(array("link" => "/ads", "label" => "Запчасти"), array("link" => "/ads/zapchasti/perednij-most", "label" => "Передний мост")), "categories" => array(29 => AdsGroup), ...))
466                 'models' => [], //$this->getModels(),
467                 'markas' => [], //$this->getMarkas(),
468                 'marka' => $marka,
469                 'model' => $model,
470                 'urlParams' => $params,
471                 'urlSeoModel' => $urlSeoModel
472             ));
473         }
474         if (!Yii::app()->roles->isAdminOrManager() && !Yii::app()->request->isAjaxRequest){
475             $this->endCache();
476         }
#26
+
 /home/admin/web/acomplect.com/public_html/index.php(15): CApplication->run()
10 
11 require_once($yii);
12 $loader = require_once($composer);
13 Yii::$classMap = $loader->getClassMap();
14 
15 Yii::createWebApplication($config)->run();
2024-03-19 06:05:54 nginx/1.15.5 Yii Framework/1.1.16