[mythtv-users] DB 'offset' problem with MariaDB in ubuntu 22.04

Hika van den Hoven hikavdh at gmail.com
Wed Jan 24 23:21:50 UTC 2024


Hoi John,

Wednesday, January 24, 2024, 11:45:07 PM, you wrote:

> While updating to Master and 22.04 I installed MariaDB 10.6.12.  It 
> seems to work but my cutting scripts don't.   They read 'offset' values
> from the recordedseek table, and I understand that 'offset' is now an 
> SQL reserved word.

> Most of what I've read about MythTV and 10.6 has been about TimeZone 
> stuff, and the Recordedseek wiki still talks about offset.

> Perhaps fortunately the box hadn't made many recordings.

> Is there a simple fix?

> TIA

> John


Doesn't enclosing fieldnames in `` work? It's what phpMyAdmin does.




Tot mails,
  Hika                            mailto:hikavdh at gmail.com

"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"

De lerende Mens



More information about the mythtv-users mailing list