CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[70100]: <<Unknown error>>: 1317 Query execution was interrupted. The SQL statement executed was: SELECT `t`.`pk` AS `t0_c0`, `t`.`CatalogNumber` AS `t0_c1`, `t`.`CatalogSeries` AS `t0_c2`, `t`.`Audio` AS `t0_c3`, `t`.`LabelName` AS `t0_c4`, `t`.`IssuingCompany` AS `t0_c5`, `t`.`IssueSeries` AS `t0_c6`, `t`.`IssueSubSeries` AS `t0_c7`, `t`.`Description` AS `t0_c8`, `t`.`AlbumNumber` AS `t0_c9`, `t`.`Size` AS `t0_c10`, `t`.`IssueDate` AS `t0_c11`, `t`.`IssueDateSort` AS `t0_c12`, `t`.`DeleteDate` AS `t0_c13`, `t`.`NumberSold` AS `t0_c14`, `t`.`TakeCount` AS `t0_c15`, `t`.`CatalogNumberNum` AS `t0_c16`, `t`.`Note` AS `t0_c17`, `t`.`LabelAndNumber` AS `t0_c18`, `t`.`NotIssued` AS `t0_c19`, `t`.`AlbumName` AS `t0_c20`, `t`.`UnIssuedFlag` AS `t0_c21`, `t`.`IssueSource` AS `t0_c22`, `t`.`DeleteSource` AS `t0_c23`, `t`.`UnUsedFlag` AS `t0_c24`, `t`.`NumberSoldSource` AS `t0_c25`, `t`.`FormatIssueSeries` AS `t0_c26`, `t`.`TMPforNotIssused` AS `t0_c27`, `t`.`Category` AS `t0_c28`, `t`.`MARC` AS `t0_c29`, `t`.`stamp` AS `t0_c30`, `t`.`MARC2SIDED` AS `t0_c31`, `t`.`doNotDisplay` AS `t0_c32`, `t`.`publicDomain` AS `t0_c33`, `t`.`f_web_featured_matrix` AS `t0_c34`, `t`.`LabelSort` AS `t0_c35`, `takes`.`pk` AS `t1_c0`, `takes`.`TakeDateSort` AS `t1_c1`, `takes`.`TakeNumber` AS `t1_c2`, `takes`.`Status` AS `t1_c3`, `takes`.`Audio` AS `t1_c4`, `takes`.`Label` AS `t1_c5`, `takes`.`Number` AS `t1_c6`, `takes`.`Size` AS `t1_c7`, `takes`.`PressingNote` AS `t1_c8`, `takes`.`TakePlace` AS `t1_c9`, `takes`.`fk_Matrix` AS `t1_c10`, `takes`.`fk_Object` AS `t1_c11`, `takes`.`TakeDate` AS `t1_c12`, `takes`.`add` AS `t1_c13`, `takes`.`TakeNumberNum` AS `t1_c14`, `takes`.`SortOrder` AS `t1_c15`, `takes`.`Author` AS `t1_c16`, `takes`.`Added` AS `t1_c17`, `takes`.`excludefromhome` AS `t1_c18`, `takes`.`HTML5url` AS `t1_c19`, `takes`.`HTML5urlDownload` AS `t1_c20`, `takes`.`fk_Geo` AS `t1_c21`, `takes`.`audioHideinPROD` AS `t1_c22`, `takes`.`f_SonyCredit` AS `t1_c23`, `takes`.`publicDomain` AS `t1_c24`, `matrix`.`pk` AS `t2_c0`, `matrix`.`MatrixNumber` AS `t2_c1`, `matrix`.`MarketingGenre` AS `t2_c2`, `matrix`.`Instrumentation` AS `t2_c3`, `matrix`.`Description` AS `t2_c4`, `matrix`.`Language` AS `t2_c5`, `matrix`.`TitleNote` AS `t2_c6`, `matrix`.`ComposerStatement` AS `t2_c7`, `matrix`.`ComposerStatementSource` AS `t2_c8`, `matrix`.`PrimaryTitle` AS `t2_c9`, `matrix`.`fk_MainTalent` AS `t2_c10`, `matrix`.`FirstTakeDate` AS `t2_c11`, `matrix`.`MainTalent` AS `t2_c12`, `matrix`.`MatrixNumberNum` AS `t2_c13`, `matrix`.`MatrixSeries` AS `t2_c14`, `matrix`.`MatrixSubSeries` AS `t2_c15`, `matrix`.`MainTalentDisplay` AS `t2_c16`, `matrix`.`DateGroup` AS `t2_c17`, `matrix`.`Type` AS `t2_c18`, `matrix`.`Published` AS `t2_c19`, `matrix`.`uniqueRecordings` AS `t2_c20`, `matrix`.`MasterSize` AS `t2_c21`, `matrix`.`FirstTakeDateText` AS `t2_c22`, `matrix`.`Source` AS `t2_c23`, `matrix`.`OCLC` AS `t2_c24`, `matrix`.`Company` AS `t2_c25`, `matrix`.`TitleSort` AS `t2_c26`, `matrix`.`count_Objects` AS `t2_c27`, `matrix`.`Audio` AS `t2_c28`, `matrix`.`RecordingSeries` AS `t2_c29`, `matrix`.`CompanySort` AS `t2_c30`, `matrix`.`Pressed` AS `t2_c31`, `matrix`.`HideFromDateBrowse` AS `t2_c32`, `matrix`.`youtubeurl` AS `t2_c33`, `matrix`.`youtubemessage` AS `t2_c34`, `matrix`.`youtubeignore` AS `t2_c35`, `matrix`.`cst_PT` AS `t2_c36`, `matrix`.`adp_media_url` AS `t2_c37`, `matrix`.`IAURL` AS `t2_c38`, `matrix`.`IAimageURL` AS `t2_c39`, `matrix`.`publicDomain` AS `t2_c40`, `matrix`.`f_web_featured_matrix` AS `t2_c41` FROM `Objects` `t` LEFT OUTER JOIN `Takes` `takes` ON (`takes`.`fk_Object`=`t`.`pk`) LEFT OUTER JOIN `Matrix` `matrix` ON (`takes`.`fk_Matrix`=`matrix`.`pk`) WHERE (`t`.`pk`=291115) ORDER BY matrix.MatrixNumberNum, SortOrder

