View Issue Details

Jump to NotesJump to History
This issue affects 2 person(s).
 12
IDProjectCategoryView StatusDate SubmittedLast Update
18580Bug reportsLabel setspublic2023-01-03 19:412026-09-24 22:34
Reportergrinapo Assigned Toc_schmitz  
PriorityhighSeveritypartial_block 
Status closedResolutionunable to reproduce 
Product Version5.5.x 
Summary18580: label set save/load broken (after upgrade, probably)
Description

Upgrade from <pretty old version> to 5.5.0

1) saving label set:
<h1>Error</h1>

Call to a member function rollback() on null (/var/www/limesurvey/application/controllers/admin/Labels.php:507)

#0 [internal function]: Labels->ajaxSave()

#1 /var/www/limesurvey/vendor/yiisoft/yii/framework/web/actions/CAction.php(115): ReflectionMethod->invokeArgs()

#2 /var/www/limesurvey/application/core/SurveyCommonAction.php(83): CAction->runWithParamsInternal()

#3 /var/www/limesurvey/vendor/yiisoft/yii/framework/web/CController.php(308): SurveyCommonAction->runWithParams()

#4 /var/www/limesurvey/vendor/yiisoft/yii/framework/web/CController.php(286): CController->runAction()

#5 /var/www/limesurvey/vendor/yiisoft/yii/framework/web/CController.php(265): CController->runActionWithFilters()

#6 /var/www/limesurvey/application/controllers/AdminController.php(202): CController->run()

#7 /var/www/limesurvey/vendor/yiisoft/yii/framework/web/CWebApplication.php(282): AdminController->run()

#8 /var/www/limesurvey/vendor/yiisoft/yii/framework/web/CWebApplication.php(141): CWebApplication->runController()

#9 /var/www/limesurvey/vendor/yiisoft/yii/framework/base/CApplication.php(185): CWebApplication->processRequest()

#10 /var/www/limesurvey/index.php(192): CApplication->run()

#11 {main}

2) loading label set
<h1>CDbException</h1>

CDbCommand failed to execute the SQL statement: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: "NaN"
LINE 1: SELECT FROM "lime_labelsets" "t" WHERE lid='NaN' LIMIT 1
^. The SQL statement executed was: SELECT FROM "lime_labelsets" "t" WHERE lid=:lid LIMIT 1 (/var/www/limesurvey/vendor/yiisoft/yii/framework/db/CDbCommand.php:543)

#0 /var/www/limesurvey/vendor/yiisoft/yii/framework/db/CDbCommand.php(415): CDbCommand->queryInternal()

#1 /var/www/limesurvey/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(1359): CDbCommand->queryRow()

#2 /var/www/limesurvey/application/models/LSActiveRecord.php(77): CActiveRecord->query()

#3 /var/www/limesurvey/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(1464): LSActiveRecord->query()

#4 /var/www/limesurvey/application/controllers/QuestionAdministrationController.php(1803): CActiveRecord->find()

#5 [internal function]: QuestionAdministrationController->actionGetLabelsetDetails()

#6 /var/www/limesurvey/vendor/yiisoft/yii/framework/web/actions/CAction.php(115): ReflectionMethod->invokeArgs()

#7 /var/www/limesurvey/vendor/yiisoft/yii/framework/web/actions/CInlineAction.php(47): CAction->runWithParamsInternal()

#8 /var/www/limesurvey/vendor/yiisoft/yii/framework/web/CController.php(308): CInlineAction->runWithParams()

#9 /var/www/limesurvey/vendor/yiisoft/yii/framework/web/CController.php(286): CController->runAction()

#10 /var/www/limesurvey/vendor/yiisoft/yii/framework/web/CController.php(265): CController->runActionWithFilters()

#11 /var/www/limesurvey/application/controllers/LSBaseController.php(145): CController->run()

#12 /var/www/limesurvey/vendor/yiisoft/yii/framework/web/CWebApplication.php(282): LSBaseController->run()

#13 /var/www/limesurvey/vendor/yiisoft/yii/framework/web/CWebApplication.php(141): CWebApplication->runController()

#14 /var/www/limesurvey/vendor/yiisoft/yii/framework/base/CApplication.php(185): CWebApplication->processRequest()

#15 /var/www/limesurvey/index.php(192): CApplication->run()

#16 {main}

Steps To Reproduce

Steps to reproduce

Go in an Array (number) question and try to save the label set.
Or try to load an old saved one.

Expected result

Actual result

"Internal eror from Ajax call" (that's a typo, btw ;-))

TagsNo tags attached.
Bug heat12
Complete LimeSurvey version number (& build)5.5.0
I will donate to the project if issue is resolvedNo
BrowserFF nightly
Database type & versionPSQL 13
Server OS (if known)Debian/stable
Webserver software & version (if known)
PHP Version7.4

Users monitoring this issue

There are no users monitoring this issue.

Activities

gabrieljenik

gabrieljenik

2023-01-04 20:56

manager   ~73362

Do you have a LSS / LSA?
I guess from the old version... as to be able to reproduce.

If you create a new survey on the new version, works as expected?
grinapo

grinapo

2023-01-06 13:14

reporter   ~73372

I'm not sure what you mean by LSS, I haven't imported/exported anything if that's the question.

Yes, new surveys work fine as far as I can see.
gabrieljenik

gabrieljenik

2023-01-06 13:41

manager   ~73373

I need to reproduce the issue on my end.
As to do that, the best is to import one of your LS3 failing surveys into my env and then upgrade.

That's what I mean by LSS.
gabrieljenik

gabrieljenik

2023-01-06 19:41

manager   ~73380

Upgrade from <pretty old version>

Which version? Do you recall?
c_schmitz

c_schmitz

2026-09-24 22:34

administrator   ~85994

Hello grinapo,

we have asked for feedback on this issue. Because we did not get an answer we assume that the issue is resolved.
However, should you be able to reproduce the issue using the latest version, please feel free to re-open the issue and give us exact details on how to reproduce it.

Thank you and best regards,

c_schmitz

Issue History

Date Modified Username Field Change
2023-01-03 19:41 grinapo New Issue
2023-01-04 10:46 ollehar Priority none => high
2023-01-04 20:56 gabrieljenik Note Added: 73362
2023-01-04 20:56 gabrieljenik Bug heat 0 => 2
2023-01-04 20:56 gabrieljenik Status new => acknowledged
2023-01-06 13:14 grinapo Note Added: 73372
2023-01-06 13:14 grinapo Bug heat 2 => 4
2023-01-06 13:41 gabrieljenik Note Added: 73373
2023-01-06 19:41 gabrieljenik Note Added: 73380
2023-01-11 13:53 gabrieljenik Status acknowledged => feedback
2024-07-30 09:00 JaroCamphuijsen Bug heat 4 => 10
2026-09-24 22:34 c_schmitz Assigned To => c_schmitz
2026-09-24 22:34 c_schmitz Status feedback => closed
2026-09-24 22:34 c_schmitz Resolution open => unable to reproduce
2026-09-24 22:34 c_schmitz Note Added: 85994
2026-09-24 22:34 c_schmitz Bug heat 10 => 12