(Solved) Missing table in Mythtv 32 errors out mythweb

For discussion related to MythTV which doesn't belong in another forum.

Moderator: Forum Moderators

Post Reply
yawlhoo
Senior
Posts: 120
Joined: Wed Apr 15, 2015 4:18 pm
United States of America

(Solved) Missing table in Mythtv 32 errors out mythweb

Post by yawlhoo »

My working mythtv setup had a bad problem that completely messed it up. In trying to recover my system, re-installing packages and so forth, currently when I try to use mythweb it fails with:

Fatal error: Uncaught mysqli_sql_exception: Table 'mythconverg.music_songs' doesn't exist in /usr/share/mythtv/mythweb/classes/Database/Query/mysqlicompat.php:68

I searched for this error and found that several others were experiencing this problem. One person described successfully fixing this by grabbing an empty music_songs table from somewhere, but he didn't fully describe how he did it.

Does anyone have an idea how to overcome this?
User avatar
paulh
Developer
Posts: 909
Joined: Thu Feb 06, 2014 6:09 pm
Great Britain

Re: Missing table in Mythtv 32 errors out mythweb

Post by paulh »

This was fixed back in June in master and backported in July in fixes/32 so you probably just need to update MythWeb.

It's caused by a change in behaviour in PHP 8.1
https://github.com/MythTV/mythweb/issues/83
https://github.com/MythTV/mythweb/commit/92f0f9b
yawlhoo
Senior
Posts: 120
Joined: Wed Apr 15, 2015 4:18 pm
United States of America

(Solved)Re: Missing table in Mythtv 32 errors out mythweb

Post by yawlhoo »

One of the first things I did was update the mythweb package, but that didn't fix it, I guess the changes haven't yet been packaged.

So I just manually edited the php code as per the github listing, and that did solve the problem. Thanks.
Post Reply