Opened 14 years ago

Closed 14 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


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
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.

Change History (1)

comment:1 Changed 14 years ago by xris

Resolution: fixed
Status: newclosed

(In [13085]) use the correct time value for retrieving table data for sql file rebuild. closes #2962

Note: See TracTickets for help on using tickets.