[hobleyd]

I assume I have misconfigured something? I assume this is related to the UTF character in the filename? Can someone please point me in the right direction...

From the logs:

Code:


1-02-28 11:29:48.890 T:140121498244672   ERROR: GetFileId (nfs://syn01/volume1/xbmc/Television/Person of Interest/Season 2/2x11 - 2πR.mkv) failed
2021-02-28 11:29:48.891 T:140121498244672   ERROR: SQL: [xbmc_video116] Undefined MySQL error: Code (1267)
                                            Query: select idFile from files where strFileName='2x11 - 2πR.mkv' and idPath=2202
2021-02-28 11:29:48.891 T:140121498244672   ERROR: GetFileId (nfs://syn01/volume1/xbmc/Television/Person of Interest/Season 2/2x11 - 2πR.mkv) failed
2021-02-28 11:29:48.891 T:140121498244672   ERROR: SQL: [xbmc_video116] Undefined MySQL error: Code (1267)
                                            Query: select idFile from files where strFileName='2x11 - 2πR.mkv' and idPath=2202
2021-02-28 11:29:48.892 T:140121498244672   ERROR: GetFileId (nfs://syn01/volume1/xbmc/Television/Person of Interest/Season 2/2x11 - 2πR.mkv) failed
2021-02-28 11:29:48.892 T:140121498244672   ERROR: SQL: [xbmc_video116] Undefined MySQL error: Code (1267)
                                            Query: select idFile from files where strFileName='2x11 - 2πR.mkv' and idPath=2202
2021-02-28 11:29:48.892 T:140121498244672   ERROR: GetFileId (nfs://syn01/volume1/xbmc/Television/Person of Interest/Season 2/2x11 - 2πR.mkv) failed


Cheers,
David

[Karellen]

@hobleyd

Need the full Debug Log thanks.

[hobleyd]

@hobleyd

Need the full Debug Log thanks.

There was nothing (useful) in the debug log other than the lines I extracted; I renamed the file to not contain the unicode character. Ran the scan again, and this time it failed on the insert:

Code:


UPDATE episode SET c00='2πR',c01='Finch goes under cover to protect a youth who reminds him of himself; Carter goes on a dangerous mission for the FBI.',c03='25057',c04='Dan Dietz',c05='2013-01-03',c06='<thumb>https://image.tmdb.org/t/p/original/6O2Qxp9zZL6WpQgIFyYHnuW3seY.jpg</thumb>',c07='',c09='0',c10='Richard J. Lewis',c11='',c12='2',c13='11',c14='',c15='-1',c16='-1',c17='-1',c18='nfs://syn01/volume1/xbmc/Television/Person of Interest/Season 2/2x11 - 2PiR.mkv',c19='2202',c20='48297', userrating = NULL, idSeason = 98946 where idEpisode=30548;
ERROR 1366 (22007): Incorrect string value: '\xCF\x80R' for column `xbmc_video116`.`episode`.`c00` at row 1


So I assume my DB doesn't have the correct character set specified. If I run that SQL manually and change c00='2πR' to c00='2PiR' then it all works and the rest of the season scans in successfully.

I assume my DB does not have UTF specified somewhere. Not sure how to fix that though. Could it be an incompatibility between MySQL and MariaDB (which I am using)?

[pkscout]

@hobleyd

Need the full Debug Log thanks.

There was nothing (useful) in the debug log other than the lines I extracted

There is a ton of useful information in the debug log that you might not realize is useful. So, unfortunately, until you post a link to a full debug log, there isn't anything we can do to help.

[hobleyd]

@hobleyd

Need the full Debug Log thanks.

There was nothing (useful) in the debug log other than the lines I extracted

There is a ton of useful information in the debug log that you might not realize is useful. So, unfortunately, until you post a link to a full debug log, there isn't anything we can do to help.

I truly love the work you guys do and am extremely thankful for it.

But I have no desire to upload a debug log which has my entire library collection in there to resolve a character set issue with the database. I'll keep trying to work out what is happening myself. I really do appreciate your responses though.

Cheers,
David