Analytics update failed and now analytics data missing

ℹ️ Support
1

Greetings,

An Analytics upgrade on version 20.0.2.2 did not finish, and now Analytics version 3.0.0 shows nothing inside of it.

The MySQL tables still look okay, and the source files for the data in Analytics are still there.
Is there a way to quickly fix this?

:: Logs
Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing ‘SELECT id, dimension1, dimension2, value, option, severity FROM oc_analytics_threshold WHERE (dataset = ?) AND (dataset = ?)’ with params [4, 4]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘dataset’ in ‘where clause’

I’m willing to pay someone if they can fix this. Please contact me.

2

I’m assuming you made a backup and can roll back to where everything was working.

Version 3.0 is very old. Meanwhile there is 4.10 (since yesterday) and with every update, migration- and repair steps are carried out from old versions. The current version distributed by the appstore 4.9.4 is also supported by Nextcloud 20, but you should urgently update your server though. 20 is really a relic.

Much luck!