[mythtv-users] database on 32/fixes

[Stephen Worthington]

On Mon, 25 Apr 2022 13:32:52 +0800, you wrote:

>
>
>> On 25 Apr 2022, at 12:56 pm, Stephen Worthington <stephen_agent at jsw.gen.nz> wrote:
>> 
>> On Mon, 25 Apr 2022 10:14:32 +0800, you wrote:
>> 
>>> 
>>> 
>>>> On 25 Apr 2022, at 7:37 am, James <jam at tigger.ws> wrote:
>>>> 
>>>> Hi
>>>> I built 31/fixes on ubuntu 22.04. Everything is OK. On whim I built 32/fixes the myth part works fine but mythweb gives me this:
>>>> 
>>>> Fatal error: Uncaught mysqli_sql_exception: Table 'mythconverg.music_songs' doesn't exist in /var/www/html/mythweb/classes/Database/Query/mysqlicompat.php:68 Stack trace: #0 /var/www/html/mythweb/classes/Database/Query/mysqlicompat.php(68): mysqli_query() #1 /var/www/html/mythweb/classes/Database.php(263): Database_Query_mysqlicompat->execute() #2 /var/www/html/mythweb/classes/Database.php(326): Database->query() #3 /var/www/html/mythweb/modules/music/init.php(15): Database->query_col() #4 /var/www/html/mythweb/classes/Modules.php(30): require_once('...') #5 /var/www/html/lmythweb/classes/Modules.php(50): Modules::load() #6 /var/www/html/mythweb/mythweb.php(30): Modules::getModule() #7 {main} thrown in /var/www/html/mythweb/classes/Database/Query/mysqlicompat.php on line 68
>>>> 
>>>> Looking at SQL indeed it does not exist (but does in 31 DB)
>>>> Since 'music_songs' is pretty ubiquitous I speculate an update went wrong (I started with a newly created DB)
>>>> What gives ?
>>> 
>>> I did the obvious - grabbed an empty music_songs from 31/fixes - all works.
>>> 
>>> James
>> 
>> All my v32 databases have a music_songs table.  On the system that I
>> play music on, it is full of data.
>
>Rather confused, not of great angst, it does work.
>I built. from git
>
>commit daa4e7e4474c019714d21674ee7e18f3bc89624d (HEAD -> fixes/32, origin/fixes/32)
>Author: Klaas de Waal <klaas at kldo.nl>
>Date:   Fri Apr 22 21:04:59 2022 +0200
>
>made an empty database
>
>CREATE DATABASE IF NOT EXISTS mythconverg;
>
>CREATE USER IF NOT EXISTS 'mythtv'@'localhost' IDENTIFIED WITH mysql_native_password;
>ALTER USER 'mythtv'@'localhost' IDENTIFIED BY 'mythtv';
>GRANT ALL ON mythconverg.* TO mythtv at localhost;
>FLUSH PRIVILEGES;
>GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv at localhost;
>FLUSH PRIVILEGES;
>
>CREATE USER IF NOT EXISTS 'mythtv'@'192.168.5.%' IDENTIFIED WITH mysql_native_password;
>ALTER USER 'mythtv'@'192.168.5.%' IDENTIFIED BY 'mythtv';
>GRANT ALL ON mythconverg.* TO mythtv@'192.168.5.%';
>FLUSH PRIVILEGES;
>GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv@'192.168.5.%';
>FLUSH PRIVILEGES;
>
>ALTER DATABASE mythconverg DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
>
>mythtv-setup and allowed the DB upgrade
>
>mysql> show tables;
>+---------------------------+
>| Tables_in_mythconverg     |
>+---------------------------+
>| bdbookmark                |
>| capturecard               |
>| cardinput                 |
>| channel                   |
>| channelgroup              |
>| channelgroupnames         |
>| channelscan               |
>| channelscan_channel       |
>| channelscan_dtv_multiplex |
>| codecparams               |
>| credits                   |
>| customexample             |
>| diseqc_config             |
>| diseqc_tree               |
>| displayprofilegroups      |
>| displayprofiles           |
>| dtv_multiplex             |
>| dtv_privatetypes          |
>| dvdbookmark               |
>| dvdinput                  |
>| dvdtranscode              |
>| eit_cache                 |
>| filemarkup                |
>| gallery_directories       |
>| gallery_files             |
>| housekeeping              |
>| inputgroup                |
>| internetcontent           |
>| internetcontentarticles   |
>| inuseprograms             |
>| iptv_channel              |
>| jobqueue                  |
>| jumppoints                |
>| keybindings               |
>| keyword                   |
>| livestream                |
>| logging                   |
>| mythlog                   |
>| mythweb_sessions          |
>| oldfind                   |
>
>And there it is gone!
>
>??
>James

The tables for the mythmusic plugin are not created in an empty
database.  You have to install the frontend only mythmusic plugin and
then run mythfrontend.  On the first run of the mythmusic plugin, it
will create the music tables, or upgrade them to the latest schema if
they already exist.