CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[07002]: [Microsoft][ODBC Driver 11 for SQL Server]COUNT field incorrect or syntax error. The SQL statement executed was: SELECT count(*) as recordcount
FROM lime_conditions c, lime_questions q, lime_groups g
WHERE c.cqid=q.qid AND q.gid=g.gid AND q.parent_qid=0 AND q.language=:lang AND g.language=:lang AND c.qid=:qid AND c.scenario=:scenario AND c.cfieldname NOT LIKE '{%' . Bound with :scenario='1', :qid='2232', :lang='en'

D:\inetpub\wwwroot\survey\src\s\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
#0
+
D:\inetpub\wwwroot\survey\src\s\framework\db\CDbCommand.php(415): CDbCommand->queryInternal("fetch", array(2), array())
#1
–
D:\inetpub\wwwroot\survey\src\s\application\models\Condition.php(229): CDbCommand->queryRow()

224 ."AND c.cfieldname NOT LIKE '{%' "; // avoid catching SRCtokenAttr conditions
225 $result=Yii::app()->db->createCommand($query)
226 ->bindValue(":scenario", $scenarionr['scenario'])
227 ->bindValue(":qid", $qid, PDO::PARAM_INT)
228 ->bindValue(":lang", $language, PDO::PARAM_STR)
229 ->queryRow();
230 return (int) $result['recordcount'];
231 }
232
233 /*
234 @param int $qid

#2
–
D:\inetpub\wwwroot\survey\src\s\application\controllers\admin\conditionsaction.php(414): Condition->getConditionCount("2232", "en", Condition)

409 */
410 $aData['conditionHtml'] = '';
411
412 unset($currentfield);
413
414 $conditionscount = Condition::model()->getConditionCount($qid, $this->language, $scenarionr);
415 $conditions = Condition::model()->getConditions($qid, $this->language, $scenarionr);
416 $conditionscounttoken = Condition::model()->getConditionCountToken($qid, $scenarionr);
417 $resulttoken = Condition::model()->getConditionsToken($qid, $scenarionr);
418
419 $conditionscount = $conditionscount + $conditionscounttoken;

#3
unknown(0): conditionsaction->index("editconditionsform", "999999", "116", "2232")
#4
+
D:\inetpub\wwwroot\survey\src\s\framework\web\actions\CAction.php(109): ReflectionMethod->invokeArgs(conditionsaction, array("editconditionsform", "999999", "116", "2232"))
#5
–
D:\inetpub\wwwroot\survey\src\s\application\core\Survey_Common_Action.php(101): CAction->runWithParamsInternal(conditionsaction, ReflectionMethod, array("r" => "admin/conditions/sa/index/subaction/editconditionsform/surveyid/...", "sa" => "index", "subaction" => "editconditionsform", "surveyid" => "999999", ...))

096 $oMethod = new ReflectionMethod($this, $sDefault);
097 }
098
099 // We're all good to go, let's execute it
100 // runWithParamsInternal would automatically get the parameters of the method and populate them as required with the params
101 return parent::runWithParamsInternal($this, $oMethod, $params);
102 }
103
104 /*
105 Some functions have different parameters, which are just an alias of the
106 * usual parameters we're getting in the url. This function just populates

#6
+
D:\inetpub\wwwroot\survey\src\s\framework\web\CController.php(308): Survey_Common_Action->runWithParams(array("r" => "admin/conditions/sa/index/subaction/editconditionsform/surveyid/...", "sa" => "index", "subaction" => "editconditionsform", "surveyid" => "999999", ...))
#7
+
D:\inetpub\wwwroot\survey\src\s\framework\web\CController.php(286): CController->runAction(conditionsaction)
#8
+
D:\inetpub\wwwroot\survey\src\s\framework\web\CController.php(265): CController->runActionWithFilters(conditionsaction, array())
#9
+
D:\inetpub\wwwroot\survey\src\s\application\controllers\AdminController.php(177): CController->run("conditions")
#10
+
D:\inetpub\wwwroot\survey\src\s\framework\web\CWebApplication.php(282): AdminController->run("conditions")
#11
+
D:\inetpub\wwwroot\survey\src\s\framework\web\CWebApplication.php(141): CWebApplication->runController("admin/conditions/sa/index/subaction/editconditionsform/surveyid/...")
#12
+
D:\inetpub\wwwroot\survey\src\s\framework\base\CApplication.php(185): CWebApplication->processRequest()
#13
+
D:\inetpub\wwwroot\survey\src\s\index.php(214): CApplication->run()
2017-01-12 15:06:15 Microsoft-IIS/8.5 Yii Framework/1.1.17