NC20 - Appstore - outdated apps?

Nextcloud version: 20.0.6
Operating system and version: Ubuntu 20.04
Apache or nginx version: Apache 2.4.41
PHP version: 7.4.14

The issue you are facing:

Hi all,
i have problems with two applications when trying to install them form the app store.
First one ist the audioplayer(Link), the second one is music (Link).
The problem is that even if there are current versions of both apps (audioplayer: 3.0.0 / music: 1.01) in the app store for the Nextcloud 20, when i’m trying to install both of them, i got older version.

  • Both applications were previous shown as “untested” in the Apps menu
  • I’ve never installed one of this apps before
  • Both applications will not work properly on NC 20 as the installed versions are not even listed on the appstore webpages (see links above)
    – the installed audioplayer version will be 1.4.0.
    – the installed music version will be 0.8.0.
  • (Audioplayer installations works propery on my second NC instance which is running at version 19.0.8)

The NC instance was version 16.0… in the beginning, and was updatet through the last years to the current version.

Is this the first time you’ve seen this error?: Yes

It seems like my NC 20 instance get some wrong versions from the app store?
Probably something is broken in the database? I assume there are more applications which are affected, but haven’t tried to install any other.

Have anybody faced the same problems and could solve them?

Thanks a lot!

Best regards,
Dolo

Update your installation to Nextcloud v20.0.7 to get an app store related problem fixed which could prevent app updates.

1 Like

Thanks @j-ed

I’ve updated Nextcloud to 20.0.7 and now the app store shows the current version of the “Audio Player” application.

  • I could install the Version 3.1.0 of the app successfully

Unfortunately i still receive the same errors when try to “scan for music” with the app.
And the app won’t find any audio files. But playing a file directly works.

PHP Error #1
Error: Trying to access array offset on value of type bool at /var/www/ncsrv/nextcloud/apps/audioplayer/3rdparty/getid3/module.audio.mp3.php#1792

/var/www/ncsrv/nextcloud/apps/audioplayer/3rdparty/getid3/module.audio.mp3.php - line 1792:

OC\Log\ErrorHandler::onError()

/var/www/ncsrv/nextcloud/apps/audioplayer/3rdparty/getid3/module.audio-video.quicktime.php - line 1456:

getid3_mp3::MPEGaudioHeaderValid()

/var/www/ncsrv/nextcloud/apps/audioplayer/3rdparty/getid3/module.audio-video.quicktime.php - line 74:

getid3_quicktime->QuicktimeParseAtom()

/var/www/ncsrv/nextcloud/apps/audioplayer/3rdparty/getid3/getid3.php - line 628:

getid3_quicktime->Analyze()

/var/www/ncsrv/nextcloud/apps/audioplayer/lib/Controller/ScannerController.php - line 618:

getID3->analyze()

/var/www/ncsrv/nextcloud/apps/audioplayer/lib/Controller/ScannerController.php - line 269:

OCA\audioplayer\Controller\ScannerController->analyze()

/var/www/ncsrv/nextcloud/apps/audioplayer/lib/Controller/ScannerController.php - line 176:

OCA\audioplayer\Controller\ScannerController->scanAudio()

/var/www/ncsrv/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 169:

OCA\audioplayer\Controller\ScannerController->scanForAudios()

/var/www/ncsrv/nextcloud/lib/private/AppFramework/Http/Dispatcher.php - line 100:

OC\AppFramework\Http\Dispatcher->executeController()

/var/www/ncsrv/nextcloud/lib/private/AppFramework/App.php - line 152:

OC\AppFramework\Http\Dispatcher->dispatch()

/var/www/ncsrv/nextcloud/lib/private/Route/Router.php - line 309:

OC\AppFramework\App::main()

/var/www/ncsrv/nextcloud/lib/base.php - line 1008:

OC\Route\Router->match()

/var/www/ncsrv/nextcloud/index.php - line 37:

OC::handleRequest()
PHP Error #2 (Database related?)
[audioplayer] Fatal: DB error while building library: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'folder_id' in 'where clause' in /var/www/ncsrv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:127
Stack trace:
#0 /var/www/ncsrv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(127): PDOStatement->execute()
#1 /var/www/ncsrv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(153): Doctrine\DBAL\Driver\PDOStatement->execute()
#2 /var/www/ncsrv/nextcloud/apps/audioplayer/lib/Controller/DbController.php(297): Doctrine\DBAL\Statement->execute()
#3 /var/www/ncsrv/nextcloud/apps/audioplayer/lib/Controller/ScannerController.php(305): OCA\audioplayer\Controller\DbController->writeAlbumToDB()
#4 /var/www/ncsrv/nextcloud/apps/audioplayer/lib/Controller/ScannerController.php(176): OCA\audioplayer\Controller\ScannerController->scanAudio()
#5 /var/www/ncsrv/nextcloud/lib/private/AppFramework/Http/Dispatcher.php(169): OCA\audioplayer\Controller\ScannerController->scanForAudios()
#6 /var/www/ncsrv/nextcloud/lib/private/AppFramework/Http/Dispatcher.php(100): OC\AppFramework\Http\Dispatcher->executeController()
#7 /var/www/ncsrv/nextcloud/lib/private/AppFramework/App.php(152): OC\AppFramework\Http\Dispatcher->dispatch()
#8 /var/www/ncsrv/nextcloud/lib/private/Route/Router.php(309): OC\AppFramework\App::main()
#9 /var/www/ncsrv/nextcloud/lib/base.php(1008): OC\Route\Router->match()
#10 /var/www/ncsrv/nextcloud/index.php(37): OC::handleRequest()
#11 {main}

