id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc	mlocked
13637	SQL error in database upgrade	kensheldon		"


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]
}}}"	Bug Report - General	closed	minor	unknown	MythTV - General	v31-fixes	medium	Duplicate			0