View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 14317 | Bug reports | Survey editing | public | 2018-12-04 14:26 | 2019-04-30 09:12 |
| Reporter | DenisChenu | Assigned To | DenisChenu | ||
| Priority | none | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.x | ||||
| Fixed in Version | 3.15.x | ||||
| Summary | 14317: CDbException when try to set a title with more than 200 caracters | ||||
| Description | When put more than 200 characters in survey title : saving send a CDbException (and nothing is shown for user) | ||||
| Steps To Reproduce | Enter | ||||
| Additional Information | With debug at 0 : 500: Internal Server Error An internal error occurred while the Web server was processing your request. Please contact Administrator to report this problem. | ||||
| Tags | No tags attached. | ||||
| Attached Files | CDBexception.txt (3,298 bytes)
XHRPOSThttp://limesurvey.local/master/index.php?r=admin/database/index/updatesurveylocalesettings[HTTP/1.1 500 Internal Server Error 51ms]
<h1>CDbException</h1>
<p>CDbCommand failed to execute the SQL statement: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'surveyls_title' at row 1. The SQL statement executed was: 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_policy_notice`=:yp6, `surveyls_policy_error`=:yp7, `surveyls_policy_notice_label`=:yp8, `surveyls_url`=:yp9, `surveyls_urldescription`=:yp10, `surveyls_email_invite_subj`=:yp11, `surveyls_email_invite`=:yp12, `surveyls_email_remind_subj`=:yp13, `surveyls_email_remind`=:yp14, `surveyls_email_register_subj`=:yp15, `surveyls_email_register`=:yp16, `surveyls_email_confirm_subj`=:yp17, `surveyls_email_confirm`=:yp18, `surveyls_dateformat`=:yp19, `surveyls_attributecaptions`=:yp20, `email_admin_notification_subj`=:yp21, `email_admin_notification`=:yp22, `email_admin_responses_subj`=:yp23, `email_admin_responses`=:yp24, `surveyls_numberformat`=:yp25, `attachments`=:yp26 WHERE `lime_surveys_languagesettings`.`surveyls_survey_id`=892176 AND `lime_surveys_languagesettings`.`surveyls_language`='en' (/mnt/data/shnoulle/nginx/www/master/framework/db/CDbCommand.php:358)</p><pre>#0 /mnt/data/shnoulle/nginx/www/master/framework/db/ar/CActiveRecord.php(1756): CDbCommand->execute()
#1 /mnt/data/shnoulle/nginx/www/master/framework/db/ar/CActiveRecord.php(1130): CActiveRecord->updateByPk(Array, Array)
#2 /mnt/data/shnoulle/nginx/www/master/framework/db/ar/CActiveRecord.php(811): CActiveRecord->update(NULL)
#3 /mnt/data/shnoulle/nginx/www/master/application/controllers/admin/database.php(877): CActiveRecord->save()
#4 /mnt/data/shnoulle/nginx/www/master/application/controllers/admin/database.php(133): database->actionUpdateSurveyLocaleSettings(892176)
#5 [internal function]: database->index()
#6 /mnt/data/shnoulle/nginx/www/master/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(Object(database), Array)
#7 /mnt/data/shnoulle/nginx/www/master/application/core/Survey_Common_Action.php(83): CAction->runWithParamsInternal(Object(database), Object(ReflectionMethod), Array)
#8 /mnt/data/shnoulle/nginx/www/master/framework/web/CController.php(308): Survey_Common_Action->runWithParams(Array)
#9 /mnt/data/shnoulle/nginx/www/master/framework/web/CController.php(286): CController->runAction(Object(database))
#10 /mnt/data/shnoulle/nginx/www/master/framework/web/CController.php(265): CController->runActionWithFilters(Object(database), Array)
#11 /mnt/data/shnoulle/nginx/www/master/application/controllers/AdminController.php(158): CController->run('database')
#12 /mnt/data/shnoulle/nginx/www/master/framework/web/CWebApplication.php(282): AdminController->run('database')
#13 /mnt/data/shnoulle/nginx/www/master/framework/web/CWebApplication.php(141): CWebApplication->runController('admin/database/...')
#14 /mnt/data/shnoulle/nginx/www/master/framework/base/CApplication.php(185): CWebApplication->processRequest()
#15 /mnt/data/shnoulle/nginx/www/master/index.php(194): CApplication->run()
#16 {main}</pre>
| ||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 3.15.5 github | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | not relevant | ||||
| Database type & version | mariadb | ||||
| Server OS (if known) | fedora/linux | ||||
| Webserver software & version (if known) | nginx | ||||
| PHP Version | 7.2.12 | ||||
 |
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=28583 |
 |
Fixed in Version 3.1.7.3 |
|
LimeSurvey: master c4195b94 2018-12-04 15:34 Details Diff |
Fixed issue 14317: CDbException when try to set a title with more than 200 caracters Dev: disable save with rules (but shown as saved …) Dev: set maxlength in GUI |
Affected Issues 14317 |
|
| mod - application/models/SurveyLanguageSetting.php | Diff File | ||
| mod - application/views/admin/survey/editLocalSettings_view.php | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-12-04 14:26 | DenisChenu | New Issue | |
| 2018-12-04 14:26 | DenisChenu | File Added: CDBexception.txt | |
| 2018-12-04 14:28 | DenisChenu | Assigned To | => DenisChenu |
| 2018-12-04 14:28 | DenisChenu | Status | new => assigned |
| 2018-12-04 14:34 | DenisChenu | Changeset attached | => LimeSurvey master c4195b94 |
| 2018-12-04 14:34 | DenisChenu | Note Added: 49877 | |
| 2018-12-04 14:34 | DenisChenu | Resolution | open => fixed |
| 2018-12-04 14:35 | DenisChenu | Status | assigned => resolved |
| 2018-12-04 14:35 | DenisChenu | Fixed in Version | => 3.15.x |
| 2019-04-30 09:12 | c_schmitz | Note Added: 51639 | |
| 2019-04-30 09:12 | c_schmitz | Status | resolved => closed |
| 2019-11-01 17:25 | c_schmitz | Category | Survey design => Survey editing |
