[mythtv-users] Unable to upgrade DB

[Michael T. Dean]

<fixed top posting, again>

On 03/27/2010 01:25 PM, Oz Dror wrote:
> On Sat, Mar 27, 2010 at 8:51 AM, Michael T. Dean wrote:
>    
>>   On 03/27/2010 11:02 AM, Oz Dror wrote:
>>      
>>>> On 3/27/2010 03:13, Oz wrote:
>>>>          
>>>>> 2010-03-26 23:09:20.551 Protocol version mismatch
>>>>> (frontend=56,backend=50)
>>>>>            
>>>> That has nothing to do with the database. You have a 0.23rc
>>>> frontend trying to connect to a 0.22 backend. You cannot do that.
>>>> All machines connected to that backend must be running the same
>>>> version of mythtv.
>>>>          
>>> It is a new install the frontend and the backend are 0.23rc
>>>
>>> only the DB is 0.22. Using mythtv-setup does not fix it. It just
>>> freezes after backing up the old DB
>>>        
>> No, you /are/ running a MythTV 0.23rc1 or 0.23-fixes frontend against a
>> MythTV 0.22-fixes backend.
>>
>> You may have installed MythTV 0.23rc1 or 0.23-fixes mythbackend, but it's
>> not what's currently running.
>>
>> I highly recommend a reboot.  If that doesn't fix it, then you likely have
>> 2 versions of MythTV installed (i.e. one in /usr, installed by packages, and
>> one in /usr/local, installed from source).
> I fixed the problem by editing  the data base using mysql-query-browser
>
> I removed old system in the setting record.
>    

Actually, you probably just broke your system.

I have no idea what you edited--since the protocol version is /not/ 
stored in the database.  But, if you edited the database schema version 
(which is completely unrelated to the error you got), you did break your 
system.

Mike