Various database errors with 11.3.0

For help and support with Universal Media Server
Forum rules
Please make sure you follow the Problem Reporting Guidelines before posting if you want a reply
Post Reply
galmok
Posts: 18
Joined: Wed Mar 26, 2014 10:31 pm

Various database errors with 11.3.0

Post by galmok »

Every single fil scanned reports these errors:

15:55:52 DEBUG Error while getting cached information about FOO.mkv, reparsing information: Data conversion error converting "JAVA_OBJECT to CHARACTER VARYING" [22018-214]
15:55:52 ERROR Database error while trying to add parsed information for "V:\Serier\FOO.mkv" to the cache: Data conversion error converting "'16:9' (FILES: ""ASPECTRATIOCONTAINER"" JAVA_OBJECT SELECTIVITY 1)"; SQL statement:
UPDATE "PUBLIC"."FILES" SET "ID"=? ,"FILENAME"=? ,"MODIFIED"=? ,"FORMAT_TYPE"=? ,"DURATION"=? ,"BITRATE"=? ,"WIDTH"=? ,"HEIGHT"=? ,"MEDIA_SIZE"=? ,"CODECV"=? ,"FRAMERATE"=? ,"ASPECTRATIODVD"=? ,"ASPECTRATIOCONTAINER"=? ,"ASPECTRATIOVIDEOTRACK"=? ,"REFRAMES"=? ,"AVCLEVEL"=? ,"IMAGEINFO"=? ,"CONTAINER"=? ,"MUXINGMODE"=? ,"FRAMERATEMODE"=? ,"STEREOSCOPY"=? ,"MATRIXCOEFFICIENTS"=? ,"TITLECONTAINER"=? ,"TITLEVIDEOTRACK"=? ,"VIDEOTRACKCOUNT"=? ,"IMAGECOUNT"=? ,"BITDEPTH"=? ,"PIXELASPECTRATIO"=? ,"SCANTYPE"=? ,"SCANORDER"=? ,"IMDBID"=? ,"MEDIA_YEAR"=? ,"MOVIEORSHOWNAME"=? ,"MOVIEORSHOWNAMESIMPLE"=? ,"TVSEASON"=? ,"TVEPISODENUMBER"=? ,"TVEPISODENAME"=? ,"ISTVEPISODE"=? ,"EXTRAINFORMATION"=? WHERE "ID"=? [22018-214]
15:55:52 ERROR Database error while trying to add parsed information for "V:\Serier\FOO.mkv" to the cache: Data conversion error converting "'16:9' (FILES: ""ASPECTRATIOCONTAINER"" JAVA_OBJECT SELECTIVITY 1)"; SQL statement:
UPDATE "PUBLIC"."FILES" SET "ID"=? ,"FILENAME"=? ,"MODIFIED"=? ,"FORMAT_TYPE"=? ,"DURATION"=? ,"BITRATE"=? ,"WIDTH"=? ,"HEIGHT"=? ,"MEDIA_SIZE"=? ,"CODECV"=? ,"FRAMERATE"=? ,"ASPECTRATIODVD"=? ,"ASPECTRATIOCONTAINER"=? ,"ASPECTRATIOVIDEOTRACK"=? ,"REFRAMES"=? ,"AVCLEVEL"=? ,"IMAGEINFO"=? ,"CONTAINER"=? ,"MUXINGMODE"=? ,"FRAMERATEMODE"=? ,"STEREOSCOPY"=? ,"MATRIXCOEFFICIENTS"=? ,"TITLECONTAINER"=? ,"TITLEVIDEOTRACK"=? ,"VIDEOTRACKCOUNT"=? ,"IMAGECOUNT"=? ,"BITDEPTH"=? ,"PIXELASPECTRATIO"=? ,"SCANTYPE"=? ,"SCANORDER"=? ,"IMDBID"=? ,"MEDIA_YEAR"=? ,"MOVIEORSHOWNAME"=? ,"MOVIEORSHOWNAMESIMPLE"=? ,"TVSEASON"=? ,"TVEPISODENUMBER"=? ,"TVEPISODENAME"=? ,"ISTVEPISODE"=? ,"EXTRAINFORMATION"=? WHERE "ID"=? [22018-214]
15:55:52 ERROR Could not update the database with information from the filename for "V:\Serier\FOO.mkv": Column "VERSION" not found; SQL statement:
SELECT ID, IMDBID, MEDIA_YEAR, MOVIEORSHOWNAME, MOVIEORSHOWNAMESIMPLE, TVSEASON, TVEPISODENUMBER, TVEPISODENAME, ISTVEPISODE, EXTRAINFORMATION, VERSION, BUDGET, CREDITS, EXTERNALIDS, HOMEPAGE, IMAGES, ORIGINALLANGUAGE, ORIGINALTITLE, PRODUCTIONCOMPANIES, PRODUCTIONCOUNTRIES, REVENUE FROM FILES WHERE FILENAME = ? AND MODIFIED = ? LIMIT 1 [42122-214]
15:55:52 ERROR Database "medias" error while checking if API metadata exists for in "FILES" for "V:\Serier\FOO.mkv": Column "VERSION" not found; SQL statement:
SELECT ID FROM FILES WHERE FILENAME = ? AND MODIFIED = ? AND VERSION = ? AND IMDBID IS NOT NULL LIMIT 1 [42122-214]

Is this something that can be fixed manually?
galmok
Posts: 18
Joined: Wed Mar 26, 2014 10:31 pm

Re: Various database errors with 11.3.0

Post by galmok »

Removing the database seems to fix this. Apparently a migration problem from older versions (forgot to include database migration script).
Post Reply