[easyvdr 5] epgd: SQL-Error in 'create table analyse

  • Hallo zusammen,

    habe nach langem easyvdr 5 installiert.

    Grundsystem läuft erst einmal aber ich bekomme nach Installation vom epgd o.g. Fehler im Syslog angezeigt.

    Hat jemand eine Idee?

    Grüße

    Wolle

  • Code
    1. Feb 12 17:30:41 vdr1 epgd: create table analyse(channelid VARCHAR(50), vdr_masterid INT(11) unsigned, vdr_eventid BIGINT(11) unsigned, vdr_starttime INT(10), vdr_duration INT(5), vdr_title VARCHAR(200), vdr_shorttext VARCHAR(300), ext_masterid INT(11) unsigned, ext_eventid BIGINT(11) unsigned, ext_starttime INT(10), ext_duration INT(5), ext_title VARCHAR(200), ext_shorttext VARCHAR(300), ext_episode VARCHAR(1), ext_merge INT(11), ext_images VARCHAR(1), lvmin INT(3), rank INT(5), PRIMARY KEY(channelid DESC, vdr_eventid DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;
    2. Feb 12 17:30:41 vdr1 epgd: SQL-Error in 'create table analyse(channelid VARCHAR(50), vdr_masterid INT(11) unsigned, vdr_eventid BIGINT(11) unsigned, vdr_starttime INT(10), vdr_duration INT(5), vdr_title VARCHAR(200), vdr_shorttext VARCHAR(300), ext_masterid INT(11) unsigned, ext_eventid BIGINT(11) unsigned, ext_starttime INT(10), ext_duration INT(5), ext_title VARCHAR(200), ext_shorttext VARCHAR(300), ext_episode VARCHAR(1), ext_merge INT(11), ext_images VARCHAR(1), lvmin INT(3), rank INT(5), PRIMARY KEY(channelid DESC, vdr_eventid DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;' - 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 INT(5), PRIMARY KEY(channelid DESC, vdr_eventid DESC)) ENGINE=InnoDB ROW_FO' at line 1 (1064)
    3. Feb 12 17:30:41 vdr1 epgd: SQL-Error in 'createTable()' - 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 INT(5), PRIMARY KEY(channelid DESC, vdr_eventid DESC)) ENGINE=InnoDB ROW_FO' at line 1 (1064) '' [create table analyse(channelid VARCHAR(50), vdr_masterid INT(11) unsigned, vdr_eventid BIGINT(11) unsigned, vdr_starttime INT(10), vdr_duration INT(5), vdr_title VARCHAR(200), vdr_shorttext VARCHAR(300), ext_masterid INT(11) unsigned, ext_eventid BIGINT(11) unsigned, ext_starttime INT(10), ext_duration INT(5), ext_title VARCHAR(200), ext_shorttext VARCHAR(300), ext_episode VARCHAR(1), ext_merge INT(11), ext_images VARCHAR(1), lvmin INT(3), rank INT(5), PRIMARY KEY(channelid DESC, vdr_eventid DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC;]

    wiederholt sich alle 20 Sekunden