Jump to content

Error: no such column: Revenue

TheTom

By TheTom
in Linux

 Share

Recommended Posts

TheTom

TheTom   0

Posted
Posted (edited)

Hi,

I got today a problem, on display the content of my library. One of them don't get displayed. I see only the loading cicle for ever and ever.

In the Logs I found this:

*** Error Report ***
    Version: 3.2.20.0
    Command line: /usr/lib/emby-server/bin/MediaBrowser.Server.Mono.exe -programdata /var/lib/emby-server -restartpath /usr/lib/emby-server/restart.sh
    Operating system: Unix 4.4.0.45
    64-Bit OS: True
    64-Bit Process: True
    Mono: 4.8.1 (Stable 4.8.1.0/22a39d7 Tue May 2 22:27:58 UTC 2017)
    Processor count: 2
    Program data path: /var/lib/emby-server
    Application directory: /usr/lib/emby-server/bin
    Error: no such column: Revenue
    SQLitePCL.pretty.SQLiteException: Exception of type 'SQLitePCL.pretty.SQLiteException' was thrown.
     at SQLitePCL.pretty.SQLiteException.CheckOk (SQLitePCL.sqlite3 db, System.Int32 rc) [0x0001a] in <926d5dc8f35f4aae9a6008f11f233fd0>:0
     at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement (System.String sql, System.String& tail) [0x00038] in <926d5dc8f35f4aae9a6008f11f233fd0>:0
     at SQLitePCL.pretty.DelegatingDatabaseConnection.PrepareStatement (System.String sql, System.String& tail) [0x0001c] in <926d5dc8f35f4aae9a6008f11f233fd0>:0
     at SQLitePCL.pretty.DatabaseConnection.PrepareStatement (SQLitePCL.pretty.IDatabaseConnection This, System.String sql) [0x0000c] in <926d5dc8f35f4aae9a6008f11f233fd0>:0
     at System.Linq.Enumerable+WhereSelectListIterator`2[TSource,TResult].MoveNext () [0x00064] in <2392cff65f724abaaed9de072f62bc4a>:0
     at System.Collections.Generic.List`1[T]..ctor (System.Collections.Generic.IEnumerable`1[T] collection) [0x0008b] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Linq.Enumerable.ToList[TSource] (System.Collections.Generic.IEnumerable`1[T] source) [0x00011] in <2392cff65f724abaaed9de072f62bc4a>:0
     at Emby.Server.Implementations.Data.BaseSqliteRepository.PrepareAllSafe (SQLitePCL.pretty.IDatabaseConnection connection, System.Collections.Generic.IEnumerable`1[T] sql) [0x00012] in <f3590c895ee547b18c6ac7056ea3d50c>:0
     at Emby.Server.Implementations.Data.SqliteItemRepository+<GetItems>c__AnonStorey10.<>m__0 (SQLitePCL.pretty.IDatabaseConnection db) [0x00006] in <f3590c895ee547b18c6ac7056ea3d50c>:0
     at SQLitePCL.pretty.DatabaseConnection.RunInTransaction[T] (SQLitePCL.pretty.IDatabaseConnection This, System.Func`2[T,TResult] f, SQLitePCL.pretty.TransactionMode mode) [0x0003f] in <926d5dc8f35f4aae9a6008f11f233fd0>:0
    --- End of stack trace from previous location where exception was thrown ---
     at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0004e] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x0002e] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x0000b] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at MediaBrowser.Api.UserLibrary.ItemsService+<Get>c__async0.MoveNext () [0x0008a] in <825d807d5ac040a48f8c30e2dd18292d>:0
    --- End of stack trace from previous location where exception was thrown ---
     at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0004e] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x0002e] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x0000b] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.ConfiguredTaskAwaitable+ConfiguredTaskAwaiter.GetResult () [0x00000] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at Emby.Server.Implementations.Services.ServiceExecGeneral+<Execute>c__async0.MoveNext () [0x00185] in <f3590c895ee547b18c6ac7056ea3d50c>:0
    --- End of stack trace from previous location where exception was thrown ---
     at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0004e] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x0002e] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x0000b] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at Emby.Server.Implementations.Services.ServiceHandler+<ProcessRequestAsync>c__async1.MoveNext () [0x0016b] in <f3590c895ee547b18c6ac7056ea3d50c>:0
    --- End of stack trace from previous location where exception was thrown ---
     at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0004e] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x0002e] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x0000b] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.ConfiguredTaskAwaitable+ConfiguredTaskAwaiter.GetResult () [0x00000] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at Emby.Server.Implementations.HttpServer.HttpListenerHost+<RequestHandler>c__async0.MoveNext () [0x006c8] in <f3590c895ee547b18c6ac7056ea3d50c>:0
    SQLitePCL.pretty.SQLiteException
     at SQLitePCL.pretty.SQLiteException.CheckOk (SQLitePCL.sqlite3 db, System.Int32 rc) [0x0001a] in <926d5dc8f35f4aae9a6008f11f233fd0>:0
     at SQLitePCL.pretty.SQLiteDatabaseConnection.PrepareStatement (System.String sql, System.String& tail) [0x00038] in <926d5dc8f35f4aae9a6008f11f233fd0>:0
     at SQLitePCL.pretty.DelegatingDatabaseConnection.PrepareStatement (System.String sql, System.String& tail) [0x0001c] in <926d5dc8f35f4aae9a6008f11f233fd0>:0
     at SQLitePCL.pretty.DatabaseConnection.PrepareStatement (SQLitePCL.pretty.IDatabaseConnection This, System.String sql) [0x0000c] in <926d5dc8f35f4aae9a6008f11f233fd0>:0
     at System.Linq.Enumerable+WhereSelectListIterator`2[TSource,TResult].MoveNext () [0x00064] in <2392cff65f724abaaed9de072f62bc4a>:0
     at System.Collections.Generic.List`1[T]..ctor (System.Collections.Generic.IEnumerable`1[T] collection) [0x0008b] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Linq.Enumerable.ToList[TSource] (System.Collections.Generic.IEnumerable`1[T] source) [0x00011] in <2392cff65f724abaaed9de072f62bc4a>:0
     at Emby.Server.Implementations.Data.BaseSqliteRepository.PrepareAllSafe (SQLitePCL.pretty.IDatabaseConnection connection, System.Collections.Generic.IEnumerable`1[T] sql) [0x00012] in <f3590c895ee547b18c6ac7056ea3d50c>:0
     at Emby.Server.Implementations.Data.SqliteItemRepository+<GetItems>c__AnonStorey10.<>m__0 (SQLitePCL.pretty.IDatabaseConnection db) [0x00006] in <f3590c895ee547b18c6ac7056ea3d50c>:0
     at SQLitePCL.pretty.DatabaseConnection.RunInTransaction[T] (SQLitePCL.pretty.IDatabaseConnection This, System.Func`2[T,TResult] f, SQLitePCL.pretty.TransactionMode mode) [0x0003f] in <926d5dc8f35f4aae9a6008f11f233fd0>:0
    --- End of stack trace from previous location where exception was thrown ---
     at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0004e] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x0002e] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x0000b] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at MediaBrowser.Api.UserLibrary.ItemsService+<Get>c__async0.MoveNext () [0x0008a] in <825d807d5ac040a48f8c30e2dd18292d>:0
    --- End of stack trace from previous location where exception was thrown ---
     at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0004e] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x0002e] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x0000b] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.ConfiguredTaskAwaitable+ConfiguredTaskAwaiter.GetResult () [0x00000] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at Emby.Server.Implementations.Services.ServiceExecGeneral+<Execute>c__async0.MoveNext () [0x00185] in <f3590c895ee547b18c6ac7056ea3d50c>:0
    --- End of stack trace from previous location where exception was thrown ---
     at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0004e] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x0002e] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x0000b] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at Emby.Server.Implementations.Services.ServiceHandler+<ProcessRequestAsync>c__async1.MoveNext () [0x0016b] in <f3590c895ee547b18c6ac7056ea3d50c>:0
    --- End of stack trace from previous location where exception was thrown ---
     at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0004e] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x0002e] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x0000b] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at System.Runtime.CompilerServices.ConfiguredTaskAwaitable+ConfiguredTaskAwaiter.GetResult () [0x00000] in <dbb16e0bacdc4a0f87478e401bc29b6c>:0
     at Emby.Server.Implementations.HttpServer.HttpListenerHost+<RequestHandler>c__async0.MoveNext () [0x006c8] in <f3590c895ee547b18c6ac7056ea3d50c>:0
    

