Updating <analytics> ... An unhandled exception has been thrown:

Support intro

Sorry to hear you’re facing problems :slightly_frowning_face:

help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.

In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:


Or for longer, use three backticks above and below the code snippet:


Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can :heart:

Nextcloud version (eg, 20.0.5): 21.0.2/21.0.9
Operating system and version (eg, Ubuntu 20.04): hosted
Apache or nginx version (eg, Apache 2.4.25): replace me
PHP version (eg, 7.4): replace me

The issue you are facing:

Is this the first time you’ve seen this error? (Y/N): Y

Steps to replicate it:

  1. start ‘php occ upgrade’

Output of occ:

Setting log level to debug
Updating database schema
Updated database
Updating <analytics> ...
An unhandled exception has been thrown:
Error: Call to undefined method OC\DB\QueryBuilder\QueryBuilder::executeStatement() in /xxx/apps/analytics/lib/Migration/Version4009Date20230410190000.php:57
Stack trace:
#0 /xxx/lib/private/DB/MigrationService.php(548): OCA\Analytics\Migration\Version4009Date20230410190000->postSchemaChange(Object(OC\Migration\SimpleOutput), Object(Closure), Array)
#1 /xxx/lib/private/DB/MigrationService.php(426): OC\DB\MigrationService->executeStep('4009Date2023041...', false)
#2 /xxx/lib/private/legacy/OC_App.php(1012): OC\DB\MigrationService->migrate()
#3 /xxx/lib/private/Updater.php(347): OC_App::updateApp('analytics')
#4 /xxx/lib/private/Updater.php(262): OC\Updater->doAppUpgrade()
#5 /xxx/lib/private/Updater.php(134): OC\Updater->doUpgrade('', '')
#6 /xxx/core/Command/Upgrade.php(249): OC\Updater->upgrade()
#7 /xxx/3rdparty/symfony/console/Command/Command.php(255): OC\Core\Command\Upgrade->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#8 /xxx/3rdparty/symfony/console/Application.php(1009): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#9 /xxx/3rdparty/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand(Object(OC\Core\Command\Upgrade), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#10 /xxx/3rdparty/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#11 /xxx/lib/private/Console/Application.php(215): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#12 /xxx/console.php(100): OC\Console\Application->run()
#13 /xxx/occ(11): require_once('/xxx....')

The output of your Nextcloud log in Admin > Logging:


The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):


The output of your Apache/nginx/system log in /var/log/____:



Output errors in nextcloud.log in /var/www/ or as admin user in top right menu, filtering for errors. Use a pastebin service if necessary.

php occ app:disable analytics
The current PHP memory limit is below the recommended value of 512MB.
Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
analytics 4.11.0 disabled

This topic was automatically closed 8 days after the last reply. New replies are no longer allowed.