[mythtv-users] Viedo2ipod script error

[Brad DerManouelian]

On Apr 16, 2008, at 10:03 AM, Jeff Simpson wrote:

>> I strongly recommend against using the video2ipod script to put  
>> videos
>> back into mythtv .20. You will likely have to update the script to
>> match the old schema to do this. Unmodified, at best you will get
>> unpredictable results. :)
>> Hopefully at some point someone will update the perl bindings such
>> that sticking stuff in the recorded programs will do the right thing
>> depending on what version you have installed, but until then it's  
>> hard-
>> coded to the current version.
>
> The perl bindings installed will be matched to whatever version of
> myth is installed, won't they?
>
> The problem comes in with how I'm doing the update - copying the new
> recording to the myth_storage_dir as defined earlier in the thread,
> then doing a mysql UPDATE, matching chanid and starttime and updating
> "basename". If the previous database schema has the "basename" field,
> it should still work. If they don't use it the same way, it might not.

Right. No way of knowing if you will break something at some point.

> I *think* it should still work. I recommend taking a close look at the
> "recorded" table before blindly running the script. If anyone could
> point me to a list of the schema changes, that would help, too.

Yes, it will probably work for now, but not 2 years from now when  
someone finds this in the archive and follows these instructions. It  
would be much better if no scripts did any modifying of the  
mythconverg database directly.

If all you're doing is an update to the basename, then maybe something  
should be added to the perl bindings to move a recoding to a new  
directory. Do the update there and then just call the new "move  
recording" function. Pass it the object and new location and let the  
bindings update the database so it can all be maintained in one area  
and other scripts can make use of it.

-Brad