CDbException

CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Permission' in 'where clause'. The SQL statement executed was: SELECT COUNT(*) FROM (SELECT `t`.`cID` AS `t0_c0`, `t`.`cPID` AS `t0_c1`, `t`.`cUID` AS `t0_c2`, `t`.`cScenario` AS `t0_c3`, `t`.`cPublished` AS `t0_c4`, `t`.`cPublishedUID` AS `t0_c5`, `t`.`cDeleted` AS `t0_c6`, `t`.`cReferenceId` AS `t0_c7`, `t`.`cDate` AS `t0_c8`, `t`.`cLastUpdate` AS `t0_c9`, `t`.`cTitle` AS `t0_c10`, `t`.`cTeaser` AS `t0_c11`, `t`.`cText` AS `t0_c12`, `t`.`cLink` AS `t0_c13`, `t`.`cImage` AS `t0_c14`, `t`.`searchIndexUpdated` AS `t0_c15`, `t`.`useUserLogo` AS `t0_c16`, `cAllocated`.`caID` AS `t1_c0`, `cAllocated`.`caCID` AS `t1_c1`, `cAllocated`.`caPID` AS `t1_c2`, `BookDigest`.`cbdID` AS `t2_c0`, `BookDigest`.`cbdCID` AS `t2_c1`, `BookDigest`.`cbdUID` AS `t2_c2`, `BookDigest`.`cbdText` AS `t2_c3`, `BookDigest`.`cbdNumber` AS `t2_c4`, `AuthorID`.`cdID` AS `t3_c0`, `AuthorID`.`cdCID` AS `t3_c1`, `AuthorID`.`cdName` AS `t3_c2`, `AuthorID`.`cdData` AS `t3_c3`, `PublisherID`.`cdID` AS `t4_c0`, `PublisherID`.`cdCID` AS `t4_c1`, `PublisherID`.`cdName` AS `t4_c2`, `PublisherID`.`cdData` AS `t4_c3` FROM `content` `t` LEFT OUTER JOIN `content_allocated` `cAllocated` ON (`cAllocated`.`caCID`=`t`.`cID`) LEFT OUTER JOIN `content_bookdigest` `BookDigest` ON (`BookDigest`.`cbdCID`=`t`.`cID`) LEFT OUTER JOIN `content_data` `AuthorID` ON (`AuthorID`.`cdCID`=`t`.`cID`) LEFT OUTER JOIN `content_data` `PublisherID` ON (`PublisherID`.`cdCID`=`t`.`cID`) WHERE (cPublished="1" AND `cDate` <= NOW() AND cScenario="book" AND (`cPID`='mabo' OR cAllocated.`caPID`='mabo') AND (BookDigest.cbdUID=Permission%2520Marketing OR PublisherID.cdData=Permission%2520Marketing OR AuthorID.cdData=Permission%2520Marketing OR `cUID`=Permission%2520Marketing)) AND (AuthorID.cdName="Authors") AND (PublisherID.cdName="Publisher") GROUP BY cID) sq

/home/httpd/vhosts/marketing-boerse.de/20240318-153510/yii-1.1.29.f89b76/framework/yiilite.php(9763)

9751             return $result;
9752         }
9753         catch(Exception $e)
9754         {
9755             if($this->_connection->enableProfiling)
9756                 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query');
9757             $errorInfo=$e instanceof PDOException ? $e->errorInfo : null;
9758             $message=$e->getMessage();
9759             Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',
9760                 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
9761             if(YII_DEBUG)
9762                 $message.='. The SQL statement executed was: '.$this->getText().$par;
9763             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
9764                 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
9765         }
9766     }
9767     public function buildQuery($query)
9768     {
9769         $sql=!empty($query['distinct']) ? 'SELECT DISTINCT' : 'SELECT';
9770         $sql.=' '.(!empty($query['select']) ? $query['select'] : '*');
9771         if(!empty($query['from']))
9772             $sql.="\nFROM ".$query['from'];
9773         if(!empty($query['join']))
9774             $sql.="\n".(is_array($query['join']) ? implode("\n",$query['join']) : $query['join']);
9775         if(!empty($query['where']))

Stack Trace

#12
+
 /home/httpd/vhosts/marketing-boerse.de/20240318-153510/protected/vendors/Smarty/plugins/function.widget.php(34): CBaseController->widget()
29     if (isset($params['_name'])) {
30         $params['name'] = $params['_name'];
31         unset($params['_name']);
32     }
33     
34     return $controller_object->widget($widgetName, $params, true);
35 }
#13
+
 /home/httpd/vhosts/marketing-boerse.de/20240318-153510/protected/runtime/smarty/compiled/8985e8b6ad67eda21e030385ea8068c7d16ab7ad.file.list.tpl.php(72): smarty_function_widget()
67 
68     <div class="clear" style="width: 100%; height: 20px"> </div>
69 
70 
71     <?php ob_start();?><?php echo $_smarty_tpl->tpl_vars['this']->value->getCurView('_list');?>
72 <?php $_tmp2=ob_get_clean();?><?php ob_start();?>{<?php $_tmp3=ob_get_clean();?><?php ob_start();?>}<?php $_tmp4=ob_get_clean();?><?php ob_start();?>{<?php $_tmp5=ob_get_clean();?><?php ob_start();?>}<?php $_tmp6=ob_get_clean();?><?php echo smarty_function_widget(array('name'=>"CListViewUl",'dataProvider'=>$_smarty_tpl->tpl_vars['dataProvider']->value,'pager'=>array('header'=>'','prevPageLabel'=>'<<<','nextPageLabel'=>'>>>'),'htmlOptions'=>array('class'=>''),'itemView'=>$_tmp2,'template'=>"
73         
74         <div class=\"row\">
75          ".$_tmp3."items".$_tmp4."\n
76         </div>
77         ".$_tmp5."pager".$_tmp6."\n"),$_smarty_tpl);?>
#14
+
 /home/httpd/vhosts/marketing-boerse.de/20240318-153510/protected/vendors/Smarty/sysplugins/smarty_internal_templatebase.php(180): content_65f857e96dd8e7_62108163()
175                         }
176                         array_unshift($_template->_capture_stack,array());
177                         //
178                         // render compiled template
179                         //
180                         $_template->properties['unifunc']($_template);
181                         // any unclosed {capture} tags ?
182                         if (isset($_template->_capture_stack[0][0])) {
183                             $_template->capture_error();
184                         }
185                         array_shift($_template->_capture_stack);
2024-03-28 11:57:51 nginx/1.18.0 Yii Framework/1.1.29