Mailing List Archive

#13637: SQL error in database upgrade
----------------------------------+------------------------------
Reporter: kensheldon | Owner: (none)
Type: Bug Report - General | Status: new
Priority: major | Milestone: needs_triage
Component: MythTV - General | Version: v31-fixes
Severity: medium | Resolution:
Keywords: | Ticket locked: 0
----------------------------------+------------------------------
Changes (by kensheldon):

* Attachment "mythfrontend.log" added.

Log file from mythfrontend

--
Ticket URL: <https://code.mythtv.org/trac/ticket/13637>
MythTV <http://www.mythtv.org>
MythTV Media Center

#13637: SQL error in database upgrade
----------------------------------+------------------------------
Reporter: kensheldon | Owner: (none)
Type: Bug Report - General | Status: new
Priority: major | Milestone: needs_triage
Component: MythTV - General | Version: v31-fixes
Severity: medium | Resolution:
Keywords: | Ticket locked: 0
----------------------------------+------------------------------

Comment (by kensheldon):

MySQL version is

Server version: 8.0.20-0ubuntu0.20.04.1 (Ubuntu)

--
Ticket URL: <https://code.mythtv.org/trac/ticket/13637#comment:1>
MythTV <http://www.mythtv.org>
MythTV Media Center

#13637: SQL error in database upgrade
----------------------------------+---------------------------
Reporter: kensheldon | Owner: (none)
Type: Bug Report - General | Status: closed
Priority: minor | Milestone: unknown
Component: MythTV - General | Version: v31-fixes
Severity: medium | Resolution: Duplicate
Keywords: | Ticket locked: 0
----------------------------------+---------------------------
Changes (by Bill Meek):

* priority: major => minor
* status: new => closed
* resolution: => Duplicate
* milestone: needs_triage => unknown


Old description:

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

New description:

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]
}}}

--

Comment:

Thanks, but this is a duplicate of #13577

--
Ticket URL: <https://code.mythtv.org/trac/ticket/13637#comment:2>
MythTV <http://www.mythtv.org>
MythTV Media Center