Could not install mythtv because of error:
ERROR: samplerate not found using pkg-config
Git Clone URL: | https://aur.archlinux.org/mythtv-git.git (read-only, click to copy) |
---|---|
Package Base: | mythtv-git |
Description: | A Homebrew PVR project (Stable '-fixes' branch) |
Upstream URL: | https://www.mythtv.org/ |
Licenses: | GPL |
Conflicts: | mythtv |
Provides: | mythtv |
Submitter: | JohnLBergqvist |
Maintainer: | JohnLBergqvist |
Last Packager: | JohnLBergqvist |
Votes: | 36 |
Popularity: | 0.000072 |
First Submitted: | 2023-04-10 09:11 (UTC) |
Last Updated: | 2025-03-02 11:54 (UTC) |
« First ‹ Previous 1 .. 8 9 10 11 12 13 14 15 16 17 18 .. 32 Next › Last »
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.
the thing is the seektable is there as are commercial skips. you can still go forward and back and when i look in kodi pvr i could see the skips, i had just lost the ability edit them. i assume same with mark.clegg
Pinned Comments
JohnLBergqvist commented on 2023-04-10 15:56 (UTC) (edited on 2023-04-10 15:57 (UTC) by JohnLBergqvist)
This package replaces the previous 'mythtv' AUR package. It has been renamed to comply with Arch's VCS package guidelines.
I hope to update the various mythplugins AUR packages soon