Internal Server Error

CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0-af' for key 'PRIMARY'

An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.

Thank you.

2015-06-30 15:04:53
Application Log
Timestamp Level Category Message
15:04:53.173924 error system.db.CDbCommand 
CDbCommand::execute() failed: SQLSTATE[23000]: Integrity constraint
violation: 1062 Duplicate entry '0-af' for key 'PRIMARY'. The SQL statement
executed was: INSERT INTO `lime_surveys_languagesettings`
(`surveyls_dateformat`, `surveyls_numberformat`, `surveyls_language`,
`surveyls_title`, `surveyls_description`, `surveyls_welcometext`,
`surveyls_endtext`, `surveyls_url`, `surveyls_urldescription`,
`surveyls_email_invite_subj`, `surveyls_email_invite`,
`surveyls_email_remind_subj`, `surveyls_email_remind`,
`surveyls_email_confirm_subj`, `surveyls_email_confirm`,
`surveyls_email_register_subj`, `surveyls_email_register`,
`email_admin_notification_subj`, `email_admin_notification`,
`email_admin_responses_subj`, `email_admin_responses`) VALUES (:yp0, :yp1,
:yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13,
:yp14, :yp15, :yp16, :yp17, :yp18, :yp19, :yp20). Bound with :yp0=1,
:yp1=0, :yp2='af', :yp3='', :yp4='', :yp5='', :yp6='', :yp7='', :yp8='',
:yp9='', :yp10='', :yp11='', :yp12='', :yp13='', :yp14='', :yp15='',
:yp16='', :yp17='', :yp18='', :yp19='', :yp20=''.
15:04:53.175610 error exception.CDbException 
exception 'CDbException' with message 'CDbCommand failed to execute the SQL
statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate
entry '0-af' for key 'PRIMARY'' in
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/db/CDbCommand.php:358
Stack trace:
#0
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(1080):
CDbCommand->execute()
#1
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(809):
CActiveRecord->insert(NULL)
#2 /var/www/my_webapp/lsdev/application/models/Survey.php(961):
CActiveRecord->save()
#3
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/base/CComponent.php(152):
Survey->setTranslatedFields(Array)
#4
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(161):
CComponent->__set('translatedField...', Array)
#5 /var/www/my_webapp/lsdev/application/models/Survey.php(895):
CActiveRecord->__set('translatedField...', Array)
#6
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/base/CModel.php(472):
Survey->__set('translatedField...', Array)
#7
/var/www/my_webapp/lsdev/application/controllers/SurveysController.php(62):
CModel->setAttributes(Array)
#8 [internal function]:
ls\controllers\SurveysController->actionUpdate('459733')
#9
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/actions/CAction.php(109):
ReflectionMethod->invokeArgs(Object(ls\controllers\SurveysController),
Array)
#10
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/actions/CInlineAction.php(47):
CAction->runWithParamsInternal(Object(ls\controllers\SurveysController),
Object(ReflectionMethod), Array)
#11
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CController.php(308):
CInlineAction->runWithParams(Array)
#12
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/filters/CFilterChain.php(133):
CController->runAction(Object(CInlineAction))
#13
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/filters/CFilter.php(40):
CFilterChain->run()
#14
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CController.php(1145):
CFilter->filter(Object(CFilterChain))
#15
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/filters/CInlineFilter.php(58):
CController->filterAccessControl(Object(CFilterChain))
#16
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/filters/CFilterChain.php(130):
CInlineFilter->filter(Object(CFilterChain))
#17
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/filters/CFilter.php(40):
CFilterChain->run()
#18
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CController.php(1145):
CFilter->filter(Object(CFilterChain))
#19
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/filters/CInlineFilter.php(58):
CController->filterAccessControl(Object(CFilterChain))
#20
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/filters/CFilterChain.php(130):
CInlineFilter->filter(Object(CFilterChain))
#21
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CController.php(291):
CFilterChain->run()
#22
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CController.php(265):
CController->runActionWithFilters(Object(CInlineAction), Array)
#23
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CWebApplication.php(282):
CController->run('update')
#24
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/web/CWebApplication.php(141):
CWebApplication->runController('surveys/update')
#25 /var/www/my_webapp/lsdev/application/core/WebApplication.php(76):
CWebApplication->processRequest()
#26
/var/www/my_webapp/lsdev/application/vendor/yiisoft/yii/framework/base/CApplication.php(184):
WebApplication->processRequest()
#27 /var/www/my_webapp/lsdev/application/entry.php(41): CApplication->run()
#28 /var/www/my_webapp/lsdev/index.php(2): include('/var/www/my_web...')
#29 {main}
REQUEST_URI=/lsdev/index.php?r=surveys/update&id=459733
HTTP_REFERER=https://test.shnoulle.net/lsdev/index.php?r=surveys/update&id=459733
---
Profiling Summary Report (Time: 1.18868s, Memory: 6,133KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=459733 LIMIT 1) 13 0.00677 0.00052 0.00048 0.00056
system.db.CDbCommand.execute(INSERT INTO `lime_surveys_languagesettings` (`surveyls_dateformat`, `surveyls_numberformat`, `surveyls_language`, `surveyls_title`, `surveyls_description`, `surveyls_welcometext`, `surveyls_endtext`, `surveyls_url`, `surveyls_urldescription`, `surveyls_email_invite_subj`, `surveyls_email_invite`, `surveyls_email_remind_subj`, `surveyls_email_remind`, `surveyls_email_confirm_subj`, `surveyls_email_confirm`, `surveyls_email_register_subj`, `surveyls_email_register`, `email_admin_notification_subj`, `email_admin_notification`, `email_admin_responses_subj`, `email_admin_responses`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13, :yp14, :yp15, :yp16, :yp17, :yp18, :yp19, :yp20). Bound with :yp0=1, :yp1=0, :yp2='af', :yp3='', :yp4='', :yp5='', :yp6='', :yp7='', :yp8='', :yp9='', :yp10='', :yp11='', :yp12='', :yp13='', :yp14='', :yp15='', :yp16='', :yp17='', :yp18='', :yp19='', :yp20='') 1 0.00123 0.00123 0.00123 0.00123
system.db.CDbCommand.execute(UPDATE `lime_surveys_languagesettings` SET `surveyls_survey_id`=:yp0, `surveyls_language`=:yp1, `surveyls_title`=:yp2, `surveyls_description`=:yp3, `surveyls_welcometext`=:yp4, `surveyls_endtext`=:yp5, `surveyls_url`=:yp6, `surveyls_urldescription`=:yp7, `surveyls_email_invite_subj`=:yp8, `surveyls_email_invite`=:yp9, `surveyls_email_remind_subj`=:yp10, `surveyls_email_remind`=:yp11, `surveyls_email_register_subj`=:yp12, `surveyls_email_register`=:yp13, `surveyls_email_confirm_subj`=:yp14, `surveyls_email_confirm`=:yp15, `surveyls_dateformat`=:yp16, `surveyls_attributecaptions`=:yp17, `email_admin_notification_subj`=:yp18, `email_admin_notification`=:yp19, `email_admin_responses_subj`=:yp20, `email_admin_responses`=:yp21, `surveyls_numberformat`=:yp22, `attachments`=:yp23 WHERE `lime_surveys_languagesettings`.`surveyls_survey_id`=459733 AND `lime_surveys_languagesettings`.`surveyls_language`='en'. Bound with :yp0=459733, :yp1='en', :yp2='Test', :yp3='<p>{BROKE}</p>', :yp4='<p>{BROKE}</p>', :yp5='<p>{BROKE}</p>', :yp6='', :yp7='', :yp8='Invitation to participate in a survey', :yp9='Dear {FIRSTNAME}, you have been invited to participate in a survey. The survey is titled: "{SURVEYNAME}" "{SURVEYDESCRIPTION}" To participate, please click on the link below. Sincerely, {ADMINNAME} ({ADMINEMAIL}) ---------------------------------------------- Click here to do the survey: {SURVEYURL} If you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link: {OPTOUTURL} If you are blacklisted but want to participate in this survey and want to receive invitations please click the following link: {OPTINURL}', :yp10='Reminder to participate in a survey', :yp11='Dear {FIRSTNAME}, Recently we invited you to participate in a survey. We note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part. The survey is titled: "{SURVEYNAME}" "{SURVEYDESCRIPTION}" To participate, please click on the link below. Sincerely, {ADMINNAME} ({ADMINEMAIL}) ---------------------------------------------- Click here to do the survey: {SURVEYURL} If you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link: {OPTOUTURL}', :yp12='Survey registration confirmation', :yp13='Dear {FIRSTNAME}, You, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}. To complete this survey, click on the following URL: {SURVEYURL} If you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.', :yp14='Confirmation of your participation in our survey', :yp15='Dear {FIRSTNAME}, this email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating. If you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}. Sincerely, {ADMINNAME}', :yp16=1, :yp17=NULL, :yp18='Response submission for survey {SURVEYNAME}', :yp19='Hello, A new response was submitted for your survey \'{SURVEYNAME}\'. Click the following link to reload the survey: {RELOADURL} Click the following link to see the individual response: {VIEWRESPONSEURL} Click the following link to edit the individual response: {EDITRESPONSEURL} View statistics by clicking here: {STATISTICSURL}', :yp20='Response submission for survey {SURVEYNAME} with results', :yp21='Hello, A new response was submitted for your survey \'{SURVEYNAME}\'. Click the following link to reload the survey: {RELOADURL} Click the following link to see the individual response: {VIEWRESPONSEURL} Click the following link to edit the individual response: {EDITRESPONSEURL} View statistics by clicking here: {STATISTICSURL} The following answers were given by the participant: {ANSWERTABLE}', :yp22=0, :yp23=NULL) 1 0.00119 0.00119 0.00119 0.00119
system.db.CDbCommand.query(SELECT `languagesettings`.`surveyls_survey_id` AS `t1_c0`, `languagesettings`.`surveyls_language` AS `t1_c1`, `languagesettings`.`surveyls_title` AS `t1_c2`, `languagesettings`.`surveyls_description` AS `t1_c3`, `languagesettings`.`surveyls_welcometext` AS `t1_c4`, `languagesettings`.`surveyls_endtext` AS `t1_c5`, `languagesettings`.`surveyls_url` AS `t1_c6`, `languagesettings`.`surveyls_urldescription` AS `t1_c7`, `languagesettings`.`surveyls_email_invite_subj` AS `t1_c8`, `languagesettings`.`surveyls_email_invite` AS `t1_c9`, `languagesettings`.`surveyls_email_remind_subj` AS `t1_c10`, `languagesettings`.`surveyls_email_remind` AS `t1_c11`, `languagesettings`.`surveyls_email_register_subj` AS `t1_c12`, `languagesettings`.`surveyls_email_register` AS `t1_c13`, `languagesettings`.`surveyls_email_confirm_subj` AS `t1_c14`, `languagesettings`.`surveyls_email_confirm` AS `t1_c15`, `languagesettings`.`surveyls_dateformat` AS `t1_c16`, `languagesettings`.`surveyls_attributecaptions` AS `t1_c17`, `languagesettings`.`email_admin_notification_subj` AS `t1_c18`, `languagesettings`.`email_admin_notification` AS `t1_c19`, `languagesettings`.`email_admin_responses_subj` AS `t1_c20`, `languagesettings`.`email_admin_responses` AS `t1_c21`, `languagesettings`.`surveyls_numberformat` AS `t1_c22`, `languagesettings`.`attachments` AS `t1_c23` FROM `lime_surveys_languagesettings` `languagesettings` WHERE (`languagesettings`.`surveyls_survey_id`=:ypl0). Bound with :ypl0='459733') 1 0.00047 0.00047 0.00047 0.00047
system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t` WHERE `t`.`stg_name`='authenticationPlugins' LIMIT 1) 1 0.00038 0.00038 0.00038 0.00038
system.db.CDbCommand.query(SELECT * FROM `lime_permissions` `t` WHERE `t`.`entity_id`=:yp0 AND `t`.`entity`=:yp1 AND `t`.`uid`=:yp2 AND `t`.`permission`=:yp3 LIMIT 1. Bound with :yp0=0, :yp1='global', :yp2='1', :yp3='superadmin') 1 0.00037 0.00037 0.00037 0.00037
system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t` WHERE `t`.`stg_name`='sitename' LIMIT 1) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t` WHERE `t`.`stg_name`='force_ssl' LIMIT 1) 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t` WHERE `t`.`stg_name`='authorizationPlugin' LIMIT 1) 1 0.00032 0.00032 0.00032 0.00032