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 `canonical`.`id` AS `t1_c0`, `canonical`.`tbl_db_album_id` AS `t1_c1`, `canonical`.`name` AS `t1_c2`, `canonical`.`number` AS `t1_c3`, `canonical`.`text` AS `t1_c4`, `canonical`.`status` AS `t1_c5`, `canonical`.`create_at` AS `t1_c6`, `canonical`.`update_at` AS `t1_c7`, `canonical`.`canon_link` AS `t1_c8`, `canonical`.`link` AS `t1_c9`, `canonical`.`tbl_db_artist_id` AS `t1_c10`, `canonical`.`lock_version` AS `t1_c11`, `canonical`.`follow_links` AS `t1_c12` FROM `tbl_db_text` `canonical` LEFT OUTER JOIN `tbl_db_canonical` `text_canon` ON (`text_canon`.`tbl_db_canonical_id`=`canonical`.`id`) WHERE (`text_canon`.`tbl_db_text_id`=:ypl0) ORDER BY canonical.name ASC. Bound with :ypl0='2544860'

/home/www/new.stlyrics.com/html/themes/front/views/songs/artist/_text_item.php(12)

01 <?php if ($data['cc'] > 0): ?>
02 <hr>
03 <h2 id="<?php echo $data['a_id']; ?>">Lyrics for album: <?php echo CHtml::encode($data['a_name']).(($data['a_year'] != 0 && $data['a_year'] < 2100) ? " ({$data['a_year']})" : ''); ?></h2>
04 
05 <div class="list-group songArtist">  
06     <?php
07 
08     $itemCount = count($data['txt']);
09     $index = 0;
10     foreach ($texts as $model) {
11         if(in_array($model->id, $data['txt'])):
12             if (($c = $model->canonical->fronturi) === null) $c = $model->fronturi;
13         
14             ?>
15 
16             <<?php echo !$model->isnoindex ? 'a'. $model -> nofollow : 'div';?> <?php echo !$model->isnoindex ? 'href="'.$c.'"' : '';  ?> class="list-group-item <?php echo !$model->isnoindex ? '' : 'disabled';  ?>">
17                 <div class="h4"><span class="pull-right icon">&rsaquo;</span><?php echo CHtml::encode($model->iname); ?></div>
18             </<?php echo !$model->isnoindex ? 'a' : 'div';?>>
19 
20             <?php                    
21             endif;
22     }         
23     ?>
24 </div>

Stack Trace

#6
+
 /home/www/new.stlyrics.com/html/themes/front/views/songs/artist/_text_item.php(12): CActiveRecord->__get("canonical")
07 
08     $itemCount = count($data['txt']);
09     $index = 0;
10     foreach ($texts as $model) {
11         if(in_array($model->id, $data['txt'])):
12             if (($c = $model->canonical->fronturi) === null) $c = $model->fronturi;
13         
14             ?>
15 
16             <<?php echo !$model->isnoindex ? 'a'. $model -> nofollow : 'div';?> <?php echo !$model->isnoindex ? 'href="'.$c.'"' : '';  ?> class="list-group-item <?php echo !$model->isnoindex ? '' : 'disabled';  ?>">
17                 <div class="h4"><span class="pull-right icon">&rsaquo;</span><?php echo CHtml::encode($model->iname); ?></div>
#13
+
 /home/www/new.stlyrics.com/html/protected/components/SimpleListView.php(31): CBaseListView->renderContent()
26      * Override CListView::run() to prevent registration of client script.
27      */
28     public function run()
29     {
30         echo CHtml::openTag($this->tagName,$this->htmlOptions)."\n";
31         $this->renderContent();
32         echo CHtml::closeTag($this->tagName);
33     }
34 }
#15
+
 /home/www/new.stlyrics.com/html/themes/front/views/songs/artist/index.php(167): CBaseController->widget("SimpleListView", array("id" => "body65f951b93561b", "dataProvider" => CArrayDataProvider, "itemView" => "_text_item", "template" => "{items}", ...))
162         'pager'=>array(
163             'header' => false
164         ),
165         'itemsCssClass' => 'list-group',
166         'htmlOptions' => array('class' => ''),        
167     ));
168     $this->endCache();
169 }                      
170 ?>              
171 
172 <br><br>
2024-03-19 04:50:01 Apache/2.2.15 Yii Framework/1.1.14