2010-07-31, 21:59
cg5150 Wrote:EDIT - This is definitely an XBMC bug related to the fact that the MySQL server is set to support UTF8 character sets. The database tables fail because an index doesn't create properly because of length under UTF8. Specifically this SQL Statement Fails:This issue was already posted a while back in this same thread.
CREATE UNIQUE INDEX ix_path ON path ( strPath )
With this error message:
ERROR: SQL: Undefined MySQL error: Code (1071)
which is a length error likely because the database was created by default as UTF8. UTF8 stores multiple bytes per character (to support languages with other character sets) as opposed to a single byte per character. Once the SQL statement errors, no further create table statements are attempted. I had to turn on debug logging to see the errors.
I was able to get around the problem by dropping all of the tables in the Music and Video databases. Then changing BOTH databases to be Character Set: latin1 and Collation: latin1_general_ci.
Check this post for more info.