Nach einem Dist-Upgrade am Wochenende habe ich zwei User in der DB epg2vdr:
root@yavdr6:~# epgd-tool -show
+---------+-----------+---------+
| User | Host | Db |
+---------+-----------+---------+
| epg2vdr | % | epg2vdr |
| epg2vdr | localhost | epg2vdr |
+---------+-----------+---------+
+------------------------------------------------------+
| Grants for epg2vdr@% |
+------------------------------------------------------+
| GRANT USAGE ON *.* TO 'epg2vdr'@'%' |
| GRANT ALL PRIVILEGES ON `epg2vdr`.* TO 'epg2vdr'@'%' |
+------------------------------------------------------+
+--------------------+
| Database |
+--------------------+
| information_schema |
| epg2vdr |
| mysql |
| performance_schema |
+--------------------+
+-------------------+
| Tables_in_epg2vdr |
+-------------------+
| analyse |
| channelmap |
| components |
| episodes |
| events |
| eventsview |
| eventsviewplain |
| fileref |
| imagerefs |
| images |
| messages |
| movie |
| movie_actor |
| movie_actors |
| movie_media |
| parameters |
| recordingdirs |
| recordinglist |
| recordings |
| searchtimers |
| series |
| series_actor |
| series_episode |
| series_media |
| snapshot |
| thetvdbview |
| timers |
| timersdone |
| useevents |
| users |
| vdrs |
+-------------------+
Welchen davon sollte ich löschen?
Zudem meldet das Log ein fehlendes Feld 'id'. Was ist da los?
Mar 6 16:41:13 yavdr6 vdr: epg2vdr: SQL-Error in 'prepare(stmt_prepare)' - Unknown column 'id' in 'field list' (1054) 'Unknown column 'id' in 'field list'' [select _starttime, action, active, autotimerid, autotimerinssp, autotimername, aux, channelid, childlock, day, directory, doneid, endtime, eventid, expression, file, id, info, inssp, lifetime, namingmode, priority, retrys, source, starttime, state, tccmailcnt, template, type, updsp, vdruuid, vps, weekdays from timers where id = ? and vdruuid = ?;]
Mar 6 16:41:13 yavdr6 vdr: epg2vdr: Retry #313 failed, retrying in 60 seconds!
Mar 6 16:41:13 yavdr6 vdr: epg2vdr: Closing mysql connection and calling mysql_thread_end(2501)
Mar 6 16:42:13 yavdr6 vdr: epg2vdr: Trying to re-connect to database!