Recent Posts

Pages: 1 2 [3] 4 5 ... 10
21
I have been using ThumbsPlus 10 for several years now.
All of a sudden, today, I started getting this message whenever I try to view
some JPG images. This message is actually imbedded in the thumbs themselves:

This Format Requires ThumbsPlus Professional Edition

Please help.
Thank you!
thmbsatha
22
I just realised that those old newsgroup messages must have been written with the old .TD4 database format in mind. Hopefully you can 'translate' the field names to those used by TP8 and higher.
23
Hi Ernst,

I don't know about those date searches. Maybe we can look into that later.

As for gallery searches: If you don't like SQL, a possible workaround is that you simply assign a unique keyword to all the files in that gallery, and then do a regular search for that keyword, plus your additional search criteria.

If you prefer an SQL method, I will copy 2 very old but relevant messages below from the old Cerious Newsgroups. They come without their original context (otherwise I'd have to copy and paste whole threads), but the information contained in them could still be helpful, I think.

Regards,

-Daan-

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=[ 1 ]=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
From: "Jose G. Filippa" <jose@cerious.com>
Newsgroups: cerious.support
Subject: Re: Thumbsplus 7.0 problem with gallery search
Date: Fri, 14 Apr 2006 10:14:46 -0300

Hi Chris,

In order to find those thumbnails which are included in at least one gallery
or sub-gallery but are not included in a specific gallery you should use the
following SQL statement:

tn.idThumb in (select gt.idThumb from GalleryThumb as gt) and tn.idThumb not
in (select GalleryThumb.idThumb from GalleryThumb inner join Gallery on
GalleryThumb.idGallery=Gallery.idGallery where Gallery.name like 'UF\%')

Now for a set of galleries and sub-galleries you should use:

tn.idThumb in (select gt.idThumb from GalleryThumb as gt) and tn.idThumb not
in (select GalleryThumb.idThumb from GalleryThumb inner join Gallery on
GalleryThumb.idGallery=Gallery.idGallery where Gallery.name in
('UF\Gallery1','Temp'))

(Note that you can not use wildcards when using the "in" operator.)

Or if you really need to use wildcards:

tn.idThumb in (select gt.idThumb from GalleryThumb as gt) and tn.idThumb not
in (select GalleryThumb.idThumb from GalleryThumb inner join Gallery on
GalleryThumb.idGallery=Gallery.idGallery where  (Gallery.name like 'UF\%' or
Gallery.name like 'Temp%'))

By the way, your query (the one that hung your ThumbsPlus) worked OK in
ThumbsPlus in my system. I will continue investigating about this issue.

Best regards,

Josť G. Filippa
Cerious Software



=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=[ 2 ]=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
From: Uwe Zimmermann <uwezi@/no_mail/sciencetronics.com>
Newsgroups: cerious.support
Subject: Re: Search Gallery
Date: Mon, 01 Nov 2004 12:56:16 +0100

Until galleries finally work like normal directories, you should be
able to use the additional SQL query:

this is for one specific gallery "galleryname"
-----------------------------------------------
exists (select idThumb from gallerythumb gt inner join gallery
ga on gt.idGallery = ga.idGallery where ga.name = 'galleryname' and
gt.idThumb = tn.idThumb)

this is for images in any gallery
-----------------------------------------------
exists (select idThumb from gallerythumb gt where
gt.idThumb = tn.idThumb)

    Uwe.
24
I have some troubles with the search function of ThumbsPlus 10. Searching only for keywords runs quick and without any troubles.
But always when I need a more restricted search there I have problems.
Often I would need a search which is restricted to only one specific Gallery. I have not found a solution for such search. Is it possible?
I have some knowledge about SQL statements but I am not able to find a way to make it run.

Another problem: I already searched by date with Advanced Search and the field tn.[file_time_iso]. But it seems to me that even that is no longer possible. Maybe that something has changed with Version 10? I don't remember the last time that I have searched by date successfully.

I hope, this program is still alive because I love it. It's very quick, simple to use and easy to configure for the use together with other programs. These are the reasons why I still stay with ThumbsPlus. But I would like to see some improvements for search functions (date/time, gallery, gps data - search by rectangle of a map, ...).
Many thanks,
Ernst
25
ThumbsPlus v10 Questions / Re: TP10/Windows 11/Folder Icons
« Last post by Gary on 2022-11-04 13:06:55 »
Thanks, Dann.
26
ThumbsPlus v10 Questions / Re: TP10/Windows 11/Folder Icons
« Last post by Daan van Rooijen on 2022-11-04 12:45:36 »
The help file suggests that ThumbsPlus will show the Windows folder icon ("Display folders -- Include folders in the thumbnail display. With this option checked, ThumbsPlus will also make thumbnails for folders, based on the current Windows thumbnail").

So, if you can get Win 11 to show those XP-style thumbnails, hopefully TP will adopt those too.
27
ThumbsPlus v10 Questions / TP10/Windows 11/Folder Icons
« Last post by Gary on 2022-11-04 12:02:44 »
Prior to Win11 22H2, M$ removed folder thumbnails so TP10 only displays a plain folder thumbnail for any new or refreshed folders.  Win11 22H2 restored a pitiful version of folder thumbnails so at least we get a stupid looking cropped single image thumbnail.  WTF M$?  Is there any way to make TP10 create folder thumbnails similar to XnViewMP?  i.e. folder thumbnail with 1 to 4 image thumbnails within.

28
ThumbsPlus v10 Questions / Re: Where did the sql examples go?
« Last post by Daan van Rooijen on 2022-10-09 00:45:12 »
It has been cataloged in the Archive.org 'Way Back Machine', see:

https://web.archive.org/web/20170925061254/http://www.cerious.com/faq_sql.shtml

This particular page shows the last capture from sometime in 2017, but there have been many earlier captures as well.
29
ThumbsPlus v10 Questions / Where did the sql examples go?
« Last post by Street Mann on 2022-10-08 11:27:11 »
Am trying to find that help file concerning how to structure my sql to searches of my annotations for a particular word. I hit the examples link in the help for the sql but it seems broken....  http://www.cerious.com/faq_sql.shtml

has that page been moved. Where?

I found that was very helpful.

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