But I am not sure, if it is the main problem. That's why I added the full logfile (sorry some lines I dropped about the media refresh, because of privacy). Oh, I also tested to restart emby.. also I did a new media scan and refresh of meta data.. but it doesnt helped. I am at Ubuntu 14.04 and use our recommended ppa (opensuse.org).

Log.txt

Edited by TheTom
Link to comment
Share on other sites
Luke Emby Team

Luke   37251

Posted
Posted

Hi, what library isn't displaying? You're saying that some are working?

Link to comment
Share on other sites
TCr

TCr   0

Posted
Posted

Hi, now it works again. It was a movie library which dint loaded fully on the browser. Maybe a browser problem.

 

But the shown error with the missing column Revenue is for sure not okay?

 

any sql command I can execute to check where it is missing and to alter/add it?

Link to comment
Share on other sites
Luke Emby Team

Luke   37251

Posted
Posted

I think maybe you had a sort order saved in the browser for a column we no longer have. I'll look at handling this. Thanks.

Link to comment
Share on other sites
TCr

TCr   0

Posted
Posted (edited)

I dont remember that I sorted Revenue. Thats why I did a test now.. and there it came back to the same problem.. the media library didnt loaded.

thats my library.db

 

root@VDR:/var/lib/emby-server/data# sqlite3 library.db
SQLite version 3.8.2 2013-12-06 14:53:30
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .schema
CREATE TABLE TypedBaseItems (guid GUID primary key NOT NULL, type TEXT NOT NULL, data BLOB NULL, ParentId GUID NULL, Path TEXT NULL, StartDate DATETIME NULL, EndDate DATETIME NULL, ChannelId Text NULL, IsMovie BIT NULL, IsSports BIT NULL, IsKids BIT NULL, CommunityRating Float NULL, CustomRating Text NULL, IndexNumber INT NULL, IsLocked BIT NULL, Name Text NULL, OfficialRating Text NULL, MediaType Text NULL, Overview Text NULL, ParentIndexNumber INT NULL, PremiereDate DATETIME NULL, ProductionYear INT NULL, Genres Text NULL, SortName Text NULL, RunTimeTicks BIGINT NULL, OfficialRatingDescription Text NULL, HomePageUrl Text NULL, VoteCount INT NULL, DisplayMediaType Text NULL, DateCreated DATETIME NULL, DateModified DATETIME NULL, ForcedSortName Text NULL, LocationType Text NULL, IsSeries BIT NULL, IsLive BIT NULL, IsNews BIT NULL, IsPremiere BIT NULL, EpisodeTitle Text NULL, IsRepeat BIT NULL, PreferredMetadataLanguage Text NULL, PreferredMetadataCountryCode Text NULL, IsHD BIT NULL, ExternalEtag Text NULL, DateLastRefreshed DATETIME NULL, DateLastSaved DATETIME NULL, IsInMixedFolder BIT NULL, LockedFields Text NULL, Studios Text NULL, Audio Text NULL, ExternalServiceId Text NULL, Tags Text NULL, IsFolder BIT NULL, InheritedParentalRatingValue INT NULL, UnratedType Text NULL, TopParentId Text NULL, IsItemByName BIT NULL, SourceType Text NULL, TrailerTypes Text NULL, CriticRating Float NULL, CriticRatingSummary Text NULL, InheritedTags Text NULL, CleanName Text NULL, PresentationUniqueKey Text NULL, SlugName Text NULL, OriginalTitle Text NULL, PrimaryVersionId Text NULL, DateLastMediaAdded DATETIME NULL, Album Text NULL, IsVirtualItem BIT NULL, SeriesName Text NULL, UserDataKey Text NULL, SeasonName Text NULL, SeasonId GUID NULL, SeriesId GUID NULL, SeriesSortName Text NULL, ExternalSeriesId Text NULL, ShortOverview Text NULL, Tagline Text NULL, Keywords Text NULL, ProviderIds Text NULL, Images Text NULL, ProductionLocations Text NULL, ThemeSongIds Text NULL, ThemeVideoIds Text NULL, TotalBitrate INT NULL, ExtraType Text NULL, Artists Text NULL, AlbumArtists Text NULL, ExternalId Text NULL, SeriesPresentationUniqueKey Text NULL);
CREATE TABLE AncestorIds (ItemId GUID, AncestorId GUID, AncestorIdText TEXT, PRIMARY KEY (ItemId, AncestorId));
CREATE INDEX idx_AncestorIds1 on AncestorIds(AncestorId);
CREATE INDEX idx_AncestorIds2 on AncestorIds(AncestorIdText);
CREATE TABLE ItemValues (ItemId GUID, Type INT, Value TEXT, CleanValue TEXT);
CREATE TABLE People (ItemId GUID, Name TEXT NOT NULL, Role TEXT, PersonType TEXT, SortOrder int, ListOrder int);
CREATE INDEX idxPeopleItemId1 on People(ItemId,ListOrder);
CREATE INDEX idxPeopleName on People(Name);
CREATE TABLE Chapters2 (ItemId GUID, ChapterIndex INT, StartPositionTicks BIGINT, Name TEXT, ImagePath TEXT, ImageDateModified DATETIME NULL, PRIMARY KEY (ItemId, ChapterIndex));
CREATE TABLE mediastreams (ItemId GUID, StreamIndex INT, StreamType TEXT, Codec TEXT, Language TEXT, ChannelLayout TEXT, Profile TEXT, AspectRatio TEXT, Path TEXT, IsInterlaced BIT, BitRate INT NULL, Channels INT NULL, SampleRate INT NULL, IsDefault BIT, IsForced BIT, IsExternal BIT, Height INT NULL, Width INT NULL, AverageFrameRate FLOAT NULL, RealFrameRate FLOAT NULL, Level FLOAT NULL, PixelFormat TEXT, BitDepth INT NULL, IsAnamorphic BIT NULL, RefFrames INT NULL, CodecTag TEXT NULL, Comment TEXT NULL, NalLengthSize TEXT NULL, IsAvc BIT NULL, Title TEXT NULL, TimeBase TEXT NULL, CodecTimeBase TEXT NULL, KeyFrames TEXT NULL, PRIMARY KEY (ItemId, StreamIndex));
CREATE INDEX idx_mediastreams1 on mediastreams(ItemId);
CREATE INDEX idx_PathTypedBaseItems on TypedBaseItems(Path);
CREATE INDEX idx_ParentIdTypedBaseItems on TypedBaseItems(ParentId);
CREATE INDEX idx_PresentationUniqueKey on TypedBaseItems(PresentationUniqueKey);
CREATE INDEX idx_GuidTypeIsFolderIsVirtualItem on TypedBaseItems(Guid,Type,IsFolder,IsVirtualItem);
CREATE INDEX idx_CleanNameType on TypedBaseItems(CleanName,Type);
CREATE INDEX idx_TopParentIdGuid on TypedBaseItems(TopParentId,Guid);
CREATE INDEX idx_TypeSeriesPresentationUniqueKey1 on TypedBaseItems(Type,SeriesPresentationUniqueKey,PresentationUniqueKey,SortName);
CREATE INDEX idx_TypeSeriesPresentationUniqueKey3 on TypedBaseItems(SeriesPresentationUniqueKey,Type,IsFolder,IsVirtualItem);
CREATE INDEX idx_TypeTopParentIdStartDate on TypedBaseItems(Type,TopParentId,StartDate);
CREATE INDEX idx_TypeTopParentIdGuid on TypedBaseItems(Type,TopParentId,Guid);
CREATE INDEX idx_TypeTopParentIdGroup on TypedBaseItems(Type,TopParentId,PresentationUniqueKey);
CREATE INDEX idx_TypeTopParentId5 on TypedBaseItems(TopParentId,IsVirtualItem);
CREATE INDEX idx_TypeTopParentId9 on TypedBaseItems(TopParentId,Type,IsVirtualItem,PresentationUniqueKey,DateCreated);
CREATE INDEX idx_TypeTopParentId8 on TypedBaseItems(TopParentId,IsFolder,IsVirtualItem,PresentationUniqueKey,DateCreated);
CREATE INDEX idx_TypeTopParentId7 on TypedBaseItems(TopParentId,MediaType,IsVirtualItem,PresentationUniqueKey);
CREATE INDEX idx_ItemValues6 on ItemValues(ItemId,Type,CleanValue);
CREATE INDEX idx_ItemValues7 on ItemValues(Type,CleanValue,ItemId);
CREATE TABLE userdata (key nvarchar, userId GUID, rating float null, played bit, playCount int, isFavorite bit, playbackPositionTicks bigint, lastPlayedDate datetime null, AudioStreamIndex int NULL, SubtitleStreamIndex int NULL);
CREATE TABLE DataSettings (IsUserDataImported bit);
CREATE UNIQUE INDEX userdataindex on userdata (key, userId);
CREATE INDEX userdataindex2 on userdata (key, userId, played);
CREATE INDEX userdataindex3 on userdata (key, userId, playbackPositionTicks);
CREATE INDEX userdataindex4 on userdata (key, userId, isFavorite);
sqlite>

