Errors while upgrading from database version 29
VLC raise errors while upgrading from database version 29
[0000556cf9535d90] medialibrary medialibrary error: [T#140322179483392] ../src/MediaLibrary.cpp:1436 updateDatabaseModel An error occurred during the database upgrade: Failed to run request [CREATE TRIGGER playlist_update_nb_media_on_media_deletion AFTER DELETE ON Media BEGIN UPDATE Playlist SET nb_present_media = nb_present_media - (CASE old.is_present WHEN 0 THEN 0 ELSE pl_cnt.cnt END), nb_media = nb_media - pl_cnt.cnt FROM (SELECT COUNT(media_id) AS cnt, playlist_id FROM PlaylistMediaRelation WHERE media_id = old.id_media GROUP BY playlist_id) AS pl_cnt WHERE id_playlist = pl_cnt.playlist_id;DELETE FROM PlaylistMediaRelation WHERE media_id = old.id_media; END]: near "FROM": syntax error(1)
database for reference: ml.db