htpc2 epgd # journalctl -f | grep epgd
Mar 12 18:30:58 htpc2 epgd[28082]: Set locale to 'en_US.UTF-8'
Mar 12 18:30:58 htpc2 epgd[28082]: Loading uuid from '/etc/epgd/uuid' succeeded [10DE58CD-69A0-4506-B624-364D06D38C50]
Mar 12 18:30:58 htpc2 epgd[28082]: Dictionary '/etc/epgd/epg.dat' loaded
Mar 12 18:30:58 htpc2 epgd[28082]: Initialize python script '/etc/epgd/recording.py'
Mar 12 18:30:58 htpc2 epgd[28082]: Loading plugin: /usr/lib/epgd/plugins/libepgd-tvm.so
Mar 12 18:30:58 htpc2 epgd[28082]: Read 23 option from /etc/epgd/epgd.conf
Mar 12 18:30:58 htpc2 epgd[28082]: Using syslog facility 'user' (8), log level set to (1)
Mar 12 18:30:58 htpc2 epgd[28082]: Info: Calling mysql_library_init()
Mar 12 18:30:58 htpc2 epgd[28082]: Info: Stylesheet '/etc/epgd/tvmovie-utf-8.xsl' loaded
Mar 12 18:30:58 htpc2 epgd[28082]: Checking database connection ...
Mar 12 18:30:58 htpc2 epgd[28082]: Calling mysql_init(28082)
Mar 12 18:30:58 htpc2 epgd[28082]: SQL client character now 'utf8'
Mar 12 18:30:58 htpc2 epgd[28082]: Checking table structure and indices ...
Mar 12 18:30:58 htpc2 epgd[28082]: Checking table 'analyse'
Mar 12 18:30:58 htpc2 epgd[28082]: Initialy creating table 'analyse'
Mar 12 18:30:58 htpc2 epgd[28082]: create table analyse(channelid VARCHAR(50), vdr_masterid INT(11) unsigned, vdr_eventid INT(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 INT(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;
Mar 12 18:30:58 htpc2 epgd[28082]: create index idxvdr_masterid on analyse(vdr_masterid);
Mar 12 18:30:58 htpc2 epgd[28082]: Checking table 'channelmap'
Mar 12 18:30:58 htpc2 epgd[28082]: Initialy creating table 'channelmap'
Mar 12 18:30:58 htpc2 epgd[28082]: create table channelmap(extid VARCHAR(10), channelid VARCHAR(50), source VARCHAR(20), ord INT(11), visible INT(11), channelname VARCHAR(100), vps INT(11), format VARCHAR(50), unknownatvdr INT(1) unsigned, merge INT(11), mergesp INT(11), inssp INT(11), updsp INT(11), updflg VARCHAR(1), PRIMARY KEY(extid DESC, channelid DESC, source DESC)) ENGINE InnoDB;
Mar 12 18:30:58 htpc2 epgd[28082]: create index idxsourceExtid on channelmap(source, extid);
Mar 12 18:30:58 htpc2 epgd[28082]: create index idxsource on channelmap(source);
Mar 12 18:30:58 htpc2 epgd[28082]: create index idxupdflg on channelmap(updflg);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxsourcechannelid on channelmap(source, channelid);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxmergesp on channelmap(mergesp);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxchannelid on channelmap(channelid);
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'components'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'components'
Mar 12 18:30:59 htpc2 epgd[28082]: create table components(eventid INT(11) unsigned, channelid VARCHAR(50), stream INT(3), type INT(3), lang VARCHAR(8), description VARCHAR(100), inssp INT(11), updsp INT(11), PRIMARY KEY(eventid DESC, channelid DESC, stream DESC, type DESC, lang DESC, description DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'episodes'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'episodes'
Mar 12 18:30:59 htpc2 epgd[28082]: create table episodes(compname VARCHAR(100), comppartname VARCHAR(200), lang VARCHAR(10), inssp INT(11), updsp INT(11), link INT(11), shortname VARCHAR(100), compshortname VARCHAR(100), episodename VARCHAR(100), partname VARCHAR(300), season INT(11), part INT(11), parts INT(11), number INT(11), extracol1 VARCHAR(250), extracol2 VARCHAR(250), extracol3 VARCHAR(250), comment VARCHAR(250), PRIMARY KEY(compname DESC, comppartname DESC, lang DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxupdsp on episodes(updsp);
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'events'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'events'
Mar 12 18:30:59 htpc2 epgd[28082]: create table events(eventid INT(11) unsigned, channelid VARCHAR(50), masterid INT(11) unsigned not null auto_increment, useid INT(11) unsigned, source VARCHAR(10), fileref VARCHAR(50), inssp INT(10), updsp INT(10), updflg VARCHAR(1), delflg VARCHAR(1), tableid INT(2), version INT(3), title VARCHAR(200), comptitle VARCHAR(200), shorttext VARCHAR(300), compshorttext VARCHAR(300), longdescription MEDIUMTEXT, complongdescription MEDIUMTEXT, starttime INT(10), duration INT(5), parentalrating INT(2), vps INT(10), contents VARCHAR(100) comment 'Genre code like table 28 of ETSI EN 300 468', shortdescription VARCHAR(3000), actor TEXT, audio VARCHAR(50), category VARCHAR(50), country VARCHAR(50), director TEXT, flags VARCHAR(100), genre VARCHAR(100), info TEXT, music VARCHAR(250), producer TEXT, screenplay VARCHAR(500), shortreview VARCHAR(500), tipp VARCHAR(250), topic VARCHAR(500), year VARCHAR(10), rating VARCHAR(250), numrating INT(2), movieid VARCHAR(20), moderator VARCHAR(250), other TEXT, guest TEXT, camera TEXT, extepnum INT(4), imagecount INT(2), episodecompname VARCHAR(100), episodecompshortname VARCHAR(100), episodecomppartname VARCHAR(200), episodelang VARCHAR(10), scrseriesid INT(11), scrseriesepisode INT(11), scrmovieid INT(11), scrsp INT(11), PRIMARY KEY(eventid DESC, channelid DESC), KEY(masterid DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxcomptitle on events(comptitle);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxsource on events(source);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxfilerefsource on events(fileref, source);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxchannelid on events(channelid);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxuseid on events(useid);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxuseidchannelid on events(useid, channelid);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxupdflgupdsp on events(updflg, updsp);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxsourcechannelid on events(source, channelid);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxscrsp on events(scrsp);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxsourceupdsp on events(source, updsp);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxscrseriesid on events(scrseriesid);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxchannelidstarttime on events(channelid, starttime);
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'fileref'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'fileref'
Mar 12 18:30:59 htpc2 epgd[28082]: create table fileref(name VARCHAR(100), source VARCHAR(10), inssp INT(11), updsp INT(11), extid VARCHAR(10), fileref VARCHAR(100), tag VARCHAR(100), PRIMARY KEY(name DESC, source DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxSourceFileref on fileref(source, fileref);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxFileref on fileref(fileref);
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'imagerefs'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'imagerefs'
Mar 12 18:30:59 htpc2 epgd[28082]: create table imagerefs(eventid INT(11) unsigned, lfn INT(11), inssp INT(11), updsp INT(11), source VARCHAR(10), fileref VARCHAR(100), imagename VARCHAR(100), PRIMARY KEY(eventid DESC, lfn DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxlfn on imagerefs(lfn);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxname on imagerefs(imagename);
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'images'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'images'
Mar 12 18:30:59 htpc2 epgd[28082]: create table images(imagename VARCHAR(100), inssp INT(11), updsp INT(11), image MEDIUMBLOB, PRIMARY KEY(imagename DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'movie'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'movie'
Mar 12 18:30:59 htpc2 epgd[28082]: create table movie(movie_id INT(11) unsigned, movie_title VARCHAR(300), movie_original_title VARCHAR(300), movie_tagline VARCHAR(1000), movie_overview TEXT, movie_adult INT(11) unsigned, movie_collection_id INT(11) unsigned, movie_collection_name VARCHAR(300), movie_budget INT(11) unsigned, movie_revenue INT(11) unsigned, movie_genres VARCHAR(500), movie_homepage VARCHAR(300), movie_release_date VARCHAR(20), movie_runtime INT(11) unsigned, movie_popularity FLOAT(4,1), movie_vote_average FLOAT(4,1), PRIMARY KEY(movie_id DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxmovie_id on movie(movie_id);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxmovietitle on movie(movie_title);
Mar 12 18:30:59 htpc2 epgd[28082]: SQL-Error in 'create index idxmovietitle on movie(movie_title);' - Index column size too large. The maximum column size is 767 bytes. (1709)
Mar 12 18:30:59 htpc2 epgd[28082]: SQL-Error in 'createIndices()' - Index column size too large. The maximum column size is 767 bytes. (1709) '' [create index idxmovietitle on movie(movie_title);]
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'movie_actor'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'movie_actor'
Mar 12 18:30:59 htpc2 epgd[28082]: create table movie_actor(actor_id INT(11) unsigned, actor_name VARCHAR(300), PRIMARY KEY(actor_id DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'movie_actors'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'movie_actors'
Mar 12 18:30:59 htpc2 epgd[28082]: create table movie_actors(movie_id INT(11) unsigned, actor_id INT(11) unsigned, actor_role VARCHAR(300), PRIMARY KEY(movie_id DESC, actor_id DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'movie_media'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'movie_media'
Mar 12 18:30:59 htpc2 epgd[28082]: create table movie_media(movie_id INT(11) unsigned, actor_id INT(11) unsigned, media_type INT(11) unsigned, media_url VARCHAR(100), media_width INT(11) unsigned, media_height INT(11) unsigned, media_content MEDIUMBLOB, PRIMARY KEY(movie_id DESC, actor_id DESC, media_type DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'parameters'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'parameters'
Mar 12 18:30:59 htpc2 epgd[28082]: create table parameters(owner VARCHAR(40), name VARCHAR(40), inssp INT(11), updsp INT(11), value VARCHAR(150), PRIMARY KEY(owner DESC, name DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'recordingdirs'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'recordingdirs'
Mar 12 18:30:59 htpc2 epgd[28082]: create table recordingdirs(vdruuid VARCHAR(40), directory VARCHAR(255), inssp INT(11), updsp INT(11), PRIMARY KEY(vdruuid DESC, directory DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'recordinglist'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'recordinglist'
Mar 12 18:30:59 htpc2 epgd[28082]: create table recordinglist(md5path VARCHAR(40), starttime INT(11) unsigned, owner VARCHAR(40) comment 'uuid of vdr', inssp INT(10), updsp INT(10), lastifoupd INT(10), vdruuid VARCHAR(40), path VARCHAR(1000), name VARCHAR(1000), folder VARCHAR(1000), title VARCHAR(200), shorttext VARCHAR(300), longdescription MEDIUMTEXT, duration INT(11) unsigned, fsk INT(1) unsigned, eventid INT(11) unsigned, channelid VARCHAR(50), channelname VARCHAR(100) comment 'just a copy', state VARCHAR(1), inuse INT(1) unsigned, job VARCHAR(1), actor TEXT, audio VARCHAR(50), category VARCHAR(50), country VARCHAR(50), director TEXT, flags VARCHAR(100), genre VARCHAR(100), info TEXT, music VARCHAR(250), producer TEXT, screenplay VARCHAR(500), shortreview VARCHAR(500), tipp VARCHAR(250), topic VARCHAR(500), year VARCHAR(10), rating VARCHAR(250), numrating INT(2), moderator VARCHAR(250), other TEXT, guest TEXT, camera TEXT, episodecompname VARCHAR(100), episodecompshortname VARCHAR(100), episodecomppartname VARCHAR(200), episodelang VARCHAR(10), scrseriesid INT(11) unsigned, scrseriesepisode INT(11) unsigned, scrmovieid INT(11) unsigned, scrinfomovieid INT(11) unsigned, scrinfoseriesid INT(11) unsigned, scrinfoepisodeid INT(11) unsigned, scrnew INT(11) unsigned, scrsp INT(11), PRIMARY KEY(md5path DESC, starttime DESC, owner DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'searchtimers'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'searchtimers'
Mar 12 18:30:59 htpc2 epgd[28082]: create table searchtimers(id INT(11) unsigned not null auto_increment, inssp INT(11), updsp INT(11), channelids VARCHAR(500) comment 'comma separated list of channleids or empty', chformat VARCHAR(50) comment 'HD,SD', expression VARCHAR(200), expression1 VARCHAR(200), searchmode INT(11) unsigned comment '1 exact, 2 regexp, 3 like, 4 enthalten, ..', searchfields INT(11) unsigned comment 'Bitmaske: 1 title, 2 shorttext, 4 - desc, ..', searchfields1 INT(11) unsigned comment 'Bitmaske: 0 off, 1 title, 2 shorttext, 4 - desc, ..', casesensitiv INT(11) unsigned comment '0,1', repeatfields INT(11) unsigned comment 'Bitmaske: 1 title, 2 shorttext, 4 - desc, ..', episodename VARCHAR(100), season VARCHAR(10) comment 'e.g. \'1-7\'', seasonpart VARCHAR(10) comment 'e.g. \'20-\'', category VARCHAR(150) comment 'e.g. \'Spielfilm,Serie\'', year VARCHAR(10) comment 'e.g. \'2010-2015\'', tipp VARCHAR(250), noepgmatch INT(11), state VARCHAR(1) comment 'D - Deleted', namingmode INT(11), active INT(11) unsigned comment '0,1', source VARCHAR(40) comment 'webif ,osd, ...', hits INT(11) unsigned comment 'stastic counter, just for info', modsp INT(11) comment 'last user modification time', lastrun INT(11) comment 'last execution of search timer', vdruuid VARCHAR(40) comment 'empty or uuid of vdr', weekdays INT(11) comment 'bitmask like timers, 0 foy all', starttime INT(11) comment 'null for unlimited search', endtime INT(11) comment 'null for unlimited search', directory VARCHAR(512), priority INT(11), lifetime INT(11), vps INT(11), childlock INT(11), PRIMARY KEY(id DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'series'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'series'
Mar 12 18:30:59 htpc2 epgd[28082]: create table series(series_id INT(11) unsigned, series_name VARCHAR(200), series_last_scraped INT(11) unsigned, series_last_updated INT(11) unsigned, series_overview TEXT, series_firstaired VARCHAR(50), series_network VARCHAR(100), series_imdb_id VARCHAR(20), series_genre VARCHAR(100), series_rating FLOAT(4,1), series_status VARCHAR(50), PRIMARY KEY(series_id DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'series_actor'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'series_actor'
Mar 12 18:30:59 htpc2 epgd[28082]: create table series_actor(actor_id INT(11) unsigned, actor_name VARCHAR(100), actor_role VARCHAR(500), actor_sortorder INT(11) unsigned, PRIMARY KEY(actor_id DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'series_episode'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'series_episode'
Mar 12 18:30:59 htpc2 epgd[28082]: create table series_episode(episode_id INT(11) unsigned, episode_number INT(11) unsigned, season_number INT(11) unsigned, episode_name VARCHAR(300), episode_overview TEXT, episode_firstaired VARCHAR(20), episode_gueststars VARCHAR(1000), episode_rating FLOAT(4,1), episode_last_updated INT(11) unsigned, series_id INT(11) unsigned, PRIMARY KEY(episode_id DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'series_media'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'series_media'
Mar 12 18:30:59 htpc2 epgd[28082]: create table series_media(series_id INT(11) unsigned, season_number INT(11) unsigned, episode_id INT(11) unsigned, actor_id INT(11) unsigned, media_type INT(11) unsigned, inssp INT(11), updsp INT(11), media_url VARCHAR(100), media_width INT(11) unsigned, media_height INT(11) unsigned, media_rating FLOAT(4,1), media_content MEDIUMBLOB, PRIMARY KEY(series_id DESC, season_number DESC, episode_id DESC, actor_id DESC, media_type DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'snapshot'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'snapshot'
Mar 12 18:30:59 htpc2 epgd[28082]: create table snapshot(channelid VARCHAR(50), source VARCHAR(10), masterid INT(11) unsigned, eventid INT(11) unsigned, useid INT(11) unsigned, starttime INT(10), duration INT(5), title VARCHAR(200), comptitle VARCHAR(200), shorttext VARCHAR(300), compshorttext VARCHAR(300), updsp INT(10), episode VARCHAR(1), merge INT(11), images VARCHAR(1)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'timers'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'timers'
Mar 12 18:30:59 htpc2 epgd[28082]: create table timers(id INT(11) unsigned not null auto_increment, vdruuid VARCHAR(40), inssp INT(11), updsp INT(11), eventid INT(11) unsigned, channelid VARCHAR(50), source VARCHAR(40), state VARCHAR(1) comment '\'D\'eleted, \'R\'unning, \'F\'inished', info VARCHAR(255) comment 'error reason if state is failed', action VARCHAR(1), reason VARCHAR(250), tccmailcnt INT(11), namingmode INT(11), active INT(11) unsigned, day INT(10), weekdays INT(10), starttime INT(10), endtime INT(10), file VARCHAR(512), directory VARCHAR(512), priority INT(11), lifetime INT(11), vps INT(11), childlock INT(11), aux VARCHAR(1000), autotimerid INT(11) unsigned comment 'id of autotimer', autotimerinssp INT(11), doneid INT(11) unsigned comment 'id of done entry', expression VARCHAR(200), PRIMARY KEY(id DESC, vdruuid DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'timersdone'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'timersdone'
Mar 12 18:30:59 htpc2 epgd[28082]: create table timersdone(id INT(11) unsigned not null auto_increment, inssp INT(11), updsp INT(11), source VARCHAR(40), state VARCHAR(1) comment 'Q requested, C created, R recorded, F Failed', timerid INT(11) unsigned comment 'not filled completely in all cases yet', autotimerid INT(11) unsigned, title VARCHAR(200), comptitle VARCHAR(200), shorttext VARCHAR(300), compshorttext VARCHAR(300), longdescription MEDIUMTEXT, complongdescription MEDIUMTEXT, episodecompname VARCHAR(100), episodecompshortname VARCHAR(100), episodecomppartname VARCHAR(200), episodelang VARCHAR(10), episodeseason INT(11), episodepart INT(11), channelid VARCHAR(50), channelname VARCHAR(100), expression VARCHAR(200) comment 'expression of autotimer', starttime INT(10), duration INT(5), aux VARCHAR(512), PRIMARY KEY(id DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'useevents'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'useevents'
Mar 12 18:30:59 htpc2 epgd[28082]: create table useevents(cnt_source VARCHAR(10), cnt_channelid VARCHAR(50), cnt_eventid INT(11) unsigned, cnt_masterid INT(11) unsigned, cnt_useid INT(11) unsigned, sub_source VARCHAR(10), sub_eventid INT(11) unsigned, all_updsp INT(11), cnt_updflg VARCHAR(1), cnt_delflg VARCHAR(1), cnt_fileref VARCHAR(50), cnt_tableid INT(2), cnt_version INT(3), sub_title VARCHAR(200), sub_shorttext VARCHAR(300), sub_comptitle VARCHAR(200), sub_compshorttext VARCHAR(300), sub_genre VARCHAR(100), sub_country VARCHAR(50), sub_year VARCHAR(10), cnt_starttime INT(10), cnt_duration INT(5), cnt_parentalrating INT(2), cnt_vps INT(10), cnt_contents VARCHAR(100) comment 'Genre code like table 28 of ETSI EN 300 468', sub_category VARCHAR(50), sub_shortdescription VARCHAR(3000), sub_shortreview VARCHAR(500), sub_tipp VARCHAR(250), sub_rating VARCHAR(250), sub_numrating INT(2), sub_topic VARCHAR(500), sub_longdescription MEDIUMTEXT, sub_complongdescription MEDIUMTEXT, cnt_longdescription MEDIUMTEXT, sub_info TEXT, sub_moderator VARCHAR(250), sub_guest TEXT, sub_actor TEXT, sub_producer TEXT, sub_other TEXT, sub_director TEXT, sub_screenplay VARCHAR(500), sub_camera TEXT, sub_music VARCHAR(250), sub_audio VARCHAR(50), sub_flags VARCHAR(100), sub_imagecount INT(2), sub_scrseriesid INT(11), sub_scrseriesepisode INT(11), sub_scrmovieid INT(11), sub_scrsp INT(11), sub_episodecompname VARCHAR(100), sub_episodecompshortname VARCHAR(100), sub_episodecomppartname VARCHAR(200), epi_episodename VARCHAR(100), epi_shortname VARCHAR(100), epi_partname VARCHAR(300), epi_lang VARCHAR(10), epi_extracol1 VARCHAR(250), epi_extracol2 VARCHAR(250), epi_extracol3 VARCHAR(250), epi_season INT(11), epi_part INT(11), epi_parts INT(11), epi_number INT(11), PRIMARY KEY(cnt_source DESC, cnt_channelid DESC, cnt_eventid DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'users'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'users'
Mar 12 18:30:59 htpc2 epgd[28082]: create table users(user VARCHAR(40), inssp INT(11), updsp INT(11), passwd VARCHAR(100), active INT(1), rights INT(11) unsigned, PRIMARY KEY(user DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'vdrs'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'vdrs'
Mar 12 18:30:59 htpc2 epgd[28082]: create table vdrs(uuid VARCHAR(40), inssp INT(11), updsp INT(11), name VARCHAR(100), version VARCHAR(100), dbapi INT(11) unsigned, lastupd INT(11), nextupd INT(11), state VARCHAR(20), master VARCHAR(1), ip VARCHAR(20), pid INT(11) unsigned, svdrp INT(11) unsigned, tunercount INT(11) unsigned, shareinweb INT(1) unsigned, usecommonrecfolder INT(1) unsigned, videodir VARCHAR(300), videototal INT(11) unsigned, videofree INT(11) unsigned, PRIMARY KEY(uuid DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: Closing mysql connection and calling mysql_thread_end(28082)
Mar 12 18:30:59 htpc2 epgd[28082]: Calling sd_notify(STOPPING=1$)
Mar 12 18:30:59 htpc2 epgd[28082]: Info: Released the last usage of mysql_lib, calling mysql_library_end() now
Mar 12 18:30:59 htpc2 systemd[1]: epgd.service: Control process exited, code=exited status=1
Mar 12 18:30:59 htpc2 systemd[1]: epgd.service: Unit entered failed state.
Mar 12 18:30:59 htpc2 systemd[1]: epgd.service: Failed with result 'exit-code'.
^C
htpc2 epgd #
Alles anzeigen