CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'artstl.tbl_db_canonical' doesn't exist. The SQL statement executed was: SELECT `t`.`id`, `t`.`tbl_db_album_id`, `t`.`name`, `t`.`number`, `t`.`text`, `t`.`status`, `t`.`create_at`, `t`.`update_at`, `t`.`canon_link`, `t`.`link`, `t`.`tbl_db_artist_id`, `t`.`lock_version`, `t`.`follow_links` FROM `tbl_db_text` `t` left join tbl_db_canonical as c on c.tbl_db_text_id = t.id WHERE (t.tbl_db_artist_id=:artistid) AND (((c.tbl_db_canonical_id IS NULL) AND (t.id > 2065859)) AND (t.text <> '' AND t.text is not null)) ORDER BY t.id ASC, t.name ASC LIMIT 1. Bound with :artistid='48666'

/home/www/new.stlyrics.com/html/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

#3
+
 /home/www/new.stlyrics.com/html/themes/front/widgets/NextSong.php(105): CActiveRecord->find(CDbCriteria)
100         $criteria -> addCondition("c.tbl_db_canonical_id IS NULL");
101         $criteria -> addCondition("t.id > {$this->near_id_search}");
102         $criteria -> addCondition("t.text <> '' AND t.text is not null");
103         $criteria -> order = 't.id ASC';
104 
105         $next_song = DbText::model()->artistid($this->model->id)->find($criteria);
106 
107         if ($next_song == null) {
108             $criteria = new CDbCriteria();
109             $criteria -> join = 'left join tbl_db_canonical as c on c.tbl_db_text_id = t.id ';
110             $criteria -> addCondition("c.tbl_db_canonical_id IS NULL");
#4
+
 /home/www/new.stlyrics.com/html/themes/front/widgets/NextSong.php(60): NextSong->process()
55     */
56     public function run()
57     {
58         if($this->beginCache(su($this->model->name.$this->near_id_search.Yii::app()->theme->name.'v0.1.2'), array('varyByRoute'=>false, 'varyBySession'=>false, 'duration'=>60*60*24*7))) {
59 
60             $this->process();
61             if ($this->model==null) $this->_status = self::NO_ITEMS;
62             if ($this->_status === self::OK) {
63                  echo "<a class=\"pull-left\" href=\"{$this->data['prev_uri']}\"><span class=\"pull-left l\">&lsaquo;</span> {$this->data['prev_song']}</a><a class=\"pull-right\" href=\"{$this->data['next_uri']}\">{$this->data['next_song']} <span class=\"pull-right r\">&rsaquo;</span></a>";
64             } 
65             $this->endCache();
#6
+
 /home/www/new.stlyrics.com/html/themes/front/views/songs/text/index.php(268): CBaseController->widget("webroot.themes.front.widgets.NextSong", array("model" => DbArtist, "near_id_search" => "2065859"))
263 
264 <div class="row">
265     <div class="col-xs-12 song-navigation">
266         <!-- Navigation below song of artist db -->
267 
268         <?php $this->widget('webroot.themes.'.Yii::app()->theme->name.'.widgets.NextSong', array('model' => $model->artist, 'near_id_search' => $model->id)); ?>
269     </div>
270 </div>
271 
272 <br>
273 
2024-03-19 00:00:01 Apache/2.2.15 Yii Framework/1.1.14