Roll back from 4.8.0.53 to 4.7.14.0 fails.

[doonze 30]

I just have this installed on my test box to test installing of the Emby Server by my script. I had allowed my script to update it to Beta yesterday, then today I changed it back to Stable. The next run of my app told me the server was no longer up. Looking into it, there's a change in the DB from the latest Beta to the latest Stable (it seems). The Stable server won't start now because of the below:

Error Main: Error in appHost.Init

#011SQLitePCL.pretty.SQLiteException: Error: no such column: IsFolder - create index if not exists idx_MediaItems36 on MediaItems(SeriesPresentationUniqueKey,Type,IsFolder,IsVirtualItem) where SeriesPresentationUniqueKey not null;create index if not exists idx_MediaItems10 on MediaItems(Type,TopParentId,Id);create index if not exists idx_MediaItems11 on MediaItems(Type,TopParentId,PresentationUniqueKey);create index if not exists idx_MediaItems46 on MediaItems(TopParentId,IsVirtualItem) where TopParentId not null;create index if not exists idx_MediaItems47 on MediaItems(TopParentId,Type,IsVirtualItem,PresentationUniqueKey,DateCreated) where TopParentId not null;create index if not exists idx_MediaItems48 on MediaItems(TopParentId,IsFolder,IsVirtualItem,PresentationUniqueKey,DateCreated) where TopParentId not null;create index if not exists idx_MediaItems49 on MediaItems(TopParentId,MediaType,IsVirtualItem,PresentationUniqueKey) where TopParentId not null;create index if not exists idx_MediaItems50 on MediaItems(Type, TopParentId, AlbumId) where TopParentId not null;create index if not exists idx_MediaItems51 on MediaItems(Type,IsSeries) where Type=27;create index if not exists idxItemLinks_1 on ItemLinks(LinkedId, Type, ItemId)
 

So now the stable version won't start. I don't even log into these instances. They are for installation testing only. So, well, I can just wipe the install directory and try reinstall. But just dropping this out there in the world for whomever. Cheers!

[GrimReaper 4739]

Yes, mentioned numerous times that rollback Beta to Stable is not officially supported nor recommended and it won't work in vast majority of cases (especially between different branches, i.e. 4.8 vs 4.7), rebuild/starting anew is the only feasible way. 

[Luke 42077]

Hi, why did you switch it back to stable?

[doonze 30]

Figured. I tell my users as much as well. Just noticed, so dropped a note on it. 

@Luketo be honest, I have multiple copies of my update app running on different versions of Python for testing, all on the same box. I had ran a test to make sure my beta updater still worked. But the main branch I'm working on is set to stable. Of interest, I've tried to look this up myself but the release history for beta doesn't go back far enough on github. is there ever a time you use the same version number for stable that you previously used for beta?

Edited October 15, 2023 by doonze

[Luke 42077]

21 minutes ago, doonze said:

Figured. I tell my users as much as well. Just noticed, so dropped a note on it. 

@Luketo be honest, I have multiple copies of my update app running on different versions of Python for testing, all on the same box. I had ran a test to make sure my beta updater still worked. But the main branch I'm working on is set to stable. Of interest, I've tried to look this up myself but the release history for beta doesn't go back far enough on github. is there ever a time you use the same version number for stable that you previously used for beta?

Not at the same time, but as soon as 4.8 goes stable, then the version number will be something like 4.8.0.X.