[mythtv-users] database on 32/fixes

[James Linder]

> 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