DB error while building library: PDOException: SQLSTATE[22007] when audioplayer scanning

Steps to reproduce

  1. Fresh manual installation of owncloud 10.4.0 on Debian host
  2. Add some files and install audioplayer plugin
  3. Try to scan the library. Only some of the files are visible. Re-scanning shows that there are some files, which might be added, but they aren’t

Expected behaviour

All of the files are added to library

Actual behaviour

Output of the scan command
su - www-data -s /bin/bash -c ‘/media/storage/owncloud/occ audioplayer:scan marcin -vv’
< audio files, which are present in the library >
Final audio files to be processed: 695
Total stream files: 0
Checking stream files to be skipped
Final stream files to be processed: 0
Start processing of audio files
< audio files which are not in the library >
Audios found: 26
Duplicates found: 0
Written to library: 26
Albums found: 8
Errors: 0

owncloud.log | tail
{"reqId":"XnOCmlDtPxgLVcE1RouC0wAAAAI","level":3,"time":"2020-03-19T14:32:59+00:00","remoteAddr":"192.168.2.121","user":"marcin","app":"no app in context","method":"GET","url":"\/owncloud\/index.php\/apps\/audioplayer\/scanforaudiofiles?requesttoken=MAABH1oOSDUVGyVpTTYyHwYoYjwvGjQ9cxNJNDgtLik%3D%3AZjhM3m1oTrN%2F8cWFpy7DiycUCVfspeiLTKqUMhRA%2BO0%3D","message":"DB error while building library: PDOException: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\\xFE\\xFF' for column `owncloud`.`oc_audioplayer_albums`.`name` at row 1 in \/media\/storage\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php:117\nStack trace:\n#0 \/media\/storage\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php(117): PDOStatement->execute(Array)\n#1 \/media\/storage\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Statement.php(153): Doctrine\\DBAL\\Driver\\PDOStatement->execute(Array)\n#2 \/media\/storage\/owncloud\/apps-external\/audioplayer\/lib\/Controller\/DbController.php(304): Doctrine\\DBAL\\Statement->execute(Array)\n#3 \/media\/storage\/owncloud\/apps-external\/audioplayer\/lib\/Controller\/ScannerController.php(305): OCA\\audioplayer\\Controller\\DbController->writeAlbumToDB('marcin', '\\xFE\\xFF', 0, NULL, 331)\n#4 \/media\/storage\/owncloud\/apps-external\/audioplayer\/lib\/Controller\/ScannerController.php(176): OCA\\audioplayer\\Controller\\ScannerController->scanAudio(Object(OC\\Files\\Node\\File), Object(getID3), Object(Symfony\\Component\\Console\\Output\\NullOutput))\n#5 \/media\/storage\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(153): OCA\\audioplayer\\Controller\\ScannerController->scanForAudios(NULL, Object(Symfony\\Component\\Console\\Output\\NullOutput), NULL)\n#6 \/media\/storage\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(85): OC\\AppFramework\\Http\\Dispatcher->executeController(Object(OCA\\audioplayer\\Controller\\ScannerController), 'scanForAudios')\n#7 \/media\/storage\/owncloud\/lib\/private\/AppFramework\/App.php(100): OC\\AppFramework\\Http\\Dispatcher->dispatch(Object(OCA\\audioplayer\\Controller\\ScannerController), 'scanForAudios')\n#8 \/media\/storage\/owncloud\/lib\/private\/AppFramework\/Routing\/RouteActionHandler.php(47): OC\\AppFramework\\App::main('OCA\\\\audioplayer...', 'scanForAudios', Object(OC\\AppFramework\\DependencyInjection\\DIContainer), Array)\n#9 \/media\/storage\/owncloud\/lib\/private\/Route\/Router.php(342): OC\\AppFramework\\Routing\\RouteActionHandler->__invoke(Array)\n#10 \/media\/storage\/owncloud\/lib\/base.php(920): OC\\Route\\Router->match('\/apps\/audioplay...')\n#11 \/media\/storage\/owncloud\/index.php(54): OC::handleRequest()\n#12 {main}\n\nNext Doctrine\\DBAL\\Driver\\PDOException: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\\xFE\\xFF' for column `owncloud`.`oc_audioplayer_albums`.`name` at row 1 in \/media\/storage\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php:119\nStack trace:\n#0 \/media\/storage\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Statement.php(153): Doctrine\\DBAL\\Driver\\PDOStatement->execute(Array)\n#1 \/media\/storage\/owncloud\/apps-external\/audioplayer\/lib\/Controller\/DbController.php(304): Doctrine\\DBAL\\Statement->execute(Array)\n#2 \/media\/storage\/owncloud\/apps-external\/audioplayer\/lib\/Controller\/ScannerController.php(305): OCA\\audioplayer\\Controller\\DbController->writeAlbumToDB('marcin', '\\xFE\\xFF', 0, NULL, 331)\n#3 \/media\/storage\/owncloud\/apps-external\/audioplayer\/lib\/Controller\/ScannerController.php(176): OCA\\audioplayer\\Controller\\ScannerController->scanAudio(Object(OC\\Files\\Node\\File), Object(getID3), Object(Symfony\\Component\\Console\\Output\\NullOutput))\n#4 \/media\/storage\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(153): OCA\\audioplayer\\Controller\\ScannerController->scanForAudios(NULL, Object(Symfony\\Component\\Console\\Output\\NullOutput), NULL)\n#5 \/media\/storage\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(85): OC\\AppFramework\\Http\\Dispatcher->executeController(Object(OCA\\audioplayer\\Controller\\ScannerController), 'scanForAudios')\n#6 \/media\/storage\/owncloud\/lib\/private\/AppFramework\/App.php(100): OC\\AppFramework\\Http\\Dispatcher->dispatch(Object(OCA\\audioplayer\\Controller\\ScannerController), 'scanForAudios')\n#7 \/media\/storage\/owncloud\/lib\/private\/AppFramework\/Routing\/RouteActionHandler.php(47): OC\\AppFramework\\App::main('OCA\\\\audioplayer...', 'scanForAudios', Object(OC\\AppFramework\\DependencyInjection\\DIContainer), Array)\n#8 \/media\/storage\/owncloud\/lib\/private\/Route\/Router.php(342): OC\\AppFramework\\Routing\\RouteActionHandler->__invoke(Array)\n#9 \/media\/storage\/owncloud\/lib\/base.php(920): OC\\Route\\Router->match('\/apps\/audioplay...')\n#10 \/media\/storage\/owncloud\/index.php(54): OC::handleRequest()\n#11 {main}\n\nNext Doctrine\\DBAL\\Exception\\DriverException: An exception occurred while executing 'INSERT INTO `oc_audioplayer_albums` (`user_id`,`name`,`folder_id`) VALUES(?,?,?)' with params [\"marcin\", \"\\xfe\\xff\", 331]:\n\nSQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\\xFE\\xFF' for column `owncloud`.`oc_audioplayer_albums`.`name` at row 1 in \/media\/storage\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractMySQLDriver.php:106\nStack trace:\n#0 \/media\/storage\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php(169): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\DBAL\\Driver\\PDOException))\n#1 \/media\/storage\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php(145): Doctrine\\DBAL\\DBALException::wrapException(Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'An exception oc...')\n#2 \/media\/storage\/owncloud\/lib\/composer\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Statement.php(162): Doctrine\\DBAL\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException), 'INSERT INTO `oc...', Array)\n#3 \/media\/storage\/owncloud\/apps-external\/audioplayer\/lib\/Controller\/DbController.php(304): Doctrine\\DBAL\\Statement->execute(Array)\n#4 \/media\/storage\/owncloud\/apps-external\/audioplayer\/lib\/Controller\/ScannerController.php(305): OCA\\audioplayer\\Controller\\DbController->writeAlbumToDB('marcin', '\\xFE\\xFF', 0, NULL, 331)\n#5 \/media\/storage\/owncloud\/apps-external\/audioplayer\/lib\/Controller\/ScannerController.php(176): OCA\\audioplayer\\Controller\\ScannerController->scanAudio(Object(OC\\Files\\Node\\File), Object(getID3), Object(Symfony\\Component\\Console\\Output\\NullOutput))\n#6 \/media\/storage\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(153): OCA\\audioplayer\\Controller\\ScannerController->scanForAudios(NULL, Object(Symfony\\Component\\Console\\Output\\NullOutput), NULL)\n#7 \/media\/storage\/owncloud\/lib\/private\/AppFramework\/Http\/Dispatcher.php(85): OC\\AppFramework\\Http\\Dispatcher->executeController(Object(OCA\\audioplayer\\Controller\\ScannerController), 'scanForAudios')\n#8 \/media\/storage\/owncloud\/lib\/private\/AppFramework\/App.php(100): OC\\AppFramework\\Http\\Dispatcher->dispatch(Object(OCA\\audioplayer\\Controller\\ScannerController), 'scanForAudios')\n#9 \/media\/storage\/owncloud\/lib\/private\/AppFramework\/Routing\/RouteActionHandler.php(47): OC\\AppFramework\\App::main('OCA\\\\audioplayer...', 'scanForAudios', Object(OC\\AppFramework\\DependencyInjection\\DIContainer), Array)\n#10 \/media\/storage\/owncloud\/lib\/private\/Route\/Router.php(342): OC\\AppFramework\\Routing\\RouteActionHandler->__invoke(Array)\n#11 \/media\/storage\/owncloud\/lib\/base.php(920): OC\\Route\\Router->match('\/apps\/audioplay...')\n#12 \/media\/storage\/owncloud\/index.php(54): OC::handleRequest()\n#13 {main}"}
{"reqId":"XnOCmlDtPxgLVcE1RouC0wAAAAI","level":3,"time":"2020-03-19T14:33:00+00:00","remoteAddr":"192.168.2.121","user":"marcin","app":"PHP","method":"GET","url":"\/owncloud\/index.php\/apps\/audioplayer\/scanforaudiofiles?requesttoken=MAABH1oOSDUVGyVpTTYyHwYoYjwvGjQ9cxNJNDgtLik%3D%3AZjhM3m1oTrN%2F8cWFpy7DiycUCVfspeiLTKqUMhRA%2BO0%3D","message":"Cannot modify header information - headers already sent at \/media\/storage\/owncloud\/lib\/private\/AppFramework\/Http\/Output.php#62"}
{"reqId":"XnOCmlDtPxgLVcE1RouC0wAAAAI","level":3,"time":"2020-03-19T14:33:00+00:00","remoteAddr":"192.168.2.121","user":"marcin","app":"PHP","method":"GET","url":"\/owncloud\/index.php\/apps\/audioplayer\/scanforaudiofiles?requesttoken=MAABH1oOSDUVGyVpTTYyHwYoYjwvGjQ9cxNJNDgtLik%3D%3AZjhM3m1oTrN%2F8cWFpy7DiycUCVfspeiLTKqUMhRA%2BO0%3D","message":"Cannot modify header information - headers already sent at \/media\/storage\/owncloud\/lib\/private\/AppFramework\/Http\/Output.php#62"}
{"reqId":"XnOCmlDtPxgLVcE1RouC0wAAAAI","level":3,"time":"2020-03-19T14:33:00+00:00","remoteAddr":"192.168.2.121","user":"marcin","app":"PHP","method":"GET","url":"\/owncloud\/index.php\/apps\/audioplayer\/scanforaudiofiles?requesttoken=MAABH1oOSDUVGyVpTTYyHwYoYjwvGjQ9cxNJNDgtLik%3D%3AZjhM3m1oTrN%2F8cWFpy7DiycUCVfspeiLTKqUMhRA%2BO0%3D","message":"Cannot modify header information - headers already sent at \/media\/storage\/owncloud\/lib\/private\/AppFramework\/Http\/Output.php#62"}
{"reqId":"XnOCmlDtPxgLVcE1RouC0wAAAAI","level":3,"time":"2020-03-19T14:33:00+00:00","remoteAddr":"192.168.2.121","user":"marcin","app":"PHP","method":"GET","url":"\/owncloud\/index.php\/apps\/audioplayer\/scanforaudiofiles?requesttoken=MAABH1oOSDUVGyVpTTYyHwYoYjwvGjQ9cxNJNDgtLik%3D%3AZjhM3m1oTrN%2F8cWFpy7DiycUCVfspeiLTKqUMhRA%2BO0%3D","message":"Cannot modify header information - headers already sent at \/media\/storage\/owncloud\/lib\/private\/AppFramework\/Http\/Output.php#62"}
{"reqId":"XnOCmlDtPxgLVcE1RouC0wAAAAI","level":3,"time":"2020-03-19T14:33:00+00:00","remoteAddr":"192.168.2.121","user":"marcin","app":"PHP","method":"GET","url":"\/owncloud\/index.php\/apps\/audioplayer\/scanforaudiofiles?requesttoken=MAABH1oOSDUVGyVpTTYyHwYoYjwvGjQ9cxNJNDgtLik%3D%3AZjhM3m1oTrN%2F8cWFpy7DiycUCVfspeiLTKqUMhRA%2BO0%3D","message":"Cannot modify header information - headers already sent at \/media\/storage\/owncloud\/lib\/private\/AppFramework\/Http\/Output.php#62"}

