[mythtv-users] error during upgrade from V30 to V31

[Jim Abernathy]

On 3/29/20 11:12 PM, Bill Meek wrote:
> On 3/24/20 7:24 PM, Bill Meek wrote:
>> You're on Server version: 10.0.36-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04.
>>
>> My MariaDB tests are on Server version: 10.3.22-MariaDB-0ubuntu0.19.10.1 Ubuntu 19.10. 
>>
>>
>> https://mariadb.com/kb/en/create-user/#if-not-exists says IF NOT EXISTS is OK 
>>
>> for 10.3. Sounds like 10.0 doesn't support it.
>>
>> What happens if you do: CREATE USER 'blah'@'%'  IDENTIFIED WITH mysql_native_password; 
>>
>> and then do it again?
>>
>> DROP USER blah; will get rid of the new user.
>
> Give the attached a shot if you can, using sudo dpkg-reconfigure 
> mythtv-database
>
> It should live under: /var/lib/dpkg/info, rename the existing one
> mythtv-database.postinst.SAVED first.
>
> Thanks, 

Yes this works without any errors.  It pops up the window asking about 
other computers running mythtv. I answer yes and it returns to the 
prompt without further dialogue.

Thanks,

Jim A