Accenture Survey
The LimeSurvey database is being upgraded (2014-07-23 12:10:08) .

Please be patient...

CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot insert explicit value for identity column in table 'lime_assessments' when IDENTITY_INSERT is set to OFF.. The SQL statement executed was: INSERT INTO [lime_assessments] ([id], [sid], [scope], [gid], [name], [minimum], [maximum], [message], [language]) VALUES (:id, :sid, :scope, :gid, :name, :minimum, :maximum, :message, :language)

C:\Users\IEUser\Documents\xampp\htdocs\lsold\framework\db\CDbCommand.php(354)

342             return $n;
343         }
344         catch(Exception $e)
345         {
346             if($this->_connection->enableProfiling)
347                 Yii::endProfile('system.db.CDbCommand.execute('.$this->getText().')','system.db.CDbCommand.execute');
348             $errorInfo = $e instanceof PDOException ? $e->errorInfo : null;
349             $message = $e->getMessage();
350             Yii::log(Yii::t('yii','CDbCommand::execute() failed: {error}. The SQL statement executed was: {sql}.',
351                 array('{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
352             if(YII_DEBUG)
353                 $message .= '. The SQL statement executed was: '.$this->getText().$par;
354             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
355                 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
356         }
357     }
358
359     /**
360      * Executes the SQL statement and returns query result.
361      * This method is for executing an SQL query that returns result set.
362      * @param array $params input parameters (name=>value) for the SQL execution. This is an alternative
363      * to {@link bindParam} and {@link bindValue}. If you have multiple input parameters, passing
364      * them in this way can improve the performance. Note that if you pass parameters in this way,
365      * you cannot bind parameters or values using {@link bindParam} or {@link bindValue}, and vice versa.
366      * binding methods and  the input parameters this way can improve the performance.
Stack Trace
#0
–  C:\Users\IEUser\Documents\xampp\htdocs\lsold\framework\db\CDbCommand.php(1178): CDbCommand->execute(array(":id" => "59", ":sid" => "85467", ":scope" => "T", ":gid" => "0", ...))
1173             }
1174         }
1175         $sql='INSERT INTO ' . $this->_connection->quoteTableName($table)
1176             . ' (' . implode(', ',$names) . ') VALUES ('
1177             . implode(', ', $placeholders) . ')';
1178         return $this->setText($sql)->execute($params);
1179     }
1180
1181     /**
1182      * Creates and executes an UPDATE SQL statement.
1183      * The method will properly escape the column names and bind the values to be updated.
#1
–  C:\Users\IEUser\Documents\xampp\htdocs\lsold\application\helpers\common_helper.php(6769): CDbCommand->insert("{{assessments}}", array("id" => "59", "sid" => "85467", "scope" => "T", "gid" => "0", ...))
6764                 'minimum' => $assessment['minimum'],
6765                 'maximum' => $assessment['maximum'],
6766                 'message' => $assessment['message'],
6767                 'language' => $lang
6768                 );
6769                 Yii::app()->db->createCommand()->insert('{{assessments}}', $data);
6770             }
6771         }
6772         reset($langs);
6773     }
6774
#2
–  C:\Users\IEUser\Documents\xampp\htdocs\lsold\application\helpers\update\updatedb_helper.php(1650): fixLanguageConsistency("85467", "cs ")
1645 {
1646     $surveyidquery = "SELECT sid,additional_languages FROM ".dbQuoteID('{{surveys}}');
1647     $surveyidresult = Yii::app()->db->createCommand($surveyidquery)->queryAll();
1648     foreach ( $surveyidresult as $sv )
1649     {
1650         fixLanguageConsistency($sv['sid'],$sv['additional_languages']);
1651     }
1652 }
1653
1654 function alterColumn($sTable, $sColumn, $sFieldType, $bAllowNull=true, $sDefault='NULL')
1655 {
#3
–  C:\Users\IEUser\Documents\xampp\htdocs\lsold\application\helpers\update\updatedb_helper.php(1061): fixLanguageConsistencyAllSurveys()
1056     {
1057        $oTransaction->rollback();
1058        echo '<br /><br />'.$clang->gT('An non-recoverable error happened during the update. Error details:')."<p>".htmlspecialchars($e->getMessage()).'</p><br />';
1059        return false;
1060     }
1061     fixLanguageConsistencyAllSurveys();
1062     echo '<br /><br />'.sprintf($clang->gT('Database update finished (%s)'),date('Y-m-d H:i:s')).'<br /><br />';
1063     return true;
1064 }
1065
1066 function upgradeSurveys156()
#4
–  C:\Users\IEUser\Documents\xampp\htdocs\lsold\application\helpers\update\update_helper.php(34): db_upgrade_all(155)
29         if(isset($subaction) && $subaction=="yes")
30         {
31             echo Yii::app()->getController()->_getAdminHeader();
32             echo "<div style='width:90%; padding:1% 5%;background-color:#eee;'>";
33             Yii::app()->loadHelper('update/updatedb');
34             $result=db_upgrade_all(intval($currentDBVersion));
35             if ($result)
36             {
37                 $data = "<br />".sprintf($clang->gT("Database has been successfully upgraded to version %s"),$dbversionnumber);
38                 $data .= "<br /><a href='".Yii::app()->getController()->createUrl("/admin")."'>".$clang->gT("Back to main menu")."</a></div>";
39             }
#5
–  C:\Users\IEUser\Documents\xampp\htdocs\lsold\application\controllers\admin\update.php(560): CheckForDBUpgrades("yes")
555     {
556         $clang = $this->getController()->lang;
557         Yii::app()->loadHelper("update/update");
558         if(isset($continue) && $continue=="yes")
559         {
560             $aViewUrls['output'] = CheckForDBUpgrades($continue);
561             updateCheck();
562             $aData['display']['header'] = false;
563         }
564         else
565         {
#6
 unknown(0): update->db("yes")
#7
+  C:\Users\IEUser\Documents\xampp\htdocs\lsold\framework\web\actions\CAction.php(107): ReflectionMethod->invokeArgs(update, array("yes"))
#8
+  C:\Users\IEUser\Documents\xampp\htdocs\lsold\application\core\Survey_Common_Action.php(100): CAction->runWithParamsInternal(update, ReflectionMethod, array("r" => "admin/update/sa/db/continue/yes", "sa" => "db", "continue" => "yes"))
#9
+  C:\Users\IEUser\Documents\xampp\htdocs\lsold\framework\web\CController.php(309): Survey_Common_Action->runWithParams(array("r" => "admin/update/sa/db/continue/yes", "sa" => "db", "continue" => "yes"))
#10
+  C:\Users\IEUser\Documents\xampp\htdocs\lsold\framework\web\CController.php(287): CController->runAction(update)
#11
+  C:\Users\IEUser\Documents\xampp\htdocs\lsold\framework\web\CController.php(266): CController->runActionWithFilters(update, array())
#12
+  C:\Users\IEUser\Documents\xampp\htdocs\lsold\application\controllers\AdminController.php(170): CController->run("update")
#13
+  C:\Users\IEUser\Documents\xampp\htdocs\lsold\framework\web\CWebApplication.php(276): AdminController->run("update")
#14
+  C:\Users\IEUser\Documents\xampp\htdocs\lsold\framework\web\CWebApplication.php(135): CWebApplication->runController("admin/update/sa/db/continue/yes")
#15
+  C:\Users\IEUser\Documents\xampp\htdocs\lsold\framework\base\CApplication.php(162): CWebApplication->processRequest()
#16
+  C:\Users\IEUser\Documents\xampp\htdocs\lsold\index.php(178): CApplication->run()
2014-07-23 12:12:38 Apache/2.4.9 (Win32) OpenSSL/0.9.8y PHP/5.4.27 Yii Framework/1.1.10