It is currently Thu Mar 28, 2024 9:02 pm

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 21 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: Database Error
PostPosted: Fri Mar 02, 2018 5:59 pm 
Offline

Joined: Sat Sep 10, 2016 9:33 pm
Posts: 73
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.


Top
 Profile  
 
 Post subject: Re: Database Error
PostPosted: Fri Mar 02, 2018 6:24 pm 
Offline
User avatar

Joined: Tue Sep 27, 2005 2:28 am
Posts: 7632
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?


Top
 Profile  
 
 Post subject: Re: Database Error
PostPosted: Sat Mar 03, 2018 3:53 pm 
Offline

Joined: Sat Sep 10, 2016 9:33 pm
Posts: 73
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.


Top
 Profile  
 
 Post subject: Re: Database Error
PostPosted: Sat Mar 03, 2018 7:18 pm 
Offline
User avatar

Joined: Tue Sep 27, 2005 2:28 am
Posts: 7632
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.


Top
 Profile  
 
 Post subject: Re: Database Error
PostPosted: Sun Mar 04, 2018 4:20 pm 
Offline

Joined: Sat Sep 10, 2016 9:33 pm
Posts: 73
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.


Top
 Profile  
 
 Post subject: Re: Database Error
PostPosted: Sun Mar 04, 2018 4:34 pm 
Offline
User avatar

Joined: Tue Sep 27, 2005 2:28 am
Posts: 7632
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.


Top
 Profile  
 
 Post subject: Re: Database Error
PostPosted: Mon Mar 05, 2018 1:36 am 
Offline

Joined: Sat Sep 10, 2016 9:33 pm
Posts: 73
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!


Top
 Profile  
 
 Post subject: Re: Database Error
PostPosted: Mon Mar 05, 2018 1:40 am 
Offline

Joined: Sat Sep 10, 2016 9:33 pm
Posts: 73
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.


Top
 Profile  
 
 Post subject: Re: Database Error
PostPosted: Mon Mar 05, 2018 1:48 am 
Offline

Joined: Sat Sep 10, 2016 9:33 pm
Posts: 73
I added the movie back as "The Hours" and it scanned fine.


Top
 Profile  
 
 Post subject: Re: Database Error
PostPosted: Mon Mar 05, 2018 2:24 pm 
Offline
User avatar

Joined: Tue Sep 27, 2005 2:28 am
Posts: 7632
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.


Top
 Profile  
 
 Post subject: Re: Database Error
PostPosted: Mon Mar 05, 2018 8:15 pm 
Offline

Joined: Sat Sep 10, 2016 9:33 pm
Posts: 73
I am using the latest version. With renaming the file, it is working fine.


Top
 Profile  
 
 Post subject: Re: Database Error
PostPosted: Mon Mar 05, 2018 11:15 pm 
Offline
User avatar

Joined: Tue Sep 27, 2005 2:28 am
Posts: 7632
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.


Top
 Profile  
 
 Post subject: Re: Database Error
PostPosted: Thu Mar 08, 2018 5:19 am 
Offline

Joined: Sat Sep 10, 2016 9:33 pm
Posts: 73
Thanks. I will let you know.


Top
 Profile  
 
 Post subject: Re: Database Error
PostPosted: Thu Mar 08, 2018 4:40 pm 
Offline

Joined: Sat Sep 10, 2016 9:33 pm
Posts: 73
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()


Top
 Profile  
 
 Post subject: Re: Database Error
PostPosted: Thu Mar 08, 2018 5:36 pm 
Offline
User avatar

Joined: Tue Sep 27, 2005 2:28 am
Posts: 7632
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.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 21 posts ]  Go to page 1, 2  Next

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: Google [Bot] and 20 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  


Powered by phpBB © 2024 phpBB Group