{"action":"created","issue":{"url":"https://api.github.com/repos/AzuraCast/AzuraCast/issues/635","repository_url":"https://api.github.com/repos/AzuraCast/AzuraCast","labels_url":"https://api.github.com/repos/AzuraCast/AzuraCast/issues/635/labels{/name}","comments_url":"https://api.github.com/repos/AzuraCast/AzuraCast/issues/635/comments","events_url":"https://api.github.com/repos/AzuraCast/AzuraCast/issues/635/events","html_url":"https://github.com/AzuraCast/AzuraCast/issues/635","id":336966426,"node_id":"MDU6SXNzdWUzMzY5NjY0MjY=","number":635,"title":"SQL ERROR and memory error processing media folders","user":{"login":"sterreke","id":2543474,"node_id":"MDQ6VXNlcjI1NDM0NzQ=","avatar_url":"https://avatars2.githubusercontent.com/u/2543474?v=4","gravatar_id":"","url":"https://api.github.com/users/sterreke","html_url":"https://github.com/sterreke","followers_url":"https://api.github.com/users/sterreke/followers","following_url":"https://api.github.com/users/sterreke/following{/other_user}","gists_url":"https://api.github.com/users/sterreke/gists{/gist_id}","starred_url":"https://api.github.com/users/sterreke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sterreke/subscriptions","organizations_url":"https://api.github.com/users/sterreke/orgs","repos_url":"https://api.github.com/users/sterreke/repos","events_url":"https://api.github.com/users/sterreke/events{/privacy}","received_events_url":"https://api.github.com/users/sterreke/received_events","type":"User","site_admin":false},"labels":[{"id":964053657,"node_id":"MDU6TGFiZWw5NjQwNTM2NTc=","url":"https://api.github.com/repos/AzuraCast/AzuraCast/labels/error","name":"error","color":"fbca04","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-06-29T11:37:29Z","updated_at":"2018-07-02T01:39:59Z","closed_at":null,"author_association":"NONE","body":"**Installation method**\r\nDocker\r\n\r\n**Host OS (for Docker installations)**\r\nUbuntu 16.04\r\n\r\n**Describe the bug**\r\nI have a music library of +50k songs mounted via NFS.\r\nPHP.ini setting\r\nmemory_limit = 256M\r\n\r\nProcessing the media folders fails with following errors:\r\n\r\nIn Browser:\r\n\r\nERROR: An exception occurred while executing 'INSERT INTO station_media (station_id, song_id, title, artist, album, lyrics, isrc, length, length_text, path, mtime, fade_overlap, fade_in, fade_out, cue_in, cue_out, unique_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [1, \"7e380e568cffbe8611293863a665a697\", \"Track 10\", null, null, null, null, 131, \"2:10\", \"\\x4d\\x50\\x33\\x2f\\x56\\x6f\\x6f\\x72\\x20\\x64\\x65\\x20\\x6b\\x69\\x64\\x73\\x2f\\x53\\x69\\x6e\\x74\\x65\\x72\\x6b\\x6c\\x61\\x61\\x73\\x20\\x6d\\x75\\x7a\\x69\\x65\\x6b\\x2f\\x45\\x72\\x6e\\x73\\x74\\x20\\x42\\x6f\\x62\\x62\\x69\\x65\\x20\\x65\\x6e\\x20\\x64\\x65\\x20\\x52\\x65\\x73\\x74\\x20\\x2d\\x20\\x42\\x69\\x6a\\x20\\x53\\x69\\x6e\\x74\\x65\\x72\\x6b\\x6c\\x61\\x61\\x73\\x2f\\x31\\x30\\x20\\x2d\\x20\\x4a\\x6f\\x6e\\x67\\x65\\x6e\\x73\\x20\\x68\\x65\\x62\\x20\\x6a\\x65\\x20\\xef\\x74\\x20\\x61\\x6c\\x20\\x76\\x65\\x72\\x6e\\x6f\\x6d\\x65\\x6e\\x2e\\x6d\\x70\\x33\", 1191445776, null, null, null, null, null, \"9703c7f57102490494f0e855\"]: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\\xEFt al ...' for column 'path' at row 1\r\nfile\r\n/var/azuracast/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php\r\nline\r\n122\r\ncode\r\n0\r\n\r\nAND\r\n\r\n~$ docker logs azuracast_web_1\r\n[29-Jun-2018 10:48:13] WARNING: [pool www] child 41 said into stderr: \"NOTICE: PHP message: PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 425984 bytes) in /var/azuracast/www/vendor/doctrine/dbal/lib/Doctrine/DBAL/Types/BlobType.php on line 50\"\r\n\r\n\r\n\r\n**To Reproduce**\r\nSteps to reproduce the behavior:\r\n2. Click in administrator page on '5 min sync - Check media folders'\r\n\r\n\r\n**Expected behavior**\r\nCorrect processing of all music files.\r\n\r\n**Screenshots**\r\nIf applicable, add screenshots to help explain your problem.\r\n![image](https://user-images.githubusercontent.com/2543474/42090193-ba37ee32-7ba0-11e8-809e-5ea0b6f0bd67.png)\r\n![image](https://user-images.githubusercontent.com/2543474/42090208-cea42890-7ba0-11e8-93aa-bbc40a9ad19d.png)\r\n![image](https://user-images.githubusercontent.com/2543474/42090223-e6d65762-7ba0-11e8-9ac2-fc3887b70c01.png)\r\n\r\n\r\n**Desktop (please complete the following information):**\r\n - OS: Windows 7\r\n - Browser chrome\r\n - Version 67.0.3396.99 (Officiële build) (64-bits) \r\n\r\n**Smartphone (please complete the following information):**\r\n - Device: N/A\r\n - OS: N/A\r\n - Browser N/A\r\n - Version N/A\r\n\r\n**Additional context**\r\nN/A\r\n"},"comment":{"url":"https://api.github.com/repos/AzuraCast/AzuraCast/issues/comments/401649791","html_url":"https://github.com/AzuraCast/AzuraCast/issues/635#issuecomment-401649791","issue_url":"https://api.github.com/repos/AzuraCast/AzuraCast/issues/635","id":401649791,"node_id":"MDEyOklzc3VlQ29tbWVudDQwMTY0OTc5MQ==","user":{"login":"SlvrEagle23","id":6744885,"node_id":"MDQ6VXNlcjY3NDQ4ODU=","avatar_url":"https://avatars1.githubusercontent.com/u/6744885?v=4","gravatar_id":"","url":"https://api.github.com/users/SlvrEagle23","html_url":"https://github.com/SlvrEagle23","followers_url":"https://api.github.com/users/SlvrEagle23/followers","following_url":"https://api.github.com/users/SlvrEagle23/following{/other_user}","gists_url":"https://api.github.com/users/SlvrEagle23/gists{/gist_id}","starred_url":"https://api.github.com/users/SlvrEagle23/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SlvrEagle23/subscriptions","organizations_url":"https://api.github.com/users/SlvrEagle23/orgs","repos_url":"https://api.github.com/users/SlvrEagle23/repos","events_url":"https://api.github.com/users/SlvrEagle23/events{/privacy}","received_events_url":"https://api.github.com/users/SlvrEagle23/received_events","type":"User","site_admin":false},"created_at":"2018-07-02T01:39:59Z","updated_at":"2018-07-02T01:39:59Z","author_association":"MEMBER","body":"@sterreke Looking into this issue, I'm a little baffled at the fact that MariaDB is trying to insert the song's path as an escaped Unicode string, despite the decoded string consisting of entirely normal ASCII characters as far as I can tell.\r\n\r\nAlso, the error about \"invalid datetime\" is especially concerning, as there is no datetime being inserted in that query, and that has me wondering if there's some sort of invalid Unicode there that's escaping out of the query, despite the fact that we use prepared statements across the board.\r\n\r\nIf you don't mind, can you copy/paste the exact path of the file that's causing that problem? Also, did you upload it via SFTP or via the web interface?"}}
{"actor":{"display_login":"SlvrEagle23"}}