[momoz]

I have Eden running perfect with mysql.
I installed RC2 tonight and when I open my movies and tv shows don't show up so I checked the logs:

20:31:59 T:140735275270528 NOTICE: Old database found - updating from version 60 to 75
20:32:01 T:140735275270528 NOTICE: Attempting to update the database MyVideos75 from version 60 to 75
20:32:01 T:140735275270528 ERROR: SQL: Undefined MySQL error: Code (1142)
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'; END
20:32:01 T:140735275270528 ERROR: Exception updating database MyVideos75 from version 60 to 75
20:32:01 T:140735275270528 ERROR: Error updating database MyVideos75 from version 60 to 75
20:3


Any ideas??

Thanks,Mike

[Ned Scott]

Full debug log via pastebin.com?

[momoz]

http://pastebin.com/vSxEsugw

---

http://pastebin.com/PENjNafX
Here is a debug after I dropped the MyVideos75 database so it would recreate it..Looks like it starts to work then bombs out.

[jmarshall]

Unknown pasteid on the second, but 1142 is a permissions error - make sure your mysql user has permission to create triggers.

[momoz]

I did GRANT ALL ON *.* TO 'xbmc';

it does seem to be a mysql issue.. just can't figure it out…

[momoz]

I think my MyVideos60 db had something wrong in it causing the issues.. once I backed it up and dropped it and removed all DBs from mysql and let xbmc create a new DB then import everything back it all seems to be working…