Re: [mythtv-users] new recordings missing database fields after R5A22 upgrade

2005-10-26 Thread Byron Poland
On 10/26/05, Michael T. Dean <[EMAIL PROTECTED]> wrote: > Byron Poland wrote: > > >I had to compile from SVN to get the protocol on my > >frontend (ubuntu) (Which I also use as a slave backend to commflag and > >transcode) to match up with the backend (knoppmyth R5A22) so they > >very well could b

Re: [mythtv-users] new recordings missing database fields after R5A22 upgrade

2005-10-26 Thread Michael T. Dean
Byron Poland wrote: I had to compile from SVN to get the protocol on my frontend (ubuntu) (Which I also use as a slave backend to commflag and transcode) to match up with the backend (knoppmyth R5A22) so they very well could be different versions. I just located the source for the knoppmyth ve

Re: [mythtv-users] new recordings missing database fields after R5A22 upgrade

2005-10-26 Thread Michael T. Dean
Bruce Markey wrote: Byron Poland wrote: On 10/26/05, Michael T. Dean <[EMAIL PROTECTED]> wrote: Byron Poland wrote: On 10/26/05, Michael T. Dean <[EMAIL PROTECTED]> wrote: Byron Poland wrote: Here is the relevant part of my backend log on on startup: 2005-10-26 15:02:15.804 Using runt

Re: [mythtv-users] new recordings missing database fields after R5A22 upgrade

2005-10-26 Thread Byron Poland
On 10/26/05, Bruce Markey <[EMAIL PROTECTED]> wrote: > Byron Poland wrote: > > On 10/26/05, Michael T. Dean <[EMAIL PROTECTED]> wrote: > >> Byron Poland wrote: > >> > >>> On 10/26/05, Michael T. Dean <[EMAIL PROTECTED]> wrote: > >>> > >>> > Byron Poland wrote: > > > Here is the releva

Re: [mythtv-users] new recordings missing database fields after R5A22 upgrade

2005-10-26 Thread Bruce Markey
Byron Poland wrote: On 10/26/05, Michael T. Dean <[EMAIL PROTECTED]> wrote: Byron Poland wrote: On 10/26/05, Michael T. Dean <[EMAIL PROTECTED]> wrote: Byron Poland wrote: Here is the relevant part of my backend log on on startup: 2005-10-26 15:02:15.804 Using runtime prefix = /usr QSett

Re: [mythtv-users] new recordings missing database fields after R5A22 upgrade

2005-10-26 Thread Byron Poland
On 10/26/05, Michael T. Dean <[EMAIL PROTECTED]> wrote: > Byron Poland wrote: > > >On 10/26/05, Michael T. Dean <[EMAIL PROTECTED]> wrote: > > > > > >>Byron Poland wrote: > >> > >>>Here is the relevant part of my backend log on on startup: > >>> > >>>2005-10-26 15:02:15.804 Using runtime prefix = /

Re: [mythtv-users] new recordings missing database fields after R5A22 upgrade

2005-10-26 Thread Michael T. Dean
Byron Poland wrote: On 10/26/05, Michael T. Dean <[EMAIL PROTECTED]> wrote: Byron Poland wrote: Here is the relevant part of my backend log on on startup: 2005-10-26 15:02:15.804 Using runtime prefix = /usr QSettings::sync: filename is null/empty 2005-10-26 15:02:15.953 New DB connection,

Re: [mythtv-users] new recordings missing database fields after R5A22 upgrade

2005-10-26 Thread Byron Poland
On 10/26/05, Michael T. Dean <[EMAIL PROTECTED]> wrote: > Byron Poland wrote: > > >Here is the relevant part of my backend log on on startup: > > > >2005-10-26 15:02:15.804 Using runtime prefix = /usr > >QSettings::sync: filename is null/empty > >2005-10-26 15:02:15.953 New DB connection, total: 1

Re: [mythtv-users] new recordings missing database fields after R5A22 upgrade

2005-10-26 Thread Michael T. Dean
Byron Poland wrote: Here is the relevant part of my backend log on on startup: 2005-10-26 15:02:15.804 Using runtime prefix = /usr QSettings::sync: filename is null/empty 2005-10-26 15:02:15.953 New DB connection, total: 1 2005-10-26 15:02:15.991 Setting Lock for Database Schema upgrade. If you

Re: [mythtv-users] new recordings missing database fields after R5A22 upgrade

2005-10-26 Thread Byron Poland
On 10/26/05, Kevin Kuphal <[EMAIL PROTECTED]> wrote: > Michael T. Dean wrote: > > > Kevin Kuphal wrote: > > > >> Sounds like a DB update was missed. If you do not have the basename > >> field in your DB, execute this SQL statement against it: > >> > >> ALTER TABLE recorded ADD COLUMN basename varc

Re: [mythtv-users] new recordings missing database fields after R5A22 upgrade

2005-10-26 Thread Kevin Kuphal
Michael T. Dean wrote: Kevin Kuphal wrote: Sounds like a DB update was missed. If you do not have the basename field in your DB, execute this SQL statement against it: ALTER TABLE recorded ADD COLUMN basename varchar(128) NOT NULL DEFAULT; and then, once it is in your database, run this:

Re: [mythtv-users] new recordings missing database fields after R5A22 upgrade

2005-10-26 Thread Byron Poland
On 10/26/05, Michael T. Dean <[EMAIL PROTECTED]> wrote: > Byron Poland wrote: > > >On 10/26/05, Kevin Kuphal <[EMAIL PROTECTED]> wrote: > > > > > >>Byron Poland wrote: > >> > >> > >> > >>>Since upgrading my backend to Knoppmyth R5A22, all of the recordings > >>>I've made are missing the basename, p

Re: [mythtv-users] new recordings missing database fields after R5A22 upgrade

2005-10-26 Thread Michael T. Dean
Byron Poland wrote: On 10/26/05, Kevin Kuphal <[EMAIL PROTECTED]> wrote: Byron Poland wrote: Since upgrading my backend to Knoppmyth R5A22, all of the recordings I've made are missing the basename, progstart, and progend fields (ie they are blank). this causes jobs like commercial fl

Re: [mythtv-users] new recordings missing database fields after R5A22 upgrade

2005-10-26 Thread Michael T. Dean
Kevin Kuphal wrote: Sounds like a DB update was missed. If you do not have the basename field in your DB, execute this SQL statement against it: ALTER TABLE recorded ADD COLUMN basename varchar(128) NOT NULL DEFAULT; and then, once it is in your database, run this: UPDATE recorded SET basen

Re: [mythtv-users] new recordings missing database fields after R5A22 upgrade

2005-10-26 Thread Byron Poland
On 10/26/05, Kevin Kuphal <[EMAIL PROTECTED]> wrote: > Byron Poland wrote: > > >Since upgrading my backend to Knoppmyth R5A22, all of the recordings > >I've made are missing the basename, progstart, and progend fields (ie > >they are blank). this causes jobs like commercial flagging to fail. > >If

Re: [mythtv-users] new recordings missing database fields after R5A22 upgrade

2005-10-26 Thread Kevin Kuphal
Byron Poland wrote: Since upgrading my backend to Knoppmyth R5A22, all of the recordings I've made are missing the basename, progstart, and progend fields (ie they are blank). this causes jobs like commercial flagging to fail. If I fill in the missing data manually into the tables, things work