Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Daan van Rooijen

Pages: [1] 2 3 ... 61
Thanks Bernard! It's interesting that no conversion is required for the taken_time_iso field!

Most dates and times in the database are stored in unix format, i.e. seconds that have passed since jan 1, 1970. You can use the Udate command to convert them into the less cryptic ISO format that Windows uses. This is a sample query that queries the regular file date:

    tn.file_time = ^udate(yyyy-mm-dd HH:mm:ss)

For a range of times/dates, you'd combine two expressions using the AND operator, like this:

    (tn.file_time >= ^udate(2022-02-10))
    AND (tn.file_time < ^udate(2022-02-11))

Hopefully these examples will also work when you use the  tn.[taken_time_iso] field instead.

I did exactly what you said, but the resulting database was somehow corrupted.

I'm very sorry to hear that - and surprised! Did you see any error messages? The Compact & Repair function that ThumbsPlus uses is actually part of the Windows operating system, and one of its main purposes is to prevent corruption, not cause it. I hope you've been able to restore a backup.

When you delete information from a database, the database file itself does not shrink because the information is not physically removed from the database. It is only flagged internally as deleted. This is because database files can get very large, and re-writing them everytime that a record is deleted would make them too slow.

So, to physically cleanse the database file of deleted records, you use a special function that you find in the menu as Database | Compact & Repair.

Before you use this function, you may want to do two other things first:

1) Remove thumbnails that you no longer need. You can do so by in several ways. For instance, you can select them and press Shift-Del. Or you can right-click on a folder name (in the tree) and use Remove from Tree, to remove all thumbnails pertaining to that folder and its subfolders (be very careful that you do not accidentily use just Del or Delete Folder because that would delete the actual image files from your harddrive!)

2) Remove 'orphaned' thumbnails. A thumbnail record is orphaned when the file that it describes no longer exists. To remove orphans, use Thumbnail | Remove | Orphans from the menu.

When you have done these things, you can use the Compact & Repair function that I mentioned earlier to re-gain a lot of space.

I'm just curious if anyone else has tried contacting them, and whether there was any response.
That's strange about the bug system response. Maybe you should just try again? I haven't talked to them recently either, but I'm also not seeing any complaints from people who have problems getting support or a key. Anyway, if you need HEIC support now, I'm not sure if you should keep waiting, seeing how long we already have been waiting.

Have you written to ?

I don't think I've heard of this problem before, but I'd recommend that you try these two small freeware tools that deal with Explorer context menus and shell extensions:

Hopefully one of those will let you reenable TP's context menu entries!

I just realized, you're also on the Ritlabs forum, aren't you?

Haha, yes I am!

Hopefully someone still looks in this subforum.

I do, but I'm afraid I don't have any suggestions!

I don't know the secret recipe either, but the regular thumbnail settings (under Options | Preferences) allow you to choose sharpening and contrast enhancement, so maybe those come into play here as well.

Have you tried if Thumbnail | Export to JPG gives you images of a similar quality?

The Viewer/Editor has an auto-enhancement function in its Image menu that's cryptically named Xe847. One thing that it does is turn anything blueish into a sunny sky blue. Once you know that, it's easy to tell which images have been treated with it. Another possibility could be Histogram stretching.

If you could post a few representative sample images that show the original and web-thumbnailed images for comparison (at the same size), maybe those will offer further clues as to what's happening under the hood.

My pleasure, I'm glad it was solved. I've had the same problem myself a few times! :)

I'd try setting the sorting order (of the thumbnail display) to 'None', and not use either of the 'thumbnails first' or 'thumbnails last' sorting options.  Then go into the folder that was scanned. The first file that has not been thumbnailed correctly is probably the one that caused the error. It's probably a file that requires a plug-in (raw files, pdf, etc) or some other external module (e.g. a zip file). Once you have identified that file, you can temporarily rename or move it, so that you can hopefully complete the thumbnailing with no further errors.

Interesting, and maybe it will help someone else. Thanks again!

Then from a bit more googling I realised I needed to set up the system DNS using the ODBC for SQL Server 2017 driver rather than the native SQL Server driver.

Great to hear that it's working properly again, and thanks for getting back with the solution. If you remember where you read about that solution, I'd be curious to read it too -- do you still have the link? Was it specific to ThumbsPlus or was it a more generic solution for SQL-based databases?

Something else that you could try:

Exit ThumbsPlus, locate your Thumbs10.ini configuration file and make a backup copy of it. Then open it in Notepad and add this section to it:


Save the file and re-launch TP10 to see if it makes a difference. It would disable the built-in virtual memory manager, which can cause delays too. If it does not help, I would exit TP again and restore the previous .ini file.

Pages: [1] 2 3 ... 61