Steps to reproduce
- Fresh manual installation of owncloud 10.4.0 on Debian host
- Add some files and install audioplayer plugin
- 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