[mythtv-users] database on 32/fixes

[James]

> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20220425/5bb935de/attachment.htm>