oops. I gave you the wrong database query.
mythtv> select * from settings where value = 'DBSchemaVer';
Sorry, I moused up the one that failed before I got it right...
Eric
On 11/17/2010 08:27 AM, Eric Lund wrote:
> Folks,
>
> I am looking into improving support for newer versions of MythTV in
> libcmyth and in mvpmc itself. I have discovered that the mythtv
> database interactions in mvpmc are versioned based on the mythtv
> protocol version, which is a bit of a blunt instrument when deciding
> which database schema to use. It would be better to base this on the
> schema version, but I don't have historical data for all of the schema
> versions going back in time (unless someone out there has that
> information, in which case, by all means send it my way). What I do
> have is the relevant schema characteristics that go with several
> protocol versions (as reflected in code), and a way to determine the
> current schema version and protocol version of a given MythTV
> installation.
>
> So, I am making a request of anyone currently using MythTV with mvpmc
> (or thinking about using mvpmc with an existing MythTV installation)
> to send me your Database Schema Version and Protocol version. From
> that, I hope to be able to map the two together for the MythTV
> versions that are currently in use in the community.
>
> The procedure is as follows:
>
> Log into your mythtv system, then:
>
> To find the database schema version:
>
> $ mysql -umythtv -pmythtv mythconverg
> mysql> select * from settings where value = DBSchemaVer;
>
> and capture the output. Then to get out of mysql:
>
> mysql> quit;
>
> To get the protocol version:
>
> $ mythfrontend --version
>
> and look for a line that looks like:
>
> Network Protocol : 40
>
> The number is the protocol version.
>
> Please reply directly to me to avoid putting a bunch of data on the
> lists. I will collate and summarize what I learn on the developer
> list.
>
> Thanks for your help on this!
>
> Eric
>
>
> ------------------------------------------------------------------------------
> Beautiful is writing same markup. Internet Explorer 9 supports
> standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2& L3.
> Spend less time writing and rewriting code and more time creating great
> experiences on the web. Be a part of the beta today
> http://p.sf.net/sfu/msIE9-sfdev2dev
> _______________________________________________
> Mvpmc-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/mvpmc-devel
>
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
_______________________________________________
Mvpmc-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mvpmc-users
mvpmc wiki: http://mvpmc.wikispaces.com/