Server configuration

Operating system:
cat /etc/debian_version
10.3
Web server:
Server version: Apache/2.4.38 (Debian)
Database:
Server version: 10.3.22-MariaDB-0+deb10u1 Debian 10
PHP version:
PHP 7.3.11-1~deb10u1 (cli) (built: Oct 26 2019 14:14:18) ( NTS )
ownCloud version: (see ownCloud admin page)
owncloud 10.4.0
Updated from an older ownCloud or fresh install:
Fresh install
Where did you install ownCloud from:
Official website (owncloud-10.4.0.tar.bz2)
Signing status (ownCloud 9.0 and above):
No errors have been found.

The content of config/config.php:

List of activated apps:
Enabled:

  • audioplayer: 2.8.4
  • comments: 0.3.0
  • configreport: 0.2.0
  • dav: 0.5.0
  • federatedfilesharing: 0.5.0
  • federation: 0.1.0
  • files: 1.5.2
  • files_external: 0.7.1
  • files_mediaviewer: 1.0.1
  • files_sharing: 0.12.0
  • files_trashbin: 0.9.1
  • files_versions: 1.3.0
  • firstrunwizard: 1.2.0
  • market: 0.5.0
  • notifications: 0.5.0
  • provisioning_api: 0.5.0
  • systemtags: 0.3.0
  • updatenotification: 0.2.1
    Disabled:
  • encryption
  • external
  • user_external

Are you using external storage, if yes which one: local/smb/sftp/…
No
Are you using encryption: yes/no
No
Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/…
No

Client configuration

Browser:
Opera 66.0.3515.115
Operating system:
Windows 7

Logs

ownCloud log (data/owncloud.log)

Just a note: I formatted the error output and moved the post to the server-apps category.

Hey,

i think this is an issue which should be reported to the app developer of this audioplayer: https://github.com/rello/audioplayer/issues

Yes, exactly. I have just found that it is connected with specific files. I have identified one of them, which is causing the problem (do not know why yet). The message in the topic is the result of something, which is connected with behavior of the audioplayer app. The app was not supect for me because I have been using it for year now without any issues.
Should I mark as “solved”? Or should this topic be removed?

Hey,

it seems the app developer was already notified and is aware of this but haven’t figured out the problem yet: