CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ','')))/length()+2*(length(t.teaser)-length(replace(t.teaser,,'')))/length()+1*(l' at line 1. The SQL statement executed was: SELECT * FROM `node` `t` WHERE tid <> 14 ORDER BY 3*(length(t.title)-length(replace(t.title,,'')))/length()+2*(length(t.teaser)-length(replace(t.teaser,,'')))/length()+1*(length(t.body)-length(replace(t.body,,'')))/length() desc LIMIT 27

/home/cvb255/apps/binoth/framework/db/CDbCommand.php(528)

516             return $result;
517         }
518         catch(Exception $e)
519         {
520             if($this->_connection->enableProfiling)
521                 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query');
522             $errorInfo = $e instanceof PDOException ? $e->errorInfo : null;
523             $message = $e->getMessage();
524             Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',
525                 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
526             if(YII_DEBUG)
527                 $message .= '. The SQL statement executed was: '.$this->getText().$par;
528             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
529                 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
530         }
531     }
532 
533     /**
534      * Builds a SQL SELECT statement from the given query specification.
535      * @param array $query the query specification in name-value pairs. The following
536      * query options are supported: {@link select}, {@link distinct}, {@link from},
537      * {@link where}, {@link join}, {@link group}, {@link having}, {@link order},
538      * {@link limit}, {@link offset} and {@link union}.
539      * @return string the SQL statement
540      * @since 1.1.6

Stack Trace

#9
+
 /home/cvb255/apps/binoth/protected/extensions/esearch/views/results.php(50): CBaseController->widget("zii.widgets.CListView", array("dataProvider" => CActiveDataProvider, "itemView" => "ext.esearch.views._result", "itemsCssClass" => "type-list-items-search", "pager" => array("cssFile" => "/themes/othemen/css/pager.css", "header" => false, "firstPageLabel" => "<<", "prevPageLabel" => "<", ...)))
45                                 'prevPageLabel' => Yii::t('app', 'Previous'),
46                                 'nextPageLabel' => Yii::t('app', 'Next'),
47                                 'lastPageLabel' => Yii::t('app', 'Last'),
48                             ),
49                                 ), $widgetParams
50                 ));
51                 ?>
52             </div>
53 
54     <?php
55 }
#14
+
 /home/cvb255/apps/binoth/protected/extensions/esearch/SearchAction.php(159): CController->render("ext.esearch.views.results", array("query" => null, "dataProvider" => CActiveDataProvider, "widget" => "zii.widgets.CListView", "widgetParams" => array()))
154 
155     public function run() {
156         $this->init();
157 
158         if ($this->output)
159             $this->controller->render($this->viewPath . $this->view, array('query' => $this->getQuery(), 'dataProvider' => $this->getDataProvider(), 'widget' => $this->widget, 'widgetParams' => $this->widgetParams));
160         else {
161 
162             $this->controller->renderPartial($this->viewPath . $this->view, array('query' => $this->getQuery(), 'dataProvider' => $this->getDataProvider(), 'widget' => $this->widget, 'widgetParams' => $this->widgetParams));
163         }
164     }
#22
+
 /home/cvb255/apps/binoth/index.php(20): CApplication->run()
15 defined('YII_DEBUG') or define('YII_DEBUG',false);
16 // specify how many levels of call stack should be shown in each log message
17 defined('YII_TRACE_LEVEL') or define('YII_TRACE_LEVEL',3);
18 
19 require_once($yii);
20 Yii::createWebApplication($config)->run();
21 
22 
23 //Yii::app()->assetManager->forceCopy = true; //to force relode assets files 
24 
2024-03-29 15:08:01 nginx/1.18.0 Yii Framework/1.1.12