search

Rello / audioplayer

Audio Player for Nextcloud and ownCloud
https://rello.github.io/audioplayer
GNU Affero General Public License v3.0
221 stars 54 forks source link

Database user_id format issue #384

Closed Rello closed 5 years ago

Rello commented 5 years ago

Hello there, Scan always stuck on same file, here is the error log line:

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'INSERT INTO `oc_audioplayer_tracks` (`user_id`,`title`,`number`,`artist_id`,`album_id`,`length`,`file_id`,`bitrate`,`mimetype`,`genre_id`,`year`,`folder_id`,`disc`,`composer`,`subtitle`,`isrc`,`copyright`) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)' with params ["username", "\x41\x6d\x6f\x75\x72\x65\x75\x78\x20\x44\x65\x73\x20\x52\xea\x76\x65\x73", 1, 556, 642, "3:47", 9047, 1038688, "audio\/flac", 84, 2018, 2189, 1, "", "", "", ""]: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xEAves' for column `username`.`oc_audioplayer_tracks`.`title` at row 1
--

Anyway, thanks for this nice app! 👍

Originally posted by @Micdu70 in https://github.com/Rello/audioplayer/issues/362#issuecomment-470620263

Rello commented 5 years ago

Hello @Micdu70 I will have a look. this looks strange

thank you for reporting

Micdu70 commented 5 years ago

The problem was a bad 'title' tag encoding => "Amoureux des R�ves" (should be "Amoureux des Rêves", displayed on Windows) Using mp3tag software, displayed "Amoureux des R" so I edited this tag and it's okay now.

Rello commented 5 years ago

ok. thank you