V32 Mytharchive installed but no entry in menus

Have a MythTV related problem? Ask for help from other MythTV users here.

Moderator: Forum Moderators

Post Reply
vidtek
Junior
Posts: 16
Joined: Wed Aug 05, 2015 4:47 pm
Great Britain

V32 Mytharchive installed but no entry in menus

Post by vidtek » Mon Jan 11, 2021 1:56 pm

As the title says, I have moved from 31 to 32 to see if mytharchive and mythmusic will work, but no joy. This is a completely new install of Ubuntu Studio (Greedy) using 5.8.0-36-lowlatency kernel and mythtv is working well apart from the same issue for which I re-installed.
Not so bothered about music but there is no really viable option other than mytharchive for importing old recordings into myth.
I did a quick search on Google and this forum but no-one else seems to have reported it.

Cheers Tony.
Myth.32 Krnl5.8.0-38 Plsma5.19.5ubntu 20.04Intel i7-7700K GTX 960 nvdia TBS QuadTuner 6205

User avatar
paulh
Developer
Posts: 585
Joined: Thu Feb 06, 2014 6:09 pm
Great Britain

Re: V32 Mytharchive installed but no entry in menus

Post by paulh » Tue Jan 12, 2021 9:22 pm

The menu entries for the various plugins only show up if the relevant plugin is installed and has been compiled with the same library version.

Do you see anything in the frontend log when starting up about incompatible library versions?

Are the plugins installed to /usr/lib/mythtv/plugins/ ?

vidtek
Junior
Posts: 16
Joined: Wed Aug 05, 2015 4:47 pm
Great Britain

Re: V32 Mytharchive installed but no entry in menus

Post by vidtek » Wed Jan 13, 2021 9:29 am

