last_modified column gives error

Bug #769466 reported by Firedancer885
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
calibre
Fix Released
Undecided
Unassigned

Bug Description

I added the predefined column to the book list window. But when I try to sort by this column I get an error. I added the column in 0.7.56, and then updated to 57 but the error is still present. All the books I added, and then haven't modified since 01 jan. 11, are displayed as 01 jan. 00 in this column. Can this be the problem? I'm using XP sp3.

I'm attaching the error output file.

Related branches

Revision history for this message
Firedancer885 (firedancer) wrote :
Revision history for this message
Charles Haley (cbhaley) wrote :

The last modified date should not display as 01 Jan 00 unless the book was changed on 1 Jan 2000 (or 1900 or 1800).

Questions:
1) Does the date change if you modify the metadata?
2) Does every newly added book have that date?
3) What do you see if you change the template in the Last Modified column to "dd MMM yyyy". The easiest way to change the template is to click in the last modified column, press F2, change the template, then press OK.

Revision history for this message
Firedancer885 (firedancer) wrote : Re: [Bug 769466] Re: last_modified column gives error

2011.04.23. 13:59 keltezéssel, Charles Haley írta:
> The last modified date should not display as 01 Jan 00 unless the book
> was changed on 1 Jan 2000 (or 1900 or 1800).
>
> Questions:
> 1) Does the date change if you modify the metadata?
> 2) Does every newly added book have that date?
> 3) What do you see if you change the template in the Last Modified column to "dd MMM yyyy". The easiest way to change the template is to click in the last modified column, press F2, change the template, then press OK.
>
Hi,

thanks for the quick response.

1, Yes, the date changes to today's date.
2, I just added a new book. That books displays today's date in the last
modified column.
3, The dates change to 01 jan. 2000. I made a clean install at the end
of October 2010 (I didn't have the program on my laptop before) and
updated it regularly. The earliest unmodified book has the date of 06
Nov. 2010 and the last modified column reads 01 jan. 2000.
I have a dual boot laptop (Ubuntu and XP) and I also installed the
program to Ubuntu. I used the same library on both (the calibre book
library is on an external hard drive), but haven't opened the library in
Ubuntu since the 0.7.2 something update. I always used the windows program.

Kate

Revision history for this message
Charles Haley (cbhaley) wrote :

Is your language set to something other than English, French, or German?

If so, could you change your language to English and see if the problem goes away?

Revision history for this message
Firedancer885 (firedancer) wrote :

You mean go to preferences/look and feel and change the language? I changed it to english. The dates are the same. :( And I still get an unhandled exception error when I try to sort by last_modified. I'm using Hungarian XP and even after changing the language the dates are displayed in hungarian.

I modified the template to dd MM yyyy and I no longer get the unhandled exception error. Now the column sorts without error. I have no problem with the date column and that one has the same date format as last_modified had. The date column displays the months in abbreviated hungarian and sorts without problems.

Kate

Kovid Goyal (kovid)
Changed in calibre:
assignee: nobody → Charles Haley (cbhaley)
Revision history for this message
Charles Haley (cbhaley) wrote :

Thanks for helping debug.

I think that the problem comes from the date translation getting confused by the 2-digit years. I have changed calibre in two ways:
1) Date strings that for some reason are not understood are set to a real date instead of being set to nothing.
2) The default template for last_modified is set to dd MM yyyy.

This is enough for now, because last_modified will soon become a 'real' column, eliminating the issues that arise by using the custom column.

Changed in calibre:
assignee: Charles Haley (cbhaley) → nobody
status: New → Fix Committed
Revision history for this message
Kovid Goyal (kovid) wrote : Fixed in lp:calibre

Fixed in branch lp:calibre. The fix will be in the next release. calibre is usually released every Friday.

 status fixreleased

Changed in calibre:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Bug attachments

Remote bug watches

Bug watches keep track of this bug in other bug trackers.