Opened 5 years ago
Closed 5 years ago
#13637 closed Bug Report - General (Duplicate)
SQL error in database upgrade
| Reported by: | kensheldon | Owned by: | |
|---|---|---|---|
| Priority: | minor | Milestone: | unknown |
| Component: | MythTV - General | Version: | v31-fixes |
| Severity: | medium | Keywords: | |
| Cc: | Ticket locked: | no |
Description (last modified by )
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]
Log file from mythfrontend