Paulh- Many thanks for your response- The only entry in /lib/mythtv/plugins is a single file with the filename "libmytharchive.so" This leads me to conclude it has compiled properly-am I correct?
Please see below this short extract from mythfrontend log. I have highlighted the entry which shows it doesn't work.
Thanks again, Tony.
Jan 12 19:07:35 linuxmint mythfrontend.real: mythfrontend[7577]: I CoreContext mythvideoprofile.cpp:1364 (InitStatics) VideoProfile: Decoder/render support: nvdec opengl-hw
Jan 12 19:07:35 linuxmint mythfrontend.real: mythfrontend[7577]: I CoreContext mythvideoprofile.cpp:1364 (InitStatics) VideoProfile: Decoder/render support: nvdec-dec null opengl opengl-yv12
Jan 12 19:07:35 linuxmint mythfrontend.real: mythfrontend[7577]: E CoreContext AirPlay/mythraopdevice.cpp:31 (Create) RAOP Device: Aborting startup - no key found.
Jan 12 19:07:35 linuxmint mythfrontend.real: mythfrontend[7577]: I CoreContext AirPlay/mythairplayserver.cpp:386 (Create) AirPlay: Created airplay objects.
Jan 12 19:07:35 linuxmint mythfrontend.real: mythfrontend[7577]: I thread_unknown serverpool.cpp:414 (listen) Listening on TCP 0.0.0.0:5100
Jan 12 19:07:35 linuxmint mythfrontend.real: mythfrontend[7577]: I thread_unknown serverpool.cpp:414 (listen) Listening on TCP [::]:5100
Jan 12 19:07:35 linuxmint mythfrontend.real: mythfrontend[7577]: I CoreContext schemawizard.cpp:117 (Compare) Current MythTV Schema Version (DBSchemaVer): 1367
Jan 12 19:07:35 linuxmint mythfrontend.real: mythfrontend[7577]: N CoreContext mythmainwindow.cpp:1470 (RegisterMediaPlugin) Registering Internal as a media playback plugin.
Jan 12 19:07:35 linuxmint mythfrontend.real: mythfrontend[7577]: N CoreContext mediamonitor-unix.cpp:122 (MediaMonitorUnix) MediaMonitor disabled by user setting.
Jan 12 19:07:35 linuxmint mythfrontend.real: mythfrontend[7577]: C CoreContext dbcheckcommon.cpp:119 (performActualUpdate) Upgrading to MythArchive schema version 1003
Jan 12 19:07:35 linuxmint mythfrontend.real: mythfrontend[7577]: E CoreContext dbcheckcommon.cpp:95 (performUpdateSeries) DB Error (Performing MythArchive database upgrade): #012Query was: ALTER TABLE archiveitems DEFAULT CHARACTER SET default, MODIFY title varchar(128) CHARACTER SET utf8 default NULL, MODIFY subtitle varchar(128) CHARACTER SET utf8 default NULL, MODIFY description text CHARACTER SET utf8, MODIFY startdate varchar(30) CHARACTER SET utf8 default NULL, MODIFY starttime varchar(30) CHARACTER SET utf8 default NULL, MODIFY filename text CHARACTER SET utf8 NOT NULL, MODIFY cutlist text CHARACTER SET utf8; #012Error was: Driver error was [2/1064]:#012QMYSQL: Unable to execute query#012Database error was:#012You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'default, MODIFY title varchar(128) CHARACTER SET utf8 default NULL, MODIFY sub' at line 1
Jan 12 19:07:35 linuxmint mythfrontend.real: mythfrontend[7577]: E CoreContext main.cpp:352 (mythplugin_init) Couldn't upgrade database to new schema, exiting.
Jan 12 19:07:35 linuxmint mythfrontend.real: mythfrontend[7577]: E CoreContext mythplugin.cpp:140 (init_plugin) Unable to initialize plugin 'mytharchive'.
Jan 12 19:07:35 linuxmint mythfrontend.real: mythfrontend[7577]: N CoreContext main.cpp:1217 (RunMenu) Found mainmenu.xml for theme 'MythCenter-wide'
Jan 12 19:07:35 linuxmint mythfrontend.real: mythfrontend[7577]: I CoreContext themechooser.cpp:1045 (ThemeUpdateChecker) Checking for theme updates every hour
Jan 12 19:07:35 linuxmint mythfrontend.real: mythfrontend[7577]: I CoreContext housekeeper.cpp:651 (RegisterTask) Registering HouseKeeperTask 'HardwareProfiler'.
Jan 12 19:07:35 linuxmint mythfrontend.real: mythfrontend[7577]: I CoreContext housekeeper.cpp:724 (Start) Starting HouseKeeper.
Jan 12 19:07:35 linuxmint mythfrontend.real: mythfrontend[7577]: I CoreContext bonjourregister.cpp:116 (BonjourCallback) Bonjour: Service registration complete: name 'Mythfrontend on linuxmint' type '_mythfrontend._tcp.' domain: 'local.'
Jan 12 19:07:35 linuxmint mythfrontend.real: mythfrontend[7577]: I AirplayServer bonjourregister.cpp:116 (BonjourCallback) Bonjour: Service registration complete: name 'MythTV on linuxmint' type '_airplay._tcp.' domain: 'local.'
Jan 12 19:07:44 linuxmint mythfrontend.real: mythfrontend[7577]: I ImageLoad mythcommandlineparser.cpp:2645 (operator()) Qt: libpng warning: iCCP: known incorrect sRGB profile
Jan 12 19:07:44 linuxmint mythfrontend.real: mythfrontend[7577]: I ImageLoad mythcommandlineparser.cpp:2645 (operator()) Qt: libpng warning: iCCP: known incorrect sRGB profile
Jan 12 19:07:47 linuxmint mythfrontend.real: mythfrontend[7577]: I CoreContext tv_play.cpp:1043 (TV) TV::TV(): Creating TV object
Jan 12 19:07:47 linuxmint mythfrontend.real: mythfrontend[7577]: I CoreContext tv_play.cpp:1222 (Init) TV::Init(): Created TvPlayWindow.
Myth.32 Krnl5.8.0-38 Plsma5.19.5ubntu 20.04Intel i7-7700K GTX 960 nvdia TBS QuadTuner 6205

