Movie Wiz ERROR translating column image. Exception of type 'System.OutOfMemoryExcept

[mk000]

Do you simply mean to zoom on the image and have it take up the whole (or most) of the screen?

If you have a SQLite editor, you'd just have to run a simple query, something like:

[/QUOTE]


Exactly... I think that would be great. Say you backup a DVD, your image is the dvd cover, and even on my 24inch lcd, I cant read anything but the big print on the cover image.

[mk000]

Memory usage is enormous with the 110mb file... see attached.:eek::eek::eek::o

[JavaWiz]

A good SQLite GUI can be found here:
http://www.sqliteexpert.com/download.html

After installing the personal edition, to clear the image column in the db, do the following:

• Make a copy of MovieWiz.DB3 incase of problems.
  
• Start up SQLite Expert
  
• Select File->Open Database
  
• Navigate to gbpvr/plugins/MovieWiz
  
• Select MovieWiz.db3
  
• Select the SQL tab in right pane
  
• Type the following in the SQL text area:
  • Update Movies Set image=null;
• Press F5 to run the query, it should come back with 'No data to display'
  
• From the menu, select Database-->Vacuum
  
• Exit the program.

You should now notice the size of the database has decreased dramatically since all the BLOB data for the images has been removed.

NOTE: If you store your images in either the directory the video file exists in OR gbpvr/media/art, you don't actually have to store the image in the db. The plugin code will automatically look in that directory if an image does not exist in the db. This should keep the size of the DB down.

I will have to add a feature in the next release that gives you the option of storing the local image or retrieving from the disk.