[mike390]

Code:

22:03:32 T:3336   ERROR: SQL: Undefined MySQL error: Code (1366)
                                            Query: insert into files (idFile, idPath, strFileName) values(NULL, 16, 'Weeds.S07E11.Une M?re Que J\'aimerais Baiser.mkv')
22:03:32 T:3336   ERROR: CVideoDatabase::AddFile unable to addfile ()
22:03:32 T:3336   ERROR: SQL: Undefined MySQL error: Code (1366)
                                            Query: insert into files (idFile, idPath, strFileName) values(NULL, 16, 'Weeds.S07E11.Une M?re Que J\'aimerais Baiser.mkv')
22:03:32 T:3336   ERROR: CVideoDatabase::AddFile unable to addfile ()
22:03:38 T:8416  NOTICE: Thread Background Loader start, auto delete: false
22:03:42 T:3336  NOTICE: VideoInfoScanner: Finished scan. Scanning for video info took 00:51
22:03:42 T:7312  NOTICE: Thread Background Loader start, auto delete: false

I am scanning my tv shows using a mysql library on xbmc. It stops soon after it starts scanning and I pulled this from the log file. I think it doesnt like the invalid characters (it shows the ? as an a spade) that '?'' is supposed to be an e with an accent above it. I already found and tried this fix which did not help:
CREATE DATABASE xbmc_video CHARACTER SET latin1 COLLATE latin1_general_ci;

Any Ideas how to fix this?

[mike390]

Additional info:

I tried building the library without using MySQL and used a regular default library. I scanned my tv show directories using a fresh XBMC 12.2 installation and I recieved this error message while it was scanning the same Show:

22:30:26 T:6036 NOTICE: VideoInfoScanner: Starting scan ..
22:30:53 T:6036 ERROR: XFILE::CNFSFile::Read - Error( -14, pread call failed with "" )
22:30:54 T:6128 NOTICE: Thread Jobworker start, auto delete: true
22:30:59 T:6128 ERROR: XFILE::CNFSFile::Read - Error( -14, pread call failed with "" )
22:31:24 T:6036 ERROR: Previous line repeats 3 times.
22:31:24 T:6036 ERROR: XFILE::CNFSFile::Read - Error( -14, pread call failed with "" )
22:31:29 T:6128 ERROR: XFILE::CNFSFile::Read - Error( -14, pread call failed with "" )
22:33:29 T:6036 ERROR: Previous line repeats 23 times.
22:33:29 T:6036 ERROR: XFILE::CNFSFile::Read - Error( -14, pread call failed with "" )
22:33:34 T:6128 ERROR: XFILE::CNFSFile::Read - Error( -14, pread call failed with "" )
22:47:35 T:6128 ERROR: Previous line repeats 167 times.

I am starting to think that 12.2 has a bug with accented filenames, these files scanned with no problem in previous versions. Unless I am doing something wrong?

[hick]

I know there are some issues of Mysql 5.6 and I do not see what version you are running.

[mike390]

Sorry, I am running MySQL 5.5, The issue also happens when I setup a normal database not using MySQL.