I have workarounded my problem running this command in my Postgresql limesurvey database:

select setval('lime_questions_qid_seq1', 551, true);

Then when I create a new question I obtain a value higher than any of the old questions that were present, and I can save it.

I leave the bug open because maybe something went wrong in the upgrade that needs to be fixed when upgrading the database schemas to new limesurvey versions.

This is somehow related to the bug https://bugs.limesurvey.org/view.php?id=16145

If you can help us to debug and test with PGSQL : it can be great.

But : if you need a stable production system it's best if you stay with 3.X LTS.

Oh. I got confused because the 4.x version is shown as "stable release" in the download section of limesurvey.org
I'll rollback to 3.x versions. I have a backup that would take me back to version 3.15.5, and then I looked at the releases of the Github repo and I cannot see any recent 3.x tagged as LTS, so I guess 3.22.15+200505 (the last 3.x version published) is the one I would need to upgrade to, isn't it? (correct me if I am wrong).

I'll try to keep the 4.x instance around too, so if you want me to test anything, just tell.

Both instances would run with Postgresql 9.6 database system (different limesurvey databases, obviously).

Kind regards

I have rolled back my instance to 3.x but I cannot import the survey created with 4.x. In normal situation when importing it says:

Success
File upload succeeded.
Error
Unable to import survey.

with debug on, and trying to import the .lsa file, it says:
Undefined index: newsid

/var/www/surveys3/application/helpers/admin/import_helper.php(710)

698 $aFiles = $pclzip->listContent();
699
700 if ($pclzip->extract(PCLZIP_OPT_PATH, Yii::app()->getConfig('tempdir').DIRECTORY_SEPARATOR, PCLZIP_OPT_BY_EREG, '/(lss|lsr|lsi|lst)$/') == 0) {
701 unset($pclzip);
702 }
703 $aImportResults = [];
704 // Step 1 - import the LSS file and activate the survey
705 foreach ($aFiles as $aFile) {
706
707 if (pathinfo($aFile['filename'], PATHINFO_EXTENSION) == 'lss') {
708 //Import the LSS file
709 $aImportResults = XMLImportSurvey(Yii::app()->getConfig('tempdir').DIRECTORY_SEPARATOR.$aFile['filename'], null, null, null, true, false);
710 if ($aImportResults && $aImportResults['newsid']) {
711 TemplateConfiguration::checkAndcreateSurveyConfig($aImportResults['newsid']);
712 }
713 // Activate the survey
714 Yii::app()->loadHelper("admin/activate");
715 activateSurvey($aImportResults['newsid']);
716 unlink(Yii::app()->getConfig('tempdir').DIRECTORY_SEPARATOR.$aFile['filename']);
717 break;
718 }
719 }
720
721 // Step 2 - import the responses file
722 foreach ($aFiles as $aFile) {
Stack Trace
#0
– /var/www/surveys3/application/controllers/admin/surveyadmin.php(1354): importSurveyFile("/var/www/surveys3/tmp/8t6665njzh8dfjbtibasnrciesg4vz.lsa", true)
1349
1350 // Now, we have the survey : start importing
1351 Yii::app()->loadHelper('admin/import');
1352
1353 if ($action == 'importsurvey' && !$aData['bFailed']) {
1354 $aImportResults = importSurveyFile($sFullFilepath, (Yii::app()->request->getPost('translinksfields') == '1'));
1355 if (is_null($aImportResults)) {
1356 $aImportResults = array(
1357 'error'=>gT("Unknown error while reading the file, no survey created.")
1358 );
1359 }
#1
unknown(0): SurveyAdmin->copy()
#2

• /var/www/surveys3/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(SurveyAdmin, array())
  #3
  – /var/www/surveys3/application/core/Survey_Common_Action.php(83): CAction->runWithParamsInternal(SurveyAdmin, ReflectionMethod, array("r" => "admin/survey/sa/copy", "sa" => "copy", "sAction" => "importsurvey"))
  78 $oMethod = new ReflectionMethod($this, $sDefault);
  79 }
  80
  81 // We're all good to go, let's execute it
  82 // runWithParamsInternal would automatically get the parameters of the method and populate them as required with the params
  83 return parent::runWithParamsInternal($this, $oMethod, $params);
  84 }
  85
  86 /*
  87 Some functions have different parameters, which are just an alias of the
  88 * usual parameters we're getting in the url. This function just populates
  #4
• /var/www/surveys3/framework/web/CController.php(308): Survey_Common_Action->runWithParams(array("r" => "admin/survey/sa/copy", "sa" => "copy", "sAction" => "importsurvey"))
  #5
• /var/www/surveys3/framework/web/CController.php(286): CController->runAction(SurveyAdmin)
  #6
• /var/www/surveys3/framework/web/CController.php(265): CController->runActionWithFilters(SurveyAdmin, array())
  #7
  – /var/www/surveys3/application/controllers/AdminController.php(165): CController->run("survey")
  160 $this->redirect(array('/admin/authentication/sa/login'));
  161 }
  162 }
  163 }
  164
  165 return parent::run($action);
  166 }
  167
  168 /*
  169 Routes all the actions to their respective places
  170 *
  #8
• /var/www/surveys3/framework/web/CWebApplication.php(282): AdminController->run("survey")
  #9
• /var/www/surveys3/framework/web/CWebApplication.php(141): CWebApplication->runController("admin/survey/sa/copy")
  #10
• /var/www/surveys3/framework/base/CApplication.php(185): CWebApplication->processRequest()
  #11
• /var/www/surveys3/index.php(194): CApplication->run()

Now I have both instances running. Do you have any advice about how to adapt the export file (.lss or .lsa or .txt) from the 4.x instance, to be able to import it to the 3.x instance? We don't need answers, only the survey question structure and settings.

Thanks!

I have rolled back my instance to 3.x but I cannot import the survey created with 4.x. In normal situation when importing it says:

Yes, it's a know issue … sorry …
https://bugs.limesurvey.org/view.php?id=15784

so I guess 3.22.15+200505 (the last 3.x version published) is the one I would need to upgrade to, isn't it? (correct me if I am wrong).

Correct :)

Hello @larjona , do you have time to test if most of the issues were solved with 4.4.0 RC1 ? Thanks for your help and feedback!

Hello larjona,

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,

ollehar