View Single Post
Old 03-24-2020, 10:55 PM   #3996
Atherton25
Zealot
Atherton25 can teach chickens to fly.Atherton25 can teach chickens to fly.Atherton25 can teach chickens to fly.Atherton25 can teach chickens to fly.Atherton25 can teach chickens to fly.Atherton25 can teach chickens to fly.Atherton25 can teach chickens to fly.Atherton25 can teach chickens to fly.Atherton25 can teach chickens to fly.Atherton25 can teach chickens to fly.Atherton25 can teach chickens to fly.
 
Posts: 124
Karma: 3804
Join Date: May 2016
Device: Kindle Oasis 2
Quote:
Originally Posted by JimmXinu View Post
New Test Version Posted

2020-03-24
- Make sure all timestamps are using Calibre's local_tz.
I think that did it! Whatever it is that you changed, it seems to be working on my test database. I'll be running it on my main one to see if it ever throws that error again and then (should it happen again) I'll try to narrow it down as best as possible.

I was prepared to zip a copy my test database with stripped down personal.ini and and offer it for checking, and then I was finally able to narrow it down very specifically to discover what was doing it. I'm sorry my instructions weren't quite clear enough, but you saw it at least once. I probably missed a step when I was rewriting the instructions/situation. Yes, I was definitely using the Last Checked Column feature. I thought I'd said that right, but apparently I hadn't.

And I understand the frustration. I've been having this error off and on for well over a year, probably closer to 2, if not longer. It seemed that, just randomly, I couldn't sort by a date column. And once I tried to sort by the wrong column (I think it was always my FFFCheck column) I got errors thrown anytime I tried to sort by another column I'd have to change databases, or restart Calibre. With the large database I work in getting back in takes a minute or two no matter how I did it, so it was *really* annoying particularly when I wanted to just upload the books onto my kindle and walk away.

Thanks for the fix.
Atherton25 is offline   Reply With Quote