User avatar
paulh
Developer
Posts: 585
Joined: Thu Feb 06, 2014 6:09 pm
Great Britain

Re: V32 Mytharchive installed but no entry in menus

Post by paulh » Wed Jan 13, 2021 10:46 pm

The database is failing to upgrade so the plugin is refusing to load. Since there hasn't been any updates to the MythArchive DB schema in over a decade it must be some incompatibility with whatever MySql or MariaDB you are using.

Which are you using and what version is it.

The missing MythMusic is because it must not be installed otherwise you would also have "libmythmusic.so" in /lib/mythtv/plugins. Unbuntu puts the individual plugins in separate packages so you would have to install the mythmusic package.

User avatar
heyted
Senior
Posts: 176
Joined: Sun Jun 08, 2014 2:14 am
Location: South Florida
Contact:
United States of America

Re: V32 Mytharchive installed but no entry in menus

Post by heyted » Wed Jan 13, 2021 11:52 pm

Mytharchive is working fine for me with v31 on Ubuntu 20.04 with MythTV and Mytharchive installed using MCP.
Ted | My blog

vidtek
Junior
Posts: 16
Joined: Wed Aug 05, 2015 4:47 pm
Great Britain

Re: V32 Mytharchive installed but no entry in menus

Post by vidtek » Thu Jan 14, 2021 8:20 am

Paulh- Thanks again- I didn't try installing mythmusic on this new install as I had so many failed attempts before, it is not that important to me anyway. Mytharchive is a different matter, I really want that to work.
This is the mysql version:

Code: Select all

tony@linuxmint:~$ mysql --version
mysql  Ver 8.0.22-0ubuntu0.20.10.2 for Linux on x86_64 ((Ubuntu))
tony@linuxmint:~$ 
cheers Tony.
Myth.32 Krnl5.8.0-38 Plsma5.19.5ubntu 20.04Intel i7-7700K GTX 960 nvdia TBS QuadTuner 6205

User avatar
paulh
Developer
Posts: 585
Joined: Thu Feb 06, 2014 6:09 pm
Great Britain

Re: V32 Mytharchive installed but no entry in menus

Post by paulh » Thu Jan 14, 2021 10:47 pm

From what I can gather from other devs newer versions of MySQL and possibly MariaDB require a slightly different syntax for some of the SQL commands to update the various table schemas. It looks like bill6502 is working on a fix so I'll leave it up to him.

vidtek
Junior
Posts: 16
Joined: Wed Aug 05, 2015 4:47 pm
Great Britain

Re: V32 Mytharchive installed but no entry in menus

Post by vidtek » Fri Jan 15, 2021 8:10 am

PaulH- I know there is a requirement for totally different syntax when updating the password-it has actually been simplified-great work by the devs.
The work that Bill6502 and others are doing-will it be a sort of automatic thing? Or how will we know about a possible fix?
If I can help with testing etc. please let me know.

Cheers Tony.
Myth.32 Krnl5.8.0-38 Plsma5.19.5ubntu 20.04Intel i7-7700K GTX 960 nvdia TBS QuadTuner 6205

User avatar
paulh
Developer
Posts: 585
Joined: Thu Feb 06, 2014 6:09 pm
Great Britain

Re: V32 Mytharchive installed but no entry in menus

Post by paulh » Sat Jan 16, 2021 5:55 pm

You will just have to update MythTV and it will just work. The same problem affects database updates to other plugins and also some core DB updates are affected as well.

vidtek
Junior
Posts: 16
Joined: Wed Aug 05, 2015 4:47 pm
Great Britain

Re: V32 Mytharchive installed but no entry in menus

Post by vidtek » Sat Jan 16, 2021 6:44 pm

OK thanks, I'll keep my eyes peeled for it.
Myth.32 Krnl5.8.0-38 Plsma5.19.5ubntu 20.04Intel i7-7700K GTX 960 nvdia TBS QuadTuner 6205

Post Reply