[mythtv-users] database error before every recording starts on 0.19-fixes svn revision 9709.

Michael T. Dean mtdean at thirdcontact.com
Fri Apr 14 16:01:22 UTC 2006


On 04/14/2006 09:19 AM, Khanh Tran wrote:
> I recently went to svn 9709 and now I'm getting database errors when a
> recording starts:
>
> 2006-04-14 08:30:02.579 DB Error (Copy program data on record):
> Query was:
> REPLACE INTO recordedprogram SELECT * from program WHERE chanid = '2123' AND sta
> rttime = '2006-04-14T08:30:00';
> Driver error was [2/1136]:
> QMYSQL3: Unable to execute query
> Database error was:
> Column count doesn't match value count at row 1
>
> 2006-04-14 08:30:02.621 TVRec(1): Changing from None to RecordingOnly

Your subject says you're running 0.19-fixes and the error would occur 
there if and only if you had previously run SVN head (somewhere between 
r9668 but before r9686) and then went back to 0.19-fixes...

If you have DBSchemaVer 1136, that's exactly what happened:

mysql -umythtv -p mythconverg -e "SELECT * FROM settings WHERE value = 
'DBSchemaVer';"

In SVN head, [9686] fixes the issue ( 
http://www.gossamer-threads.com/lists/mythtv/commits/197056#197056 ) .

Are you absolutely sure /all/ your Myth systems (frontends and backends) 
are using 0.19-fixes?  At some point, you've run a non-fixes SVN head 
version of Myth.  Running different versions of Myth frontends/backends 
and "downgrading" your Myth system are not supported.

If you want to stay on 0.19-fixes, how old is your last 0.19-fixes 
database backup?

Mike


More information about the mythtv-users mailing list