Opened 17 years ago
Closed 17 years ago
#2962 closed defect (fixed)
nuvexport needs to use starttime, not progstart, for it's SELECT query.
Reported by: | jppoet | Owned by: | xris |
---|---|---|---|
Priority: | minor | Milestone: | unknown |
Component: | perl / nuvexport | Version: | 0.20 |
Severity: | medium | Keywords: | |
Cc: | Ticket locked: | no |
Description
I selected an episode of "How it's Made" to archive. The entries in recorded have:
chanid: 6110 starttime: 2006-10-29 22:29:00 endtime: 2006-10-29 23:00:00 title: How It's Made progstart: 2006-10-29 22:30:00 progend: 2006-10-29 23:00:00
And told it to "2. Export to .nuv and .sql"
The resulting "How it's Made.txt" file has:
title: How It's Made subtitle: description: Aluminum cans; electrical wires; casting; automated machines. starttime: 2006-10-29T22:30:00 endtime: 2006-10-29T23:00:00 category: Science chanid: 6110 channum: #6110 callsign: #6110 channame: #6110 airdate: 2002-12-14T00:00:00 stars: 0 recgroup: Default seriesid: SH415402 programid: EP4154020028
Notice how the starttime is wrong. It has the progstart instead.
The Resulting .sql file has:
USE mythconverg; ; INSERT INTO oldrecorded (findid, programid, recstatus, reactivate, duplicate, starttime, endtime, category, rectype, station, chanid, description, subtitle, generic, recordid, seriesid, title) VALUES ('0', 'EP4154020028', '-3', '0', '1', '2006-10-29 22:30:00', '2006-10-29 23:00:00', 'Science', '3', 'SCIENCE', '6110', 'Aluminum cans; electrical wires; casting; automated machines.', '', '0', '1692', 'SH415402', 'How It\'s Made'); ; ;
oldrecorded is the only data generated. recorded, recordedmarkup and recorded seek are all empty, since it used the wrong value for starttime in the SELECT query.
Note: See
TracTickets for help on using
tickets.
(In [13085]) use the correct time value for retrieving table data for sql file rebuild. closes #2962