View Issue Details

Jump to NotesJump to History
This bug affects 2 person(s).
 10
IDProjectCategoryView StatusDate SubmittedLast Update
18580Bug reportsLabel setspublic2023-01-03 19:412023-01-11 13:53
Reportergrinapo Assigned To 
PriorityhighSeveritypartial_block 
Status feedbackResolutionopen 
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 heat10
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?

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