I was updating my Limesurvey through ComfortUpdate. After updating files, it asked to upgrade database. While upgrading a database, I got the following error message.

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

@PPRI : can you please apply this patch https://github.com/LimeSurvey/LimeSurvey/commit/a4415187bc5284d97de9c9b20dda276dca1605c6 and see if it fixes the upgrade issue?

tried after applying the fix. No more error message but after processing the db update., the page says "Loading..." at the page, index.php?r=admin/databaseupdate/sa/db/continue/yes and stuck on it.

Can you enable debug = 2 in application/config/config.php and try again, please? Paste the complete error message here.

Loading...

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 8388616 bytes) in C:\Websites\Limesurvey2019\framework\db\CDbCommand.php on line 518

Ok, so you have run out of memory.
You will need to raise your PHP memory limit from 256 MB to something higher in your PHP configuration.
I would recommend 512, then see if that helped.

Loading...

Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) in C:\Websites\Limesurvey2019\framework\db\CDbCommand.php on line 518

Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 135168 bytes) in C:\Websites\Limesurvey2019\framework\logging\CLogger.php on line 150

Is that the complete error message? No stack trace?

Make sure debugsql => 0, not 1, in config.php.

That's all with debug'=>2, 'debugsql'=>0

Please try to raise it further then. At some point it will work.
How many surveys do you have in your instance in total?

I have 30 surveys and only 7 surveys are active and running. I will try to raise the memory limit more.

Thank you, we're reviewing the code to reduce the memory usage.

I set memory_limit = 2048M and got the new error.

====
Error
Wrong parameters for CException([string $message [, long $code [, Throwable $previous = NULL]]])

C:\Websites\Limesurvey2019\application\models\LSActiveRecord.php(370)

