View Issue Details

IDProjectCategoryView StatusLast Update
14317Bug reports[All Projects] Survey designpublic2018-12-04 14:35
ReporterDenisChenuAssigned ToDenisChenu 
PrioritynoneSeverityminor 
Status resolvedResolutionfixed 
Product Version3.15.x 
Target VersionFixed in Version3.15.x 
Summary14317: 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 Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin id condimentum risus. Aenean eleifend tristique tempor. In auctor tristique sapien, sit amet venenatis mauris tempus ut. Cras ultrices risus at ultrices feugiat. Nam porta velit ex, ut posuere lorem porttitor imperdiet. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec pulvinar non nisi id fringilla. Donec erat felis, malesuada eget suscipit vitae, suscipit eget ipsum. Morbi suscipit tempor nulla, id auctor nisl vehicula sit amet. Phasellus mi eros, posuere nec pretium ut, dapibus quis felis. Mauris posuere ante in tristique sodales. Integer congue sagittis purus, at sollicitudin lacus tincidunt id. Nam a est nunc. Etiam et ultrices leo, eu porttitor felis. in survey title, look at console.

Additional Information

With debug at 0 :

500: Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'surveyls_title' at row 1

An internal error occurred while the Web server was processing your request.

Please contact Administrator to report this problem.

TagsNo tags attached.
Complete LimeSurvey version number (& build)3.15.5 github
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database & DB-Versionmariadb
Server OS (if known)fedora/linux
Webserver software & version (if known)nginx
PHP Version7.2.12

Activities

DenisChenu

DenisChenu

2018-12-04 14:26

developer  

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>
CDBexception.txt (3,298 bytes)
DenisChenu

DenisChenu

2018-12-04 14:34

developer   ~49877

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=28583

Related Changesets

LimeSurvey: master c4195b94

2018-12-04 14:34:41

DenisChenu

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
mod - application/models/SurveyLanguageSetting.php Diff File
mod - application/views/admin/survey/editLocalSettings_view.php Diff File

Issue History

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