[mythtv-users] mysql query failing after upgrade to 5.5

Nicolas Krzywinski myth at site7even.de
Fri Aug 15 20:30:59 UTC 2014


Am 15.08.2014, 10:27 Uhr, schrieb <mythtv-users-request at mythtv.org>:

> Originally I wanted to write this as a power query to
> automatically re-record movies on comm free channels as they aired, but the
> power queries are not actually that powerful--mythweb stripped out some key
> punctuation, and the frontend made me discover that the query length is
> limited to 128 characters or something and I was just over that.
You may solve this with creating a sql view in the mysql database that contains the major (or whole) part of your sql query logic.
This would allow you to call your extraction logic with a short "select * from mythconverg.viewname" sql query string.

Good luck,
Nicolas

-- 
www.nskcomputing.de


More information about the mythtv-users mailing list