Hallo zusammen,
habe meine Instanzen von epgd und epg2vdr auf den aktuellen GIT-Stand aktualisiert. Seitdem werden Timer nicht mehr angelegt.
Im Log beschwert sich epgd, dass die Tabelle "timer" keinen Default-Wert für die Spalte "id" hat (die Zeile mit "No timer of my uuid found" kommt vermutlich daher, dass ich die DB einmal geleert habe / epgd-tools dropall. Die SQL-Errors gab's davor aber genauso):
Code
May 24 18:48:17 HTPC vdr: epg2vdr: Updating table timers (and remove deleted and finished timers older than 2 days)
May 24 18:48:17 HTPC vdr: epg2vdr: No timer of my uuid found, assuming cleared table and ignoring the known timerids
May 24 18:48:17 HTPC vdr: epg2vdr: SQL-Error in 'execute(stmt_execute)' - Field 'id' doesn't have a default value (1364) 'Field 'id' doesn't have a default value' [insert into timers set _endtime = ?, _starttime = ?, action = ?, active = ?, autotimerid = ?, autotimerinssp = ?, autotimername = ?, aux = ?, channelid = ?, childlock = ?, day = ?, directory = ?, doneid = ?, endtime = ?, eventid = ?, evtstarttime = ?, expression = ?, file = ?, info = ?, inssp = ?, lifetime = ?, namingmode = ?, priority = ?, retrys = ?, source = ?, starttime = ?, state = ?, tccmailcnt = ?, template = ?, type = ?, updsp = ?, vdruuid = ?, vps = ?, weekdays = ?, wrncount = ?;]
May 24 18:48:17 HTPC vdr: epg2vdr: 'Insert' timer for event 4294967295 2944764 'The Flash' at database
May 24 18:48:17 HTPC vdr: epg2vdr: SQL-Error in 'execute(stmt_execute)' - Field 'id' doesn't have a default value (1364) 'Field 'id' doesn't have a default value' [insert into timers set _endtime = ?, _starttime = ?, action = ?, active = ?, autotimerid = ?, autotimerinssp = ?, autotimername = ?, aux = ?, channelid = ?, childlock = ?, day = ?, directory = ?, doneid = ?, endtime = ?, eventid = ?, evtstarttime = ?, expression = ?, file = ?, info = ?, inssp = ?, lifetime = ?, namingmode = ?, priority = ?, retrys = ?, source = ?, starttime = ?, state = ?, tccmailcnt = ?, template = ?, type = ?, updsp = ?, vdruuid = ?, vps = ?, weekdays = ?, wrncount = ?;]
May 24 18:48:17 HTPC vdr: epg2vdr: 'Insert' timer for event 4294967295 2936268 'Young Sheldon' at database
May 24 18:48:17 HTPC vdr: epg2vdr: SQL-Error in 'execute(stmt_execute)' - Field 'id' doesn't have a default value (1364) 'Field 'id' doesn't have a default value' [insert into timers set _endtime = ?, _starttime = ?, action = ?, active = ?, autotimerid = ?, autotimerinssp = ?, autotimername = ?, aux = ?, channelid = ?, childlock = ?, day = ?, directory = ?, doneid = ?, endtime = ?, eventid = ?, evtstarttime = ?, expression = ?, file = ?, info = ?, inssp = ?, lifetime = ?, namingmode = ?, priority = ?, retrys = ?, source = ?, starttime = ?, state = ?, tccmailcnt = ?, template = ?, type = ?, updsp = ?, vdruuid = ?, vps = ?, weekdays = ?, wrncount = ?;]
May 24 18:48:17 HTPC vdr: epg2vdr: 'Insert' timer for event 4294967295 2936269 'Young Sheldon' at database
May 24 18:48:17 HTPC vdr: epg2vdr: SQL-Error in 'execute(stmt_execute)' - Field 'id' doesn't have a default value (1364) 'Field 'id' doesn't have a default value' [insert into timers set _endtime = ?, _starttime = ?, action = ?, active = ?, autotimerid = ?, autotimerinssp = ?, autotimername = ?, aux = ?, channelid = ?, childlock = ?, day = ?, directory = ?, doneid = ?, endtime = ?, eventid = ?, evtstarttime = ?, expression = ?, file = ?, info = ?, inssp = ?, lifetime = ?, namingmode = ?, priority = ?, retrys = ?, source = ?, starttime = ?, state = ?, tccmailcnt = ?, template = ?, type = ?, updsp = ?, vdruuid = ?, vps = ?, weekdays = ?, wrncount = ?;]
May 24 18:48:17 HTPC vdr: epg2vdr: 'Insert' timer for event 4294967295 2936232 'Justice League' at database
May 24 18:48:17 HTPC vdr: epg2vdr: Updating table timers done
...
May 24 18:50:39 HTPC epgd: Info: The recording name calculated by 'recording.py' is 'The_Flash~06x08 - 122. Blutsbrüder'
May 24 18:50:39 HTPC epgd: SQL-Error in 'execute(stmt_execute)' - Field 'id' doesn't have a default value (1364) 'Field 'id' doesn't have a default value' [insert into timers set _endtime = ?, _starttime = ?, action = ?, active = ?, autotimerid = ?, autotimerinssp = ?, autotimername = ?, aux = ?, channelid = ?, childlock = ?, day = ?, directory = ?, doneid = ?, endtime = ?, eventid = ?, evtstarttime = ?, expression = ?, file = ?, info = ?, inssp = ?, lifetime = ?, namingmode = ?, priority = ?, retrys = ?, source = ?, starttime = ?, state = ?, tccmailcnt = ?, template = ?, type = ?, updsp = ?, vdruuid = ?, vps = ?, weekdays = ?, wrncount = ?;]Habe die timerID mal ins Logging mit aufgenommen, gibt also eine ID, aber wohl nicht da, wo sie erwartet wird!?
Code: timer.c
if (insert || timerDb->getChanges())
{
timerDb->setValue("ID", timerId); // set ID for update!!
timerDb->update(); // at least for aux (on insert case)
tell(1, "'%s' timer for event %u %u '%s' at database",
insert ? "Insert" : "Update",
timerId,
t->Event() ? t->Event()->EventID() : na,
t->Event() ? t->Event()->Title() : t->File());
}
else
{
tell(3, "Nothing changed ... skipping db update");
}Code
epgd git-version:
commit b00d26e01e57b3d438411ad57ec0b83506e0fd07 (HEAD -> master, tag: 1.1.159, origin/master, origin/HEAD)
Author: horchi <vdr@jwendel.de>
Date: Sat Feb 29 16:17:08 2020 +0100
2020-02-29: version 1.1.159 (horchi)\n - change: Don't set end of timer by webif\n\n
epg2vdr git-version:
commit cf00461436d5ae66322f49a54df09f7c26702835 (HEAD -> master, tag: 1.1.113, origin/master, origin/HEAD)
Author: horchi <vdr@jwendel.de>
Date: Mon Mar 23 07:35:54 2020 +0100
2020-03-23: version 1.1.113 (horchi)\n - change: Minor change of log message\n\nMySQL ist in dieser Version installiert: 8.0.20-0ubuntu0.19.10.1 - (Ubuntu)
Hat jemand eine Idee?
Viele Grüße,
Chriss