358 }
359
360 /
361 Decrypt single value
362 @param string $value String value which needs to be decrypted
363 @return string the decrypted string
364 /
365 public static function decryptSingleOld($value = ''): string
366 {
367 static $sodium = null;
368 if (!isset($sodium)) {
369 // load sodium library
370 $sodium = Yii::app()->sodiumOld;
371 }
372 // if $value is provided, it would decrypt
373 if ($value) {
374 return $sodium->decrypt($value);
375 }
376 return '';
377 }
378
379
380 /
381 Enrypt single value
382 @param string $value String value which needs to be encrypted
Stack Trace
#0
– C:\Websites\Limesurvey2019\application\core\LSSodiumOld.php(147): Exception->__construct("500", "Configuration file already exist")
142 /
143 protected function generateEncryptionKeys()
144 {
145 if (is_file(APPPATH . 'config/security.php')) {
146 // Never replace an existing file
147 throw new CException(500, gT("Configuration file already exist"));
148 }
149 $sEncryptionKeypair = ParagonIE_Sodium_Compat::crypto_sign_keypair();
150 $sEncryptionPublicKey = ParagonIE_Sodium_Compat::bin2hex(ParagonIE_Sodium_Compat::crypto_sign_publickey($sEncryptionKeypair));
151 $sEncryptionSecretKey = ParagonIE_Sodium_Compat::bin2hex(ParagonIE_Sodium_Compat::crypto_sign_secretkey($sEncryptionKeypair));
152 $sEncryptionKeypair = ParagonIE_Sodium_Compat::bin2hex($sEncryptionKeypair);
#1
– C:\Websites\Limesurvey2019\application\core\LSSodiumOld.php(49): LSSodiumOld->generateEncryptionKeys()
44 @throws SodiumException
45 /
46 protected function checkIfKeyExists()
47 {
48 if (empty(Yii::app()->getConfig('encryptionkeypair'))) {
49 $this->generateEncryptionKeys(); //return false;
50 }
51 if ($this->sEncryptionKeypair === null) {
52 $this->sEncryptionKeypair = $this->getEncryptionKey();
53 }
54 if ($this->sEncryptionPublicKey === null) {
#2
– C:\Websites\Limesurvey2019\application\core\LSSodiumOld.php(25): LSSodiumOld->checkIfKeyExists()
20
21 if ($this->bLibraryExists === false) {
22 /throw new SodiumException(sprintf(gT("This operation uses data encryption functions which require Sodium library to be installed, but library was not found. If you don't want to use data encryption, you have to disable encryption in attribute settings. Here is a link to the manual page:
23 %s", 'unescaped'), 'https://manual.limesurvey.org/Data_encryption#Errors'));*/
24 } else {
25 $this->checkIfKeyExists();
26 }
27 }
28
29 /*
30 Check if Sodium library is installed
#3

• C:\Websites\Limesurvey2019\framework\base\CModule.php(394): LSSodiumOld->init()
  #4
• C:\Websites\Limesurvey2019\framework\base\CModule.php(103): CModule->getComponent("sodiumOld")
  #5
• C:\Websites\Limesurvey2019\application\models\LSActiveRecord.php(370): CModule->__get("sodiumOld")
  #6
• C:\Websites\Limesurvey2019\application\helpers\update\updatedb_helper.php(4699): LSActiveRecord::decryptSingleOld("Iq7H5XNIhvk2UwsizWxsxkMBKBnB65C94r/KdJ9sU4L03rbWBcY=")
  #7
• C:\Websites\Limesurvey2019\application\helpers\update\update_helper.php(33): db_upgrade_all(449)
  #8
• C:\Websites\Limesurvey2019\application\controllers\admin\databaseupdate.php(38): CheckForDBUpgrades("yes")
  #9
  unknown(0): databaseupdate->db("yes")
  #10
• C:\Websites\Limesurvey2019\framework\web\actions\CAction.php(115): ReflectionMethod->invokeArgs(databaseupdate, array("yes"))
  #11
• C:\Websites\Limesurvey2019\application\core\Survey_Common_Action.php(86): CAction->runWithParamsInternal(databaseupdate, ReflectionMethod, array("r" => "admin/databaseupdate/sa/db/continue/yes", "sa" => "db", "continue" => "yes"))
  #12
• C:\Websites\Limesurvey2019\framework\web\CController.php(308): Survey_Common_Action->runWithParams(array("r" => "admin/databaseupdate/sa/db/continue/yes", "sa" => "db", "continue" => "yes"))
  #13
• C:\Websites\Limesurvey2019\framework\web\CController.php(286): CController->runAction(databaseupdate)
  #14
• C:\Websites\Limesurvey2019\framework\web\CController.php(265): CController->runActionWithFilters(databaseupdate, array())
  #15
• C:\Websites\Limesurvey2019\application\controllers\AdminController.php(202): CController->run("databaseupdate")
  #16
• C:\Websites\Limesurvey2019\framework\web\CWebApplication.php(282): AdminController->run("databaseupdate")
  #17
• C:\Websites\Limesurvey2019\framework\web\CWebApplication.php(141): CWebApplication->runController("admin/databaseupdate/sa/db/continue/yes")
  #18
• C:\Websites\Limesurvey2019\framework\base\CApplication.php(185): CWebApplication->processRequest()
  #19
• C:\Websites\Limesurvey2019\index.php(192): CApplication->run()
  2021-08-12 03:41:39 Microsoft-IIS/10.0 Yii Framework/1.1.24-dev

I pushed a fix here: https://github.com/LimeSurvey/LimeSurvey/commit/2bf863b0563cd9896b8369af8edb3543f68d9192

But this will still throw an exception, just a "correct" exception.

Can you start the upgrade from scratch from a database and file backup? You might now have the problem that some files/database are half-way updated creating follow-up errors.

Version 5.1.1 released, please try again with this new version and let us know if any problems remain. Thank you!

To test a fresh update from the previous version like c_schmitz suggested, I built a new website with my code and database backups but Version 5.xxx is gone from the ComfortUpdate now so I couldn't test it.

Never mind, I see 5.1.1 update at the ComfortUpdate now. I will let you know my test result soon.

while updating I got this error message. Please see the screenshot added.

Screenshot 2021-08-12 110959.png (19,235 bytes)   

Screenshot 2021-08-12 110959.png (19,235 bytes)   

@PPRI The service was temporarily disabled while we debugged it, but should be fine since around when you tried it. Can you reload the page and try again, please?

Error again but different message.

=====

An non-recoverable error happened during the update. Error details:
Configuration file already exist

File C:\Websites\Limesurvey2019_Org\application\core\LSSodiumOld.php, line 25.
Please fix this error in your database and try again

To know where your database update halted, can you run this query and show us the result?

SELECT * FROM settings_global WHERE stg_name = 'dbversion';

(Assuming your table prefix is empty - it might be "lime_" too).

You can also inspect the file application/config/security.php and check which values it has (but don't paste them here, the values are secret).

Thank you.

DBVersion = 451

I have $config['encryptionnonce'] and $config['encryptionsecretboxkey'] in the security.php.

@PPRI OK, we've released 5.1.2 with a fix for this. Please test and report any other issues. Thank you!

Actually, might still be a bug in that version related to encryption of emailsmtppassword. We'll release a fix tomorrow.

Thank you so much for all your helps. It has been updated successfully now.