2014-02-19, 19:12
You can make the log a lot easierto follow by grepping out all the CECLogMessage spam/crap.
As for the log, this doesn't look good:
Error 1419 is:
I'm not entirely sure why you're getting this error, but check that you have set (granted) the permissions correctly on the xbmc user in the database.
You also don't have any views, but it's not apparent why they have not been created:
My advice would be to:
1) Check your user permissions again
2) Consider using a more recent version of MySQL, eg. v5.5 (but not v5.6 as you are not using a recent Gotham nightly). Is there any specific reason you are using this really quite old v5.1.36?
As for the log, this doesn't look good:
Code:
16:26:47 T:3046793216 INFO: create albuminfo trigger
16:26:47 T:3046793216 DEBUG: Mysql execute: CREATE TRIGGER tgrAlbumInfo AFTER delete ON albuminfo FOR EACH ROW BEGIN delete from albuminfosong where albuminfosong.idAlbumInfo=old.idAlbumInfo; END
16:26:47 T:3046793216 ERROR: SQL: Undefined MySQL error: Code (1419)
Query: CREATE TRIGGER tgrAlbumInfo AFTER delete ON albuminfo FOR EACH ROW BEGIN delete from albuminfosong where albuminfosong.idAlbumInfo=old.idAlbumInfo; END
16:26:47 T:3046793216 ERROR: CreateTables unable to create tables:0
16:26:47 T:3046793216 DEBUG: Mysql rollback transaction
...
16:26:50 T:3046793216 INFO: create deletion triggers
16:26:50 T:3046793216 DEBUG: Mysql execute: CREATE TRIGGER delete_movie AFTER DELETE ON movie FOR EACH ROW BEGIN DELETE FROM art WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM taglinks WHERE idMedia=old.idMovie AND media_type='movie'; END
16:26:50 T:3046793216 ERROR: SQL: Undefined MySQL error: Code (1419)
Query: CREATE TRIGGER delete_movie AFTER DELETE ON movie FOR EACH ROW BEGIN DELETE FROM art WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM taglinks WHERE idMedia=old.idMovie AND media_type='movie'; END
16:26:50 T:3046793216 ERROR: CreateTables unable to create tables:0
16:26:50 T:3046793216 DEBUG: Mysql rollback transaction
Error 1419 is:
Quote:Error: 1419 SQLSTATE: HY000 (ER_BINLOG_CREATE_ROUTINE_NEED_SUPER)
Message: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)
I'm not entirely sure why you're getting this error, but check that you have set (granted) the permissions correctly on the xbmc user in the database.
You also don't have any views, but it's not apparent why they have not been created:
Code:
16:30:53 T:2841637984 ERROR: SQL: The table does not exist
Query: select * from movieview ORDER BY dateAdded desc, idMovie desc LIMIT 10
16:30:53 T:2841637984 ERROR: GetMoviesByWhere failed
16:30:53 T:2841637984 ERROR: SQL: The table does not exist
Query: select * from episodeview ORDER BY dateAdded desc, idEpisode desc LIMIT 10
16:30:53 T:2841637984 ERROR: GetEpisodesByWhere failed
16:30:53 T:2841637984 ERROR: SQL: The table does not exist
Query: select * from musicvideoview ORDER BY dateAdded desc, idMVideo desc LIMIT 10
16:30:53 T:2841637984 ERROR: GetMusicVideosByWhere failed
My advice would be to:
1) Check your user permissions again
2) Consider using a more recent version of MySQL, eg. v5.5 (but not v5.6 as you are not using a recent Gotham nightly). Is there any specific reason you are using this really quite old v5.1.36?