2018-08-22, 23:16
(2018-08-22, 23:05)Nekromantik Wrote:(2018-08-22, 21:50)Milhouse Wrote:Debug log after dropping table and rebooting(2018-08-22, 19:55)Nekromantik Wrote: Just updated to #0820 and it tried to upgrade the SQL database and failed.
Log is here https://paste.ubuntu.com/p/NT2qcPT2rK/
Too late - we need to see the migration.
Enable debug logging, drop MyVideos112 and reboot - then upload your debug log.
https://paste.ubuntu.com/p/2yPY9tTXvP/
text:
22:01:21.313 T:140274495907584 INFO: CreateAnalytics - creating triggers
22:01:21.313 T:140274495907584 DEBUG: Mysql execute: CREATE TRIGGER delete_movie AFTER DELETE ON movie FOR EACH ROW BEGIN DELETE FROM genre_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM actor_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM director_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM studio_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM country_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM writer_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM movielinktvshow WHERE idMovie=old.idMovie; DELETE FROM art WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM tag_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM rating WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM uniqueid WHERE media_id=old.idMovie AND media_type='movie'; END
22:01:21.319 T:140274495907584 ERROR: SQL: [MyVideos112] Undefined MySQL error: Code (1419)
Query: CREATE TRIGGER delete_movie AFTER DELETE ON movie FOR EACH ROW BEGIN DELETE FROM genre_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM actor_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM director_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM studio_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM country_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM writer_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM movielinktvshow WHERE idMovie=old.idMovie; DELETE FROM art WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM tag_link WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM rating WHERE media_id=old.idMovie AND media_type='movie'; DELETE FROM uniqueid WHERE media_id=old.idMovie AND media_type='movie'; END
22:01:21.336 T:140274495907584 ERROR: Exception updating database MyVideos112 from version 110 to 112
22:01:21.336 T:140274495907584 ERROR: Error updating database MyVideos112 from version 110 to 112
22:01:21.340 T:140274495907584 DEBUG: Mysql rollback transaction
Error 1419 seems to be a permission problem in the database.
I would suggest leaving debugging enabled, then booting into #0819 as this will try to migrate your MyVideos110 database to MyVideos111 - if that also has the problem then we can rule out the change in #0820 and most likely this is a general issue with your database configuration (inability to create triggers) which you'll need to fix.