any column missing, or it is the wrong db?

Edited by TCr
Link to comment
Share on other sites
Luke Emby Team

Luke   37251

Posted
Posted

I don't understand, what am I supposed to be looking for in the above?

Link to comment
Share on other sites
mastrmind11

mastrmind11   717

Posted
Posted

 

I dont remember that I sorted Revenue. Thats why I did a test now.. and there it came back to the same problem.. the media library didnt loaded.

thats my library.db

 

root@VDR:/var/lib/emby-server/data# sqlite3 library.db
SQLite version 3.8.2 2013-12-06 14:53:30
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .schema
CREATE TABLE TypedBaseItems (guid GUID primary key NOT NULL, type TEXT NOT NULL, data BLOB NULL, ParentId GUID NULL, Path TEXT NULL, StartDate DATETIME NULL, EndDate DATETIME NULL, ChannelId Text NULL, IsMovie BIT NULL, IsSports BIT NULL, IsKids BIT NULL, CommunityRating Float NULL, CustomRating Text NULL, IndexNumber INT NULL, IsLocked BIT NULL, Name Text NULL, OfficialRating Text NULL, MediaType Text NULL, Overview Text NULL, ParentIndexNumber INT NULL, PremiereDate DATETIME NULL, ProductionYear INT NULL, Genres Text NULL, SortName Text NULL, RunTimeTicks BIGINT NULL, OfficialRatingDescription Text NULL, HomePageUrl Text NULL, VoteCount INT NULL, DisplayMediaType Text NULL, DateCreated DATETIME NULL, DateModified DATETIME NULL, ForcedSortName Text NULL, LocationType Text NULL, IsSeries BIT NULL, IsLive BIT NULL, IsNews BIT NULL, IsPremiere BIT NULL, EpisodeTitle Text NULL, IsRepeat BIT NULL, PreferredMetadataLanguage Text NULL, PreferredMetadataCountryCode Text NULL, IsHD BIT NULL, ExternalEtag Text NULL, DateLastRefreshed DATETIME NULL, DateLastSaved DATETIME NULL, IsInMixedFolder BIT NULL, LockedFields Text NULL, Studios Text NULL, Audio Text NULL, ExternalServiceId Text NULL, Tags Text NULL, IsFolder BIT NULL, InheritedParentalRatingValue INT NULL, UnratedType Text NULL, TopParentId Text NULL, IsItemByName BIT NULL, SourceType Text NULL, TrailerTypes Text NULL, CriticRating Float NULL, CriticRatingSummary Text NULL, InheritedTags Text NULL, CleanName Text NULL, PresentationUniqueKey Text NULL, SlugName Text NULL, OriginalTitle Text NULL, PrimaryVersionId Text NULL, DateLastMediaAdded DATETIME NULL, Album Text NULL, IsVirtualItem BIT NULL, SeriesName Text NULL, UserDataKey Text NULL, SeasonName Text NULL, SeasonId GUID NULL, SeriesId GUID NULL, SeriesSortName Text NULL, ExternalSeriesId Text NULL, ShortOverview Text NULL, Tagline Text NULL, Keywords Text NULL, ProviderIds Text NULL, Images Text NULL, ProductionLocations Text NULL, ThemeSongIds Text NULL, ThemeVideoIds Text NULL, TotalBitrate INT NULL, ExtraType Text NULL, Artists Text NULL, AlbumArtists Text NULL, ExternalId Text NULL, SeriesPresentationUniqueKey Text NULL);
CREATE TABLE AncestorIds (ItemId GUID, AncestorId GUID, AncestorIdText TEXT, PRIMARY KEY (ItemId, AncestorId));
CREATE INDEX idx_AncestorIds1 on AncestorIds(AncestorId);
CREATE INDEX idx_AncestorIds2 on AncestorIds(AncestorIdText);
CREATE TABLE ItemValues (ItemId GUID, Type INT, Value TEXT, CleanValue TEXT);
CREATE TABLE People (ItemId GUID, Name TEXT NOT NULL, Role TEXT, PersonType TEXT, SortOrder int, ListOrder int);
CREATE INDEX idxPeopleItemId1 on People(ItemId,ListOrder);
CREATE INDEX idxPeopleName on People(Name);
CREATE TABLE Chapters2 (ItemId GUID, ChapterIndex INT, StartPositionTicks BIGINT, Name TEXT, ImagePath TEXT, ImageDateModified DATETIME NULL, PRIMARY KEY (ItemId, ChapterIndex));
CREATE TABLE mediastreams (ItemId GUID, StreamIndex INT, StreamType TEXT, Codec TEXT, Language TEXT, ChannelLayout TEXT, Profile TEXT, AspectRatio TEXT, Path TEXT, IsInterlaced BIT, BitRate INT NULL, Channels INT NULL, SampleRate INT NULL, IsDefault BIT, IsForced BIT, IsExternal BIT, Height INT NULL, Width INT NULL, AverageFrameRate FLOAT NULL, RealFrameRate FLOAT NULL, Level FLOAT NULL, PixelFormat TEXT, BitDepth INT NULL, IsAnamorphic BIT NULL, RefFrames INT NULL, CodecTag TEXT NULL, Comment TEXT NULL, NalLengthSize TEXT NULL, IsAvc BIT NULL, Title TEXT NULL, TimeBase TEXT NULL, CodecTimeBase TEXT NULL, KeyFrames TEXT NULL, PRIMARY KEY (ItemId, StreamIndex));
CREATE INDEX idx_mediastreams1 on mediastreams(ItemId);
CREATE INDEX idx_PathTypedBaseItems on TypedBaseItems(Path);
CREATE INDEX idx_ParentIdTypedBaseItems on TypedBaseItems(ParentId);
CREATE INDEX idx_PresentationUniqueKey on TypedBaseItems(PresentationUniqueKey);
CREATE INDEX idx_GuidTypeIsFolderIsVirtualItem on TypedBaseItems(Guid,Type,IsFolder,IsVirtualItem);
CREATE INDEX idx_CleanNameType on TypedBaseItems(CleanName,Type);
CREATE INDEX idx_TopParentIdGuid on TypedBaseItems(TopParentId,Guid);
CREATE INDEX idx_TypeSeriesPresentationUniqueKey1 on TypedBaseItems(Type,SeriesPresentationUniqueKey,PresentationUniqueKey,SortName);
CREATE INDEX idx_TypeSeriesPresentationUniqueKey3 on TypedBaseItems(SeriesPresentationUniqueKey,Type,IsFolder,IsVirtualItem);
CREATE INDEX idx_TypeTopParentIdStartDate on TypedBaseItems(Type,TopParentId,StartDate);
CREATE INDEX idx_TypeTopParentIdGuid on TypedBaseItems(Type,TopParentId,Guid);
CREATE INDEX idx_TypeTopParentIdGroup on TypedBaseItems(Type,TopParentId,PresentationUniqueKey);
CREATE INDEX idx_TypeTopParentId5 on TypedBaseItems(TopParentId,IsVirtualItem);
CREATE INDEX idx_TypeTopParentId9 on TypedBaseItems(TopParentId,Type,IsVirtualItem,PresentationUniqueKey,DateCreated);
CREATE INDEX idx_TypeTopParentId8 on TypedBaseItems(TopParentId,IsFolder,IsVirtualItem,PresentationUniqueKey,DateCreated);
CREATE INDEX idx_TypeTopParentId7 on TypedBaseItems(TopParentId,MediaType,IsVirtualItem,PresentationUniqueKey);
CREATE INDEX idx_ItemValues6 on ItemValues(ItemId,Type,CleanValue);
CREATE INDEX idx_ItemValues7 on ItemValues(Type,CleanValue,ItemId);
CREATE TABLE userdata (key nvarchar, userId GUID, rating float null, played bit, playCount int, isFavorite bit, playbackPositionTicks bigint, lastPlayedDate datetime null, AudioStreamIndex int NULL, SubtitleStreamIndex int NULL);
CREATE TABLE DataSettings (IsUserDataImported bit);
CREATE UNIQUE INDEX userdataindex on userdata (key, userId);
CREATE INDEX userdataindex2 on userdata (key, userId, played);
CREATE INDEX userdataindex3 on userdata (key, userId, playbackPositionTicks);
CREATE INDEX userdataindex4 on userdata (key, userId, isFavorite);
sqlite>

any column missing, or it is the wrong db?

 

Luke already told you what the issue is, so yes, there's a column that's cached that is no longer in the schema.  See his post above yours.

Link to comment
Share on other sites
TCr

TCr   0

Posted
Posted (edited)

are your sure that this the problem? Or is it really true, that the "Revenue" column got dropped (history file)? It makes for me ne sense, why this column should be dropped. I was thinking more to an schema update problem, but maybe I am wrong...

 

Oh, And why can I still select the column for sorting in the web gui?

 

sorry for asking so many questions  :mellow:

Edited by TCr
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...