In case you're wondering, yes I'm aware I accidentally published our database credentials, and I've regenerated them just now.

Can you please try again with the attached file? It needs to replace the existing one in /application/helpers/update.

It didn't work. The error message on the console was the same. However using the web-based updater displayed this message:

A non-recoverable error occurred during the database update. Error details:

CDbCommand failed to execute the SQL statement: SQLSTATE[42804]: Datatype mismatch: 7 ERROR: COALESCE types text and integer cannot be matched LINE 1: ...e_conditions_cid_seq', COALESCE(MAX(plugin_type), 1) ) FROM ... ^

File Update_710.php, line 25.

very similar bug with mysql when trying to update 6.17.19 to 7.0.12:

php application/commands/console.php updatedb --verbose
Update mysql:host=localhost;port=3306;dbname=limefaclet; with prefix :lime_ from 708 to 711
CException: Please fix this error in your database and try again in /var/www/outils/limesurveyfac/lettres/application/commands/UpdateDbCommand.php:51
Stack trace:
#0 /var/www/outils/limesurveyfac/lettres/vendor/yiisoft/yii/framework/console/CConsoleCommandRunner.php(71): UpdateDBCommand->run()
#1 /var/www/outils/limesurveyfac/lettres/vendor/yiisoft/yii/framework/console/CConsoleApplication.php(92): CConsoleCommandRunner->run()
#2 /var/www/outils/limesurveyfac/lettres/vendor/yiisoft/yii/framework/base/CApplication.php(185): CConsoleApplication->processRequest()
#3 /var/www/outils/limesurveyfac/lettres/application/commands/console.php(77): CApplication->run()

more details if required with web-based update

NB: it seems to be linked with our very big instances with a lot of surveys - I do not have this problem on my private limesurvey with few forms

Can you please try again with the attached file? It needs to replace the existing one in /application/helpers/update.

This update add the CDB command error in console ? We don't have an issue for this ?

This update add the CDB command error in console ? We don't have an issue for this ?

This might be : https://bugs.limesurvey.org/view.php?id=19385

thanks Denis but both web-based upgrade and command line bug with the same kind of message;
it maybe linked with some NULL values in the existing result tables, when there are converted in the new MySQL v7 format

@lavamind
I did another change, please try the attached file, again.

I did another change, please try the attached file, again.

Thanks, the update succeeded with the new helper function.

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

nice for @lavamind; for my very similar bug (but with MariaDB/MySQL) it didn't change anything (both on web-based upgrade and on command-line upgrade)

one more info: I've tried a fresh v7 install, then tested export (lsa) v6 + import v7 datas from various forms where the global upgrade of the instance wasn't woking, result: it worked without any problem, but we have so many forms that this solution is not possible

@limesurvey team:

• do you want me to post this bug in a new issue?
• any more informations required from me?

Fixed in Release 7.0.13+260903

thks: this time it worked 99% (only one survey on hundreds bugged during the migration v6 to v7)