Project

General

Profile

Actions

Bug #2595

open

Upgrade to mysql 8.0 requires change in mergeepg.sql

Added by Anonymous almost 5 years ago.

Status:
New
Priority:
Urgent
Assignee:
-
Start date:
12/27/2019
Due date:
% Done:

0%

Estimated time:

Description

Hi there,

the word "rank" got a reserved keyword in MySQL 8. Thus, an upgrade of a DB containing an instance of epg2vdr to MySQL V8.0 fails due to the usage of the word "rank" unquoted.
See line 124, corrected:
---------------------
SELECT channelid, vdr_masterid, vdr_eventid, vdr_starttime, vdr_duration, vdr_title, vdr_shorttext, ext_masterid, ext_eventid, ext_starttime, ext_duration, ext_title, ext_shorttext, ext_episodecompname, ext_merge, ext_images, lvmin,
epi+img+sht + ranklv as `rank`
FROM
---------------------

and line 163, corrected:
---------------------
order by channelid,vdr_eventid,`rank`;
---------------------

Otherwise, the following error message will be prompted in the error.log of mysql during the upgrade sequence:
---------------------
2019-12-27T16:55:46.692561Z 2 [ERROR] [MY-013235] [Server] Error in parsing Routine 'epg2vdr'.'mergeepg' during upgrade. 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 'rank
FROM
(
  SELECT  channelid, vdr_masterid, vdr_eventid, vdr_starttime, vdr_d' at line 126
2019-12-27T16:55:48.924088Z 0 [ERROR] [MY-010022] [Server] Failed to Populate DD tables.
---------------------

Thanks and cheers,
Chriss

No data to display

Actions

Also available in: Atom PDF