Page 1 of 2

Database Error

Posted: Fri Mar 02, 2018 5:59 pm
by edhill54
I get a database error in the middle of scanning for new movies and the program closes. This just started with the last update or so. The only way I have found to get around it is to delete the database and start all over.

Re: Database Error

Posted: Fri Mar 02, 2018 6:24 pm
by (cool) Hector
edhill54 wrote:I get a database error in the middle of scanning for new movies and the program closes.

If the crash occurs in the middle of scanning, it looks like the algorithm is stumbling on a file name. We need to discover what's the culprit file name and I'll be able to fix the bug.

As the scanning progresses, it displays the name of the files. Are you able to find the file on your disk just after the last displayed name?


edhill54 wrote:The only way I have found to get around it is to delete the database and start all over.

And it doesn't crash anymore if you scan again?

Re: Database Error

Posted: Sat Mar 03, 2018 3:53 pm
by edhill54
If I delete the database and scan, it scans everything correctly, but the next time the error occurs. I have tried to delete the file that it hangs up on. When I do it scans and hangs up on another file. I do not think it is the file that is causing the problem. When I delete the database and rescan, the "problem" file scans fine. The next time in scanning it just would hang up on a different file.

Re: Database Error

Posted: Sat Mar 03, 2018 7:18 pm
by (cool) Hector
edhill54 wrote:the next time the error occurs. I have tried to delete the file that it hangs up on. When I do it scans and hangs up on another file.

I'd love to know the name of those files, so I can test on my computer.


edhill54 wrote:I do not think it is the file that is causing the problem.

From my experience, each time the scanning crashed it was a problem with the file name. I don't know what else it could be.


edhill54 wrote:When I delete the database and rescan, the "problem" file scans fine.

I'm surprised. Please give me some file names anyway, it'll be a start.

Re: Database Error

Posted: Sun Mar 04, 2018 4:20 pm
by edhill54
When I delete the database and rescan, it scans all of the movies just fine. However, it hangs up before it finishes cleanly. When I rescan it hangs up on the same movie. I have tried to delete the movie and rescan and it just picks another movie to hang up on.

Re: Database Error

Posted: Sun Mar 04, 2018 4:34 pm
by (cool) Hector
Some file names can take longer to analyze than other. Please give me some file names, so I can see if they are ordinary names or if they could be related to the problem. Don't forget that it's not the last displayed name, but the one after it on your disk.

Re: Database Error

Posted: Mon Mar 05, 2018 1:36 am
by edhill54
After handing up I added several movies and it scanned all of them without a problem. Later I added none move and it hung up. I hung up on Hounds of Love (next movie was Hours.) I deleted Hounds of Love and hung up on Hounddog (next on list Hours. I deleted Hours and it scanned fine. Hours has been on my drive for sometime and has scanned fine in the past. I added it back and it hung up again on Hours so Hours must be the problem. Weird!

Re: Database Error

Posted: Mon Mar 05, 2018 1:40 am
by edhill54
The problem movie was "The Hours" the 2002 movie with Meryl Streep. However, I had it in the database as "Hours." Perhaps that was the problem.

Re: Database Error

Posted: Mon Mar 05, 2018 1:48 am
by edhill54
I added the movie back as "The Hours" and it scanned fine.

Re: Database Error

Posted: Mon Mar 05, 2018 2:24 pm
by (cool) Hector
edhill54 wrote:Hours has been on my drive for sometime and has scanned fine in the past.

Some time ago, I've improved the scanning algorithm. It's quite possible that I've introduced a new bug.

Anyway, I've made the test with hours.avi and there was no problem. I've added Hounddog.avi and Hounds of Love.avi but still no problem.

It's more difficult to fix a bug if I can't reproduce it on my computer. If the program crashes, I could send you a debug version that will generate a crash dump that would give us more details about the bug.

But before, please confirm that you're using the latest version 4.10.4 like me. You can see the version number in the title bar of the program.

Re: Database Error

Posted: Mon Mar 05, 2018 8:15 pm
by edhill54
I am using the latest version. With renaming the file, it is working fine.

Re: Database Error

Posted: Mon Mar 05, 2018 11:15 pm
by (cool) Hector
The debug version seems to be our only option to discover more about this bug...

Here it is:

http://www.coollector.com/Coollector_DEBUG.exe

Please use this version when you scan your files (the rest of the time, you can use the normal version).

If this version crashes, it should generate a crash dump. You'll send me the 2 files from the crash dump and I'll know more about the nature of the bug.

Re: Database Error

Posted: Thu Mar 08, 2018 5:19 am
by edhill54
Thanks. I will let you know.

Re: Database Error

Posted: Thu Mar 08, 2018 4:40 pm
by edhill54
When I try to run the debug program, I get the following error message.
Microsoft Visual C++ Runtime Library
Assertion failed!
Program: ....
File: ..\..\src\formate.cpp
Line: 565

Expression: total == _data.ColSize()

Re: Database Error

Posted: Thu Mar 08, 2018 5:36 pm
by (cool) Hector
That's strange, this version runs fine on my computer. Have you tried a second time? If your other version of Coollector works fine, this one should work fine too. There's something I don't understand.