<html><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On 25 Apr 2022, at 12:56 pm, Stephen Worthington <<a href="mailto:stephen_agent@jsw.gen.nz" class="">stephen_agent@jsw.gen.nz</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><meta charset="UTF-8" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 24px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">On Mon, 25 Apr 2022 10:14:32 +0800, you wrote:</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 24px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 24px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><blockquote type="cite" style="font-family: Helvetica; font-size: 24px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><br class=""><br class=""><blockquote type="cite" class="">On 25 Apr 2022, at 7:37 am, James <<a href="mailto:jam@tigger.ws" class="">jam@tigger.ws</a>> wrote:<br class=""><br class="">Hi<br class="">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:<br class=""><br class="">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<br class=""><br class="">Looking at SQL indeed it does not exist (but does in 31 DB)<br class="">Since 'music_songs' is pretty ubiquitous I speculate an update went wrong (I started with a newly created DB)<br class="">What gives ?<br class=""></blockquote><br class="">I did the obvious - grabbed an empty music_songs from 31/fixes - all works.<br class=""><br class="">James<br class=""></blockquote><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 24px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 24px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">All my v32 databases have a music_songs table. On the system that I</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 24px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 24px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">play music on, it is full of data.</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 24px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""></div></blockquote><div><br class=""></div>Rather confused, not of great angst, it does work.</div><div>I built. from git</div><div><br class=""></div><div><div>commit daa4e7e4474c019714d21674ee7e18f3bc89624d (HEAD -> fixes/32, origin/fixes/32)</div><div>Author: Klaas de Waal <<a href="mailto:klaas@kldo.nl" class="">klaas@kldo.nl</a>></div><div>Date: Fri Apr 22 21:04:59 2022 +0200</div><div><br class=""></div><div>made an empty database</div><div><br class=""></div><div><div>CREATE DATABASE IF NOT EXISTS mythconverg;</div><div><br class=""></div><div>CREATE USER IF NOT EXISTS 'mythtv'@'localhost' IDENTIFIED WITH mysql_native_password;</div><div>ALTER USER 'mythtv'@'localhost' IDENTIFIED BY 'mythtv';</div><div>GRANT ALL ON mythconverg.* TO mythtv@localhost;</div><div>FLUSH PRIVILEGES;</div><div>GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv@localhost;</div><div>FLUSH PRIVILEGES;</div><div><br class=""></div><div>CREATE USER IF NOT EXISTS 'mythtv'@'192.168.5.%' IDENTIFIED WITH mysql_native_password;</div><div>ALTER USER 'mythtv'@'192.168.5.%' IDENTIFIED BY 'mythtv';</div><div>GRANT ALL ON mythconverg.* TO mythtv@'192.168.5.%';</div><div>FLUSH PRIVILEGES;</div><div>GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv@'192.168.5.%';</div><div>FLUSH PRIVILEGES;</div><div><br class=""></div><div>ALTER DATABASE mythconverg DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;</div><div><br class=""></div><div>mythtv-setup and allowed the DB upgrade</div><div><br class=""></div><div><div>mysql> show tables;</div><div>+---------------------------+</div><div>| Tables_in_mythconverg |</div><div>+---------------------------+</div><div>| bdbookmark |</div><div>| capturecard |</div><div>| cardinput |</div><div>| channel |</div><div>| channelgroup |</div><div>| channelgroupnames |</div><div>| channelscan |</div><div>| channelscan_channel |</div><div>| channelscan_dtv_multiplex |</div><div>| codecparams |</div><div>| credits |</div><div>| customexample |</div><div>| diseqc_config |</div><div>| diseqc_tree |</div><div>| displayprofilegroups |</div><div>| displayprofiles |</div><div>| dtv_multiplex |</div><div>| dtv_privatetypes |</div><div>| dvdbookmark |</div><div>| dvdinput |</div><div>| dvdtranscode |</div><div>| eit_cache |</div><div>| filemarkup |</div><div>| gallery_directories |</div><div>| gallery_files |</div><div>| housekeeping |</div><div>| inputgroup |</div><div>| internetcontent |</div><div>| internetcontentarticles |</div><div>| inuseprograms |</div><div>| iptv_channel |</div><div>| jobqueue |</div><div>| jumppoints |</div><div>| keybindings |</div><div>| keyword |</div><div>| livestream |</div><div>| logging |</div><div>| mythlog |</div><div>| mythweb_sessions |</div><div>| oldfind |</div></div><div><br class=""></div><div>And there it is gone!</div><div><br class=""></div><div>??</div><div>James</div></div></div><br class=""></body></html>