Code
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;
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)
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