/var/www/framework/db/CDbCommand.php(541)

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

Stack Trace

#6
+
 /var/www/html/protected/controllers/ObjectsController.php(95): CActiveRecord->findByPk("291115")
090      */
091     public function loadModel($id)
092     {
093         $model=Objects::model()->with(array(
094             'takes' => array('with' => 'matrix', 'order' => 'matrix.MatrixNumberNum, SortOrder')
095         ))->findByPk($id);
096         if($model===null)
097             throw new CHttpException(404,'The requested page does not exist.');
098         return $model;
099     }
100  
#7
+
 /var/www/html/protected/controllers/ObjectsController.php(41): ObjectsController->loadModel("291115")
36         $this->render('index', array('model' => $model, 'data' => $data, 'pageinfo' => $pageinfo));
37     }
38     
39     public function actionDetail($id) {
40         
41         $model = $this->loadModel($id);
42         $this->pageTitle = $model->ObjectHeading;
43         $navigation_links = Yii::app()->resultsCache->getPrevNext($id, 'Objects');
44 
45         $glossary = Glossary::model()->findAllByPk(array(1,2,9));
46        
#17
+
 /var/www/html/index.php(15): CApplication->run()
10 
11 // run Yii app
12 //$env->showDebug(); // show produced environment configuration
13 require_once($env->yiiPath);
14 $env->runYiiStatics(); // like Yii::setPathOfAlias()
15 Yii::createWebApplication($env->configWeb)->run();
2024-03-29 02:45:03 Apache/2.2.15 (CentOS) Yii Framework/1.1.13