[mythtv-users] Tuner details corrupted in database

Michael T. Dean mtdean at thirdcontact.com
Sat Mar 11 01:35:37 UTC 2006


On 03/10/2006 09:29 AM, Kevin Kuphal wrote:
> Sim wrote:
>   
>> I had a rock solid 0.18.1 set-up, and have just made 0.19 work on a clean 
>> install, but 0.19 on my production system refuses to work.  It seems the 
>> details of my analogue tuner are corrupted as I get various problems linked 
>> to myth looking for a digital tuner.
>>
>> Below is the output from mythtv-setup, but I get errors about atscsrcid and 
>> mplexid at various instances and it prevents any channel changing by mythtv.  
>> Having checked the groups I understand that atscsrcid and mplexid are to do 
>> with digital TV.  I have an analogue card and an analogue signal form a cable 
>> company, and there was no problem with 0.18.1.  What can i do to try and fix 
>> my problems?
>>
>> Simon
>>
>>
>> 2006-03-06 21:57:08.328 Switching to square mode (G.A.N.T.)
>> QSettings::sync: filename is null/empty
>> 2006-03-06 21:57:08.728 New DB connection, total: 2
>> 2006-03-06 21:57:08.729 Connected to database 'mythconverg' at host: localhost
>> 2006-03-06 21:57:08.731 Joystick disabled.
>> QMultiInputContext::changeInputMethod(): index=0, slave=xim
>> 2006-03-06 21:57:25.505
>> 2006-03-06 21:57:25.549
>> 2006-03-06 21:57:25.558
>> QSettings::sync: filename is null/empty
>> 2006-03-06 21:57:49.635 New DB connection, total: 3
>> 2006-03-06 21:57:49.644 Connected to database 'mythconverg' at host: localhost
>> QSettings::sync: filename is null/empty
>> 2006-03-06 21:57:49.652 New DB connection, total: 4
>> 2006-03-06 21:57:49.653 Connected to database 'mythconverg' at host: localhost
>> 2006-03-06 21:57:49.655 DB Error (SetSourceID -- get channels):
>> Query was:
>> SELECT channum FROM channel WHERE sourceid = 1 ORDER BY atscsrcid, channum
>> Driver error was [2/1054]:
>> QMYSQL3: Unable to execute query
>> Database error was:
>> Unknown column 'atscsrcid' in 'order clause'
>>
>>   
>>     
> Your database isn't right.  You're missing a column.  Probably something 
> didn't go right during the database upgrade part of your upgrade.  In my 
> database, that column is int(11).  Try adding it using something like 
> phpmyadmin and see what happens.  You can execute this SQL to add it:
>
> ALTER TABLE channel ADD COLUMN atscsrcid INT(11) DEFAULT NULL;
>
> It looks like you may be missing updates related to DB version 1062 (see 
> the relevant code here: 
> http://svn.mythtv.org/trac/browser/branches/release-0-19-fixes/mythtv/libs/libmythtv/dbcheck.cpp).  
> You should check all your columns and tables for that version and beyond 
> to confirm that you have all the relevant updates. 

Also, if you shut down the backend, clear the log file, start the 
backend, and post (or link to) the whole log, it would be easier to see 
what's going/gone wrong with the database upgrade.

And, just in case, make sure you only have one version of MythTV on your 
system (i.e. make sure you're not accidentally running a backend out of 
/usr and a frontend out of /usr/local or something...

Mike


More information about the mythtv-users mailing list