Kodi Community Forum

There seems to be a bug with the Video Export to separate files.

When exporting from Eden, XML fields like <lastplayed />, <premiered /> or <aired /> would just be empty.

Now under Frodo, they look like this :


I verified and they are NULL in MySQL. I don't want to use those files to refresh my library and have these fake dates be populated...

To me, they should be empty if they are NULL in the database...

For now, i have removed all invalid dates and times using TextCrawler...

Is this a bug?

-Pr.

I can confirm this.
Is it expected behaviour?

on linux the dates are 1969-12-31


EDIT:
also there is a difference when exporting or importing a video <lastplayed> tag is now missing time part (compared to Eden). It's correctly stored in database table when a file is played in xbmc.

For example if you play file in xbmc db stored lastplayed is "2013-03-02 07:00:00"
but is exported as 2013-03-02
imported lastplayed is always "2013-03-02 00:00:00" (even if you have "2013-03-02 07:00:00" lastplayed in .nfo)

How can you tell the difference if you start a library from a scratch and import from previously exported files, it's not uncommon to have several media played on same day and when they are imported with same time sorting by lastplayed in smart playlists gets broken.

This works in Eden.

In unix 1.1.1970 is the start of time (the epoch). All times are stored as seconds since the epoch, so 0 is in fact midnight on the evening of 31.12.69/morning of 1.1.70.

So that explains what you are seeing, but it is indeed an error in interpreting the null value in the DB.

Created trac ticket : http://trac.xbmc.org/ticket/14159

(2013-02-28, 06:34)Pr.Sinister Wrote: [ -> ]

Code:

<lastplayed>1601-01-01</lastplayed>
<premiered>1601-01-01</premiered>
<aired>1601-01-01</aired>
<dateadded>1601-01-01 00:00:00</dateadded>

This is an old post but this is still the same with Gotham Beta 3 when exporting the database into separate NFO files. Was it supposed to be solved?

It says in the bug ticket that it will be fixed in version 13... What's the status on this?

It should be fixed, yes. If you get stuff exported, then as far as XBMC is concerned they're valid dates.

Compare exactly what is in the dateadded (etc.) fields of the database.