Arch Linux User Repository

This package now tracks the MythTV fixes/31 branch. There are quite a few upstream bugfixes since the v31 release.

Thanks to Taijian and all the previous maintainers for their efforts.

Whenever a commit is made by MythTV's git upstream you can rebuild this package without waiting for an update. Please don't flag it as out of date just because there's a new commit. Occasionally I'll push updates manually to stop the version from looking too old. I'll also push updates whenever a packaging change is needed for the build to work.

Important Note on AUR packages in general:

For AUR packages, you - as the user installing the package - assume the role that a package maintainer has for regular repo packages.

That means that the responsibility to recompile the package whenever a package B that your package depends on changes. For repo packages, maintainers do this for you and re-release the package with an updated build number (e.g. -1 to -2). AUR mainainers will not do this, because there is no change to the PKGBUILD. You need to recompile locally, whenever this happens.

Hi @ralfrupf1976,

I suspect that you haven't passed the correct flags to makepkg so that it installs dependencies before the build. You'll want to run something like makepkg -sri.

Please have a look at the usage guide on the wiki, or the manual for more info.

• https://wiki.archlinux.org/title/Makepkg
• https://man.archlinux.org/man/core/pacman/makepkg.8.en

Hope you can make it work :-)

Could not install mythtv because of error:

ERROR: samplerate not found using pkg-config

mark, same result here, but very few need the rebuild that i have checked. i can use the editor again. so anyone taking the mariadb upgrade will have to rebuild mythtv to get that offset keyword problem resolved.

Rebuilding seems to have worked, but I then needed to rebuild the seektable on the affected recordings...

mythcommflag --file 10615_20210817192500.ts --rebuild

the offset reserved word was the subject of a commit to fixes branch on july 31. see: https://github.com/MythTV/mythtv/commits/fixes/31/mythtv

i don't understand except maybe this portion of code in editor has been missed ?

I'm just rebuilding myself too... I've been grepping the source, and every instance of "offset" I've found so far is already escaped as " offset " so I'm feeling hopeful.

mark, so this looks like this is the reserved word thing mariadb 'offset'. i thought the fix was pushed to fixes. i will try a rebuild of mythtv and check again

I'm getting this in my mythfrontend.log:

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset FROM recordedseek WHERE chanid = ? AND starttime = ? AND type = ?' at line 1

2021-08-17 20:53:31.234651 E [3266/3266] CoreContext mythdb.cpp:181 (DBError) - DB Error (QueryPositionMap):
Query was:
SELECT mark, offset FROM recordedseek WHERE chanid = 10615 AND starttime = '2021-08-17T18:55:00Z' AND type = 9 ;

Seems like 'offset' has become a reserved word as of MariaDB 10.6

SELECT offset FROM recordedseek

gives the same error, where

SELECT "offset" FROM recordedseek

works...

thanks mark. i'll raise an issue on the mythtv-git when i get some time later on, maybe someone will have a look

I haven't done any further investigation as yet, I just responded because I also see the problem editing. For what it's worth, I don't use comm flagging, or kodi. I only do manual edits in mythfrontend.