CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[22001]: [Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated.. The SQL statement executed was: INSERT INTO [dbo].[lime_surveys] ([admin], [active], [startdate], [expires], [adminemail], [anonymized], [faxto], [format], [savetimings], [template], [language], [additional_languages], [datestamp], [usecookie], [allowregister], [allowsave], [autonumber_start], [autoredirect], [showxquestions], [showgroupinfo], [shownoanswer], [showqnumcode], [showwelcome], [allowprev], [printanswers], [ipaddr], [refurl], [datecreated], [listpublic], [publicstatistics], [publicgraphs], [htmlemail], [sendconfirmation], [tokenanswerspersistence], [assessments], [usecaptcha], [usetokens], [bounce_email], [tokenlength], [bounceprocessing], [bounceaccounttype], [bounceaccounthost], [bounceaccountuser], [bounceaccountpass], [bounceaccountencryption], [showprogress], [allowjumps], [navigationdelay], [nokeyboard], [alloweditaftercompletion], [googleanalyticsstyle], [googleanalyticsapikey], [owner_id], [emailnotificationto], [emailresponseto], [sid]) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13, :yp14, :yp15, :yp16, :yp17, :yp18, :yp19, :yp20, :yp21, :yp22, :yp23, :yp24, :yp25, :yp26, :yp27, :yp28, :yp29, :yp30, :yp31, :yp32, :yp33, :yp34, :yp35, :yp36, :yp37, :yp38, :yp39, :yp40, :yp41, :yp42, :yp43, :yp44, :yp45, :yp46, :yp47, :yp48, :yp49, :yp50, :yp51, :yp52, :yp53, :yp54, :yp55)

C:\inetpub\wwwroot\limesurvey2\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:\inetpub\wwwroot\limesurvey2\framework\db\ar\CActiveRecord.php(1014): CDbCommand->execute()
#1 + C:\inetpub\wwwroot\limesurvey2\framework\db\ar\CActiveRecord.php(787): CActiveRecord->insert(null)
#2 – C:\inetpub\wwwroot\limesurvey2\application\models\Survey.php(201): CActiveRecord->save()
196 }
197
198 $survey = new self;
199 foreach ($data as $k => $v)
200 $survey->$k = $v;
201 $survey->save();
202 return $data['sid'];
203 }
204
205 /*
206 Deletes a survey and all its data
#3 – C:\inetpub\wwwroot\limesurvey2\application\controllers\admin\surveyadmin.php(1548): Survey->insertNewSurvey(array("expires" => "", "startdate" => "", "template" => "default", "owner_id" => 1, ...), false)
1543 if (!is_null($iSurveyId))
1544 {
1545 $aInsertData['wishSID'] = $iSurveyId;
1546 }
1547
1548 $iNewSurveyid = Survey::model()->insertNewSurvey($aInsertData, $xssfilter);
1549 if (!$iNewSurveyid)
1550 die('Survey could not be created.');
1551
1552 // Prepare locale data for surveys_language_settings table
1553 $sTitle = $_POST['surveyls_title'];
#4 unknown(0): SurveyAdmin->insert(null)
#5 + C:\inetpub\wwwroot\limesurvey2\framework\web\actions\CAction.php(107): ReflectionMethod->invokeArgs(SurveyAdmin, array(null))
#6 – C:\inetpub\wwwroot\limesurvey2\application\core\Survey_Common_Action.php(82): CAction->runWithParamsInternal(SurveyAdmin, ReflectionMethod, array("sa" => "insert"))
77 $oMethod = new ReflectionMethod($this, $sDefault);
78 }
79
80 // We're all good to go, let's execute it
81 // runWithParamsInternal would automatically get the parameters of the method and populate them as required with the params
82 return parent::runWithParamsInternal($this, $oMethod, $params);
83 }
84
85 /
86 Some functions have different parameters, which are just an alias of the
87 usual parameters we're getting in the url. This function just populates
#7 + C:\inetpub\wwwroot\limesurvey2\framework\web\CController.php(309): Survey_Common_Action->runWithParams(array("sa" => "insert"))
#8 + C:\inetpub\wwwroot\limesurvey2\framework\web\CController.php(287): CController->runAction(SurveyAdmin)
#9 + C:\inetpub\wwwroot\limesurvey2\framework\web\CController.php(266): CController->runActionWithFilters(SurveyAdmin, array())
#10 + C:\inetpub\wwwroot\limesurvey2\application\controllers\AdminController.php(158): CController->run("survey")
#11 + C:\inetpub\wwwroot\limesurvey2\framework\web\CWebApplication.php(276): AdminController->run("survey")
#12 + C:\inetpub\wwwroot\limesurvey2\framework\web\CWebApplication.php(135): CWebApplication->runController("admin/survey/sa/insert")
#13 + C:\inetpub\wwwroot\limesurvey2\framework\base\CApplication.php(162): CWebApplication->processRequest()
#14 + C:\inetpub\wwwroot\limesurvey2\index.php(171): CApplication->run()

2012-05-24 16:19:39 Microsoft-IIS/7.0 Yii Framework/1.1.10