CDbException

CDbCommand не удалось исполнить SQL-запрос: SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine. The SQL statement executed was: SELECT `t`.`id` AS `t0_c0`, `t`.`blog_id` AS `t0_c1`, `t`.`create_user_id` AS `t0_c2`, `t`.`update_user_id` AS `t0_c3`, `t`.`create_date` AS `t0_c4`, `t`.`update_date` AS `t0_c5`, `t`.`publish_date` AS `t0_c6`, `t`.`slug` AS `t0_c7`, `t`.`lang` AS `t0_c8`, `t`.`title` AS `t0_c9`, `t`.`quote` AS `t0_c10`, `t`.`content` AS `t0_c11`, `t`.`link` AS `t0_c12`, `t`.`status` AS `t0_c13`, `t`.`comment_status` AS `t0_c14`, `t`.`create_user_ip` AS `t0_c15`, `t`.`access_type` AS `t0_c16`, `t`.`keywords` AS `t0_c17`, `t`.`description` AS `t0_c18`, `t`.`image` AS `t0_c19`, `t`.`category_id` AS `t0_c20`, `blog`.`id` AS `t1_c0`, `blog`.`category_id` AS `t1_c1`, `blog`.`name` AS `t1_c2`, `blog`.`description` AS `t1_c3`, `blog`.`icon` AS `t1_c4`, `blog`.`slug` AS `t1_c5`, `blog`.`lang` AS `t1_c6`, `blog`.`type` AS `t1_c7`, `blog`.`status` AS `t1_c8`, `blog`.`create_user_id` AS `t1_c9`, `blog`.`update_user_id` AS `t1_c10`, `blog`.`create_date` AS `t1_c11`, `blog`.`update_date` AS `t1_c12`, `blog`.`member_status` AS `t1_c13`, `blog`.`post_status` AS `t1_c14`, `createUser`.`id` AS `t2_c0`, `createUser`.`id_1c` AS `t2_c1`, `createUser`.`code` AS `t2_c2`, `createUser`.`change_date` AS `t2_c3`, `createUser`.`fio` AS `t2_c4`, `createUser`.`nick_name` AS `t2_c5`, `createUser`.`email` AS `t2_c6`, `createUser`.`gender` AS `t2_c7`, `createUser`.`birth_date` AS `t2_c8`, `createUser`.`site` AS `t2_c9`, `createUser`.`about` AS `t2_c10`, `createUser`.`location` AS `t2_c11`, `createUser`.`status` AS `t2_c12`, `createUser`.`access_level` AS `t2_c13`, `createUser`.`last_visit` AS `t2_c14`, `createUser`.`registration_date` AS `t2_c15`, `createUser`.`avatar` AS `t2_c16`, `createUser`.`hash` AS `t2_c17`, `createUser`.`email_confirm` AS `t2_c18`, `createUser`.`type_id` AS `t2_c19`, `createUser`.`phone` AS `t2_c20`, `createUser`.`card_number` AS `t2_c21`, `createUser`.`city_id` AS `t2_c22`, `createUser`.`phone_approve_stamp` AS `t2_c23`, `createUser`.`bonusBallsCount` AS `t2_c24`, `createUser`.`update_stamp` AS `t2_c25`, `createUser`.`refferer_id` AS `t2_c26`, `comments`.`id` AS `t3_c0`, `comments`.`parent_id` AS `t3_c1`, `comments`.`user_id` AS `t3_c2`, `comments`.`model` AS `t3_c3`, `comments`.`model_id` AS `t3_c4`, `comments`.`url` AS `t3_c5`, `comments`.`creation_date` AS `t3_c6`, `comments`.`name` AS `t3_c7`, `comments`.`email` AS `t3_c8`, `comments`.`text` AS `t3_c9`, `comments`.`status` AS `t3_c10`, `comments`.`ip` AS `t3_c11`, `comments`.`level` AS `t3_c12`, `comments`.`root` AS `t3_c13`, `comments`.`lft` AS `t3_c14`, `comments`.`rgt` AS `t3_c15`, `author`.`id` AS `t4_c0`, `author`.`id_1c` AS `t4_c1`, `author`.`code` AS `t4_c2`, `author`.`change_date` AS `t4_c3`, `author`.`fio` AS `t4_c4`, `author`.`nick_name` AS `t4_c5`, `author`.`email` AS `t4_c6`, `author`.`gender` AS `t4_c7`, `author`.`birth_date` AS `t4_c8`, `author`.`site` AS `t4_c9`, `author`.`about` AS `t4_c10`, `author`.`location` AS `t4_c11`, `author`.`status` AS `t4_c12`, `author`.`access_level` AS `t4_c13`, `author`.`last_visit` AS `t4_c14`, `author`.`registration_date` AS `t4_c15`, `author`.`avatar` AS `t4_c16`, `author`.`hash` AS `t4_c17`, `author`.`email_confirm` AS `t4_c18`, `author`.`type_id` AS `t4_c19`, `author`.`phone` AS `t4_c20`, `author`.`card_number` AS `t4_c21`, `author`.`city_id` AS `t4_c22`, `author`.`phone_approve_stamp` AS `t4_c23`, `author`.`bonusBallsCount` AS `t4_c24`, `author`.`update_stamp` AS `t4_c25`, `author`.`refferer_id` AS `t4_c26` FROM `blog_post` `t` LEFT OUTER JOIN `blog_blog` `blog` ON (`t`.`blog_id`=`blog`.`id`) LEFT OUTER JOIN `user_user` `createUser` ON (`t`.`create_user_id`=`createUser`.`id`) LEFT OUTER JOIN `comment_comment` `comments` ON (`comments`.`model_id`=`t`.`id`) AND (model = :model AND comments.status = :status) LEFT OUTER JOIN `user_user` `author` ON (`comments`.`user_id`=`author`.`id`) WHERE (((t.access_type = :access_type) AND (t.status = :status)) AND (t.slug = :slug)) ORDER BY comments.id. Bound with :access_type=1, :status=1, :slug='kak-prinimat-aminokisloty', :model='Post'

/var/www/fit4strong.ru/vendor/yiisoft/yii/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

#6
+
 /var/www/fit4strong.ru/protected/modules/blog/models/Post.php(517): CActiveRecord->find("t.slug = :slug", array(":slug" => "kak-prinimat-aminokisloty"))
512         }
513 
514         return Post::model()->public()->published()->with($with)->find('t.slug = :slug', array(
515                 ':slug' => $id
516             )
517         );
518     }
519 
520     public function getByTag($tag, array $with = array('blog', 'createUser', 'commentsCount'))
521     {
522         return Post::model()->with($with)
#7
+
 /var/www/fit4strong.ru/protected/modules/blog/controllers/PostController.php(29): Post->get("kak-prinimat-aminokisloty", array("blog", "createUser", "comments.author"))
24      * @throws CHttpException
25      * @return void
26      */
27     public function actionShow($slug)
28     {
29         $post = Post::model()->get($slug, array('blog', 'createUser', 'comments.author'));
30 
31         if (null === $post){
32             throw new CHttpException(404, Yii::t('BlogModule.blog', 'Post was not found!'));
33         }
34 
#17
+
 /var/www/fit4strong.ru/public/index.php(72): CApplication->run()
67 $confManager = new yupe\components\ConfigManager();
68 $config = $confManager->merge($base);
69 
70 require dirname(__FILE__).'/../vendor/autoload.php';
71 
72 Yii::createWebApplication($config)->run();
2024-03-30 00:29:27 nginx/1.2.1 Yii Framework/1.1.22