[mythtv-users] dd_v_ tables missing from mythconverg

Michael T. Dean mtdean at thirdcontact.com
Tue Nov 13 01:16:36 UTC 2007


On 11/12/2007 09:14 AM, R. G. Newbury wrote:
> William Munson wrote:
>   
>> R. G. Newbury wrote:
>>     
>>> I think I have borked by mythconverg database and do not have an old 
>>> enough backup to reconstruct the prior state.
>>>
>>> SVN 14830 segfaulted at every attempt to play LiveTV or from the 
>>> library. I stepped back to 14794. But I think the error may have 
>>> predated that as I have listings for only 8 days. This is most likely 
>>> the result of a schema advance and revert...Operator error!
>>>
>>> DBSchemaVer is 1201. Mythfilldatabase reports that is cannot do inserts 
>>> to various "dd_v_xxx" tables. Those tables do not exist.
>>>
>>> So, how do I "re-update" and make it stick? As noted, 14830 segfaults badly.
>> I have not tried this myself but you should be able to change 
>> DBSchemaVer in the settings table to a lower number and rerun 
>> mythtv-setup to re-upgrade your database. With a reasonably current SVN 
>> I have a version of 1201.
>>     
>
> I tried something like this...I changed DBSchemaVer to 1200 in 
> mysql...

Generally not a good idea to mess with DBSchemaVer...  Always better to do

> but I cannot now be sure that I didn't just restart mythbackend 
> and frontend....I cannot remember.
> But whatever I did, changed DBSchemaVer to 1201 again, but DID NOT 
> create the missing tables....
>
> I will try it again, running mythtv-setup first.
>
> Anyone else have any good ideas? (I don't mind hearing *bad* ideas, but 
> I make no promises about using them!)

the MythTV "Spring Cleaning" (TM): 
http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7

Mike



More information about the mythtv-users mailing list