Custom Query (13624 matches)

Query was: ALTER TABLE archiveitems DEFAULT CHARACTER SET default, MODIFY title varchar(128) CHARACTER SET utf8 default NULL, MODIFY subtitle varchar(128) CHARACTER SET utf8 default NULL, MODIFY description text CHARACTER SET utf8, MODIFY startdate varchar(30) CHARACTER SET utf8 default NULL, MODIFY starttime varchar(30) CHARACTER SET utf8 default NULL, MODIFY filename text CHARACTER SET utf8 NOT NULL, MODIFY cutlist text CHARACTER SET utf8;

Error was: Driver error was [2/1064]: QMYSQL: Unable to execute query Database error was: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'default, MODIFY title varchar(128) CHARACTER SET utf8 default NUL L, MODIFY sub' at line 1

Version info follows:

2020-06-20 11:22:51.119665 C mythfrontend version: fixes/31 [v31.0+fixes.202006181245.9442315~ubuntu20.04.1] www.mythtv.org

$ cat /etc/os-release
NAME="Ubuntu"
VERSION="20.04 LTS (Focal Fossa)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 20.04 LTS"
VERSION_ID="20.04"
HOME_URL="https://www.ubuntu.com/"
SUPPORT_URL="https://help.ubuntu.com/"
BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/"
PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy"
VERSION_CODENAME=focal
UBUNTU_CODENAME=focal

ken@myhhtv:~$ apt list | grep myth | grep installed

WARNING: apt does not have a stable CLI interface. Use with caution in scripts.

libmyth-python/focal,focal,now 2:31.0+fixes.202006181245.9442315~ubuntu20.04.1 all [installed,automatic]
libmyth/focal,now 2:31.0+fixes.202006181245.9442315~ubuntu20.04.1 amd64 [installed,automatic]
libmythes-1.2-0/focal,now 2:1.2.4-3build1 amd64 [installed,automatic]
libmythtv-perl/focal,focal,now 2:31.0+fixes.202006181245.9442315~ubuntu20.04.1 all [installed,automatic]
mytharchive/focal,now 2:31.0+fixes.202006181245.9442315~ubuntu20.04.1 amd64 [installed,automatic]
mythbrowser/focal,now 2:31.0+fixes.202006181245.9442315~ubuntu20.04.1 amd64 [installed,automatic]
mythes-en-us/focal,focal,now 1:6.4.3-1 all [installed]
mythexport/focal,now 2.2.4-0ubuntu6 amd64 [installed]
mythgame/focal,now 2:31.0+fixes.202006181245.9442315~ubuntu20.04.1 amd64 [installed,automatic]
mythimport/focal,now 2.2.4-0ubuntu6 amd64 [installed]
mythmusic/focal,now 2:31.0+fixes.202006181245.9442315~ubuntu20.04.1 amd64 [installed,automatic]
mythnews/focal,now 2:31.0+fixes.202006181245.9442315~ubuntu20.04.1 amd64 [installed,automatic]
mythplugins/focal,focal,now 2:31.0+fixes.202006181245.9442315~ubuntu20.04.1 all [installed]
mythtv-backend/focal,now 2:31.0+fixes.202006181245.9442315~ubuntu20.04.1 amd64 [installed,automatic]
mythtv-common/focal,now 2:31.0+fixes.202006181245.9442315~ubuntu20.04.1 amd64 [installed,automatic]
mythtv-database/focal,focal,now 2:31.0+fixes.202006181245.9442315~ubuntu20.04.1 all [installed,automatic]
mythtv-dbg/focal,now 2:31.0+fixes.202006181245.9442315~ubuntu20.04.1 amd64 [installed,automatic]
mythtv-frontend/focal,now 2:31.0+fixes.202006181245.9442315~ubuntu20.04.1 amd64 [installed,automatic]
mythtv-transcode-utils/focal,now 2:31.0+fixes.202006181245.9442315~ubuntu20.04.1 amd64 [installed,automatic]
mythtv/focal,focal,now 2:31.0+fixes.202006181245.9442315~ubuntu20.04.1 all [installed]
mythweather/focal,now 2:31.0+fixes.202006181245.9442315~ubuntu20.04.1 amd64 [installed,automatic]
mythweb/focal,focal,now 2:31.0+fixes.202006181245.9442315~ubuntu20.04.1 all [installed]
php-mythtv/focal,focal,now 2:31.0+fixes.202006181245.9442315~ubuntu20.04.1 all [installed,automatic]

Related to #13594. In the UK watching DVB-T2. Some recordings are transitioning between interlaced and progressive many times per recording, possibly because of commercials. The playback is a little bumpy and occasionally I see a single frame from many seconds ago that is out of sequence. Does the Nvidia hardware deinterlacer use old frames to construct the deinterlaced image? I can only guess that it does and that in switching from progressive to interlaced it uses a frame history that was stored the last time interlaced material passed through it.

When selecting "Rip CD" in mythmusic, on the track selection screen:

• if all tracks are selected, it works and rips fine
• if the first track isn't selected but the rest are, it fails with error "Failed to create encoder"

I've got a fix which resolves this issue for me (attached), but needs someone with experience of the codebase to confirm or come up with an alternative.