Solved mysql reading problem
#19
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:
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?
Texture Cache Maintenance Utility: Preload your texture cache for optimal UI performance. Remotely manage media libraries. Purge unused artwork to free up space. Find missing media. Configurable QA check to highlight metadata issues. Aid in diagnosis of library and cache related problems.
Reply


Messages In This Thread
mysql reading problem - by Edwinus - 2014-02-15, 01:25
RE: mysql reading problem - by Kib - 2014-02-15, 10:58
RE: mysql reading problem - by Edwinus - 2014-02-15, 12:20
RE: mysql reading problem - by Edwinus - 2014-02-16, 23:34
RE: mysql reading problem - by nickr - 2014-02-16, 23:39
RE: mysql reading problem - by Edwinus - 2014-02-17, 06:06
RE: mysql reading problem - by nickr - 2014-02-17, 07:25
RE: mysql reading problem - by Kib - 2014-02-17, 12:44
RE: mysql reading problem - by Edwinus - 2014-02-18, 01:18
RE: mysql reading problem - by nickr - 2014-02-18, 02:51
RE: mysql reading problem - by Edwinus - 2014-02-18, 12:09
RE: mysql reading problem - by nickr - 2014-02-18, 21:07
RE: mysql reading problem - by Edwinus - 2014-02-18, 21:31
RE: mysql reading problem - by nickr - 2014-02-18, 21:41
Re: mysql reading problem - by Milhouse - 2014-02-19, 12:58
RE: mysql reading problem - by Edwinus - 2014-02-19, 13:27
RE: mysql reading problem - by Milhouse - 2014-02-19, 14:14
RE: mysql reading problem - by Edwinus - 2014-02-19, 18:53
RE: mysql reading problem - by Milhouse - 2014-02-19, 19:12
RE: mysql reading problem - by Edwinus - 2014-02-20, 00:01
RE: mysql reading problem - by Milhouse - 2014-02-20, 00:30
RE: mysql reading problem - by Edwinus - 2014-02-20, 19:21
RE: mysql reading problem - by danomac - 2015-03-18, 03:57
RE: mysql reading problem - by unrequited - 2017-12-01, 08:21
RE: mysql reading problem - by fizze - 2016-07-15, 19:31
RE: mysql reading problem - by bigwang - 2017-01-19, 07:19
RE: mysql reading problem - by danomac - 2017-01-19, 08:11
RE: mysql reading problem - by killbilly - 2020-01-16, 05:26
RE: mysql reading problem - by killbilly - 2020-01-17, 04:10
RE: mysql reading problem - by black_eagle - 2020-01-17, 21:26
RE: mysql reading problem - by pkscout - 2020-01-18, 00:21
Logout Mark Read Team Forum Stats Members Help
mysql reading problem0