[mk01]

(22nd Jun, 2014 08:44 PM)nsviper Wrote:  In Music32, there are 3 Views: albumview, artistview, songview - not recreated in Music46
In Video75, there are 4 Views: episodeview, movieview, musicvideoview, tvshowview - not recreated in Video78

Going to try and manually create these to see if it fixes issue, but thought I'd let you know.

(edit) Just spotted none of the triggers are in place either...

that's crazy as this happens for EACH xbmc major upgrade. I was affected by this on going 10-11 and 11-12. what I always did was grabbing .sql command for views and indexes from XBMC sources and run them as SQL commands from mysql command line. I also manually changed DB version numbers (in the table version - to the one new XBMC expected).

it didn;t happen for me this time 12->13 - probably because I was updating to Gotham much sooner and DB wasn't making HUGE jumps at DB versions. but actually it was more upgrades in smaller steps.

google will find you more such reports (even with very old date) - meaning clearly a BUG with XBMC team impossible to track it down.