View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
14317Bug reportsSurvey editingpublic2019-04-30 09:12
ReporterDenisChenu Assigned ToDenisChenu  
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Product Version3.15.x 
Fixed 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.
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>
CDBexception.txt (3,298 bytes)   
Bug heat4
Complete LimeSurvey version number (& build)3.15.5 github
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionmariadb
Server OS (if known)fedora/linux
Webserver software & version (if known)nginx
PHP Version7.2.12

Users monitoring this issue

There are no users monitoring this issue.

Activities

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

c_schmitz

c_schmitz

2019-04-30 09:12

administrator   ~51639

Fixed in Version 3.1.7.3

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
Affected Issues
14317
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
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