Next Doctrine\DBAL\Driver\PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'folder_id' in 'where clause' in /var/www/ncsrv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:129
Stack trace:
#0 /var/www/ncsrv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(153): Doctrine\DBAL\Driver\PDOStatement->execute()
#1 /var/www/ncsrv/nextcloud/apps/audioplayer/lib/Controller/DbController.php(297): Doctrine\DBAL\Statement->execute()
#2 /var/www/ncsrv/nextcloud/apps/audioplayer/lib/Controller/ScannerController.php(305): OCA\audioplayer\Controller\DbController->writeAlbumToDB()
#3 /var/www/ncsrv/nextcloud/apps/audioplayer/lib/Controller/ScannerController.php(176): OCA\audioplayer\Controller\ScannerController->scanAudio()
#4 /var/www/ncsrv/nextcloud/lib/private/AppFramework/Http/Dispatcher.php(169): OCA\audioplayer\Controller\ScannerController->scanForAudios()
#5 /var/www/ncsrv/nextcloud/lib/private/AppFramework/Http/Dispatcher.php(100): OC\AppFramework\Http\Dispatcher->executeController()
#6 /var/www/ncsrv/nextcloud/lib/private/AppFramework/App.php(152): OC\AppFramework\Http\Dispatcher->dispatch()
#7 /var/www/ncsrv/nextcloud/lib/private/Route/Router.php(309): OC\AppFramework\App::main()
#8 /var/www/ncsrv/nextcloud/lib/base.php(1008): OC\Route\Router->match()
#9 /var/www/ncsrv/nextcloud/index.php(37): OC::handleRequest()
#10 {main}

Next Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT `id`, `artist_id` FROM `oc_audioplayer_albums` WHERE `user_id` = ? AND `name` = ? AND `folder_id` = ?' with params ["TheAdmin", "Unbekannt", 53435]:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'folder_id' in 'where clause' in /var/www/ncsrv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60
Stack trace:
#0 /var/www/ncsrv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(169): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
#1 /var/www/ncsrv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(149): Doctrine\DBAL\DBALException::wrapException()
#2 /var/www/ncsrv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(162): Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
#3 /var/www/ncsrv/nextcloud/apps/audioplayer/lib/Controller/DbController.php(297): Doctrine\DBAL\Statement->execute()
#4 /var/www/ncsrv/nextcloud/apps/audioplayer/lib/Controller/ScannerController.php(305): OCA\audioplayer\Controller\DbController->writeAlbumToDB()
#5 /var/www/ncsrv/nextcloud/apps/audioplayer/lib/Controller/ScannerController.php(176): OCA\audioplayer\Controller\ScannerController->scanAudio()
#6 /var/www/ncsrv/nextcloud/lib/private/AppFramework/Http/Dispatcher.php(169): OCA\audioplayer\Controller\ScannerController->scanForAudios()
#7 /var/www/ncsrv/nextcloud/lib/private/AppFramework/Http/Dispatcher.php(100): OC\AppFramework\Http\Dispatcher->executeController()
#8 /var/www/ncsrv/nextcloud/lib/private/AppFramework/App.php(152): OC\AppFramework\Http\Dispatcher->dispatch()
#9 /var/www/ncsrv/nextcloud/lib/private/Route/Router.php(309): OC\AppFramework\App::main()
#10 /var/www/ncsrv/nextcloud/lib/base.php(1008): OC\Route\Router->match()
#11 /var/www/ncsrv/nextcloud/index.php(37): OC::handleRequest()
#12 {main}

GET /apps/audioplayer/scanforaudiofiles?requesttoken=[CHANGED]
from [IP filtered] by TheAdmin at 2021-02-20T09:40:04+01:00
PHP Error #3
Error: Cannot modify header information - headers already sent by (output started at /var/www/ncsrv/nextcloud/lib/private/legacy/OC_EventSource.php:118) at /var/www/ncsrv/nextcloud/lib/private/AppFramework/Http/Output.php#70

<<closure>>

OC\Log\ErrorHandler::onError()

/var/www/ncsrv/nextcloud/lib/private/AppFramework/Http/Output.php - line 70:

header()

/var/www/ncsrv/nextcloud/lib/private/AppFramework/App.php - line 157:

OC\AppFramework\Http\Output->setHeader()

/var/www/ncsrv/nextcloud/lib/private/Route/Router.php - line 309:

OC\AppFramework\App::main()

/var/www/ncsrv/nextcloud/lib/base.php - line 1008:

OC\Route\Router->match()

/var/www/ncsrv/nextcloud/index.php - line 37:

OC::handleRequest()`

But probably i should open another topic on this errors?

Thanks in advance!

Best regards,
Dolo

1 Like