v18 LibreELEC Testbuilds for x86_64 (Kodi 18.0)
(2018-08-22, 23:16)Milhouse Wrote:
(2018-08-22, 23:05)Nekromantik Wrote:
(2018-08-22, 21:50)Milhouse Wrote: Too late - we need to see the migration.

Enable debug logging, drop MyVideos112 and reboot - then upload your debug log. 
Debug log after dropping table and rebooting
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.  
That was it.
Had to grant user Super permissions which is annoying.
Thanks


Messages In This Thread
RE: LibreELEC Testbuilds for x86_64 (Kodi 18.0) - by Nekromantik - 2018-08-22, 23:54
Logout Mark Read Team Forum Stats Members Help
LibreELEC Testbuilds for x86_64 (Kodi 18.0)24