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...
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