User forums now online! Please see the latest post in the Announcements forum for more information.

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] 4 5 ... 56
Does it have to do with how I shut things down that leaves me listed as an active user.

Yes, if you don't shut ThumbsPlus down correctly, you may get this error about active users. To close ThumbsPlus, use the small 'x' button in the top-right corner of the window, or press Alt-F4 on the keyboard, or click File | Exit in the menu.

About once the month my just for me database tells me there are too many users and I have to wait a very long time for it to clear itself up.
ThumbsPlus keeps track of active users through a field in the database. Could it be that your database is read-only or you (sometimes) don't have write-access to it?

PS: instead of switching to the only-you database after launching TP, you could also make a shortcut on your desktop that specifies the database (full path, between quotes if it contains spaces) on the command line.

What I was talking about: Some years ago, a helpful fellow named Uwe Zimmermann made a set of interesting templates for the  Web Wizard that is built into ThumbsPlus. They can still be downloaded here in a .zip archive:

ThumbsPlus v10 Questions / Re: Thumbs 10 Pro - MySQL
« on: 2019-05-23 12:17:14 »
Thanks for the feedback, good to hear that you got it working!

ThumbsPlus v10 Questions / Re: Thumbs 10 Pro - MySQL
« on: 2019-05-22 19:24:19 »
Fellow user also once took the trouble of explaining how he got things to work with MySQL and PostgreSQL, and that message seems to have disappeared as well. I will quote it here from my backup of it, in case it may contain any useful clues for you:

Experiences with MySQL and PostgreSQL Client/Server Database

by, Saturday, May 09, 2015, 16:59

Since 2007 I am using TP7 with a MySQL database. It still runs on a NAS-Box.
Now I decided to migrate to TP9sp2. As I have another application running a lot faster with PostgreSQL than with MySQL, I wanted to run all with PostgreSQL.
But after several unsuccessful days with PostgreSQL I switched to MySQL.
By the way: The database conversion TP7 -> TP9 did not work.

But now TP9 works with MySQL!
A lot of time I lost because of using the most recent MySQL ODBC-driver version 5.2 that I used without any problems for my TP7-database. Version 5.1 works fine with TP9 - version 5.2 does NOT! You need the 32bit ODBC driver version! The 64bit ODBC driver does not work with ThumbsPlus.
You have to put in
in the field "Initial Statement:" of the MySQL Connector/ODBC Data Source Configuration. All the rest I left as is.
If you have Win7 64bit, you cannot use the default ODBC configuration tool. You have to use C:\windows\SysWOW64\odbcad32.exe . Otherwise you cannot configure
the 32bit ODBC-driver.

I created an empty database with default settings (UTF8 character set):
Then I used the SQL-File to create all tables and the necessary entries in table "ThumbsPlusDatabase".
TP9 now could connect and I scanned all 120.000 pictures without troubles.
After some queries which where very slow I remembered, that the default engine for MySQL tables is "MyISAM".
Queries are a lot faster with "InnoDB" engine! Therefore I converted the tables to "InnoDB":
Now queries are fast again!


But I was not happy, because I was not able to run TP9 with my PostgreSQL server :-(
Again and again I have read the forum thread of KurtA, heinzelrumpel and Daan van Rooijen (thank you a lot!). Finally TP9 now also runs with PostgreSQL 9.2 on my NAS box.
What I have done:
Created a database with ENCODING=UTF8, collation and character type set to en_US.UTF-8
Downloaded the SQL file from
Changed "idFileType" to "idFiletype" in table "Thumbnail" (I have not tested, but I think it is not
anymore necessary with ThumbsPlus 9 SP2; I did not change the table name "ThumbsPlusDatabase" to "thumbsplusdatabase").
I used this SQL-script for creation of the tables and all necessary entries in the table "ThumbsPlusDatabase"
Important!: I have lost a lot of time because by mistake I created the tables as admin-user. So the owner of these tables was not the thumbsplus-user. Therefore PostgreSQL did not allow access when I tried to connect with TP9. I had to change the owner of all tables to thumbsplus-user.

Next I downloaded and installed PostgreSQL ODBC driver
Again - you have to use C:\windows\SysWOW64\odbcad32.exe on a Win7 64bit system. Otherwise you cannot configure 32bit ODBC drivers!
When selecting the ODBC-driver choose "PostgreSQL Unicode" (NOT ANSI!).
Fill in all connection data (server name, name of database, user and password). Then click the button "Datasource" an go to "Page 2".
Activate "bytea as LO"!
All the rest I left as is.

Now I could connect TP9 with my new PostgreSQL database.
Some hours later I can tell you now, the performance seems to be even better than MySQL with InnoDB engine.
All 120.000 pictures are scanned and I will begin to test and check if all runs well. If so, I will uninstall my good old TP7 and delete the corresponding MySQL database.


Hope, this helps someone.

Have a nice day,


ThumbsPlus v10 Questions / Re: Thumbs 10 Pro - MySQL
« on: 2019-05-22 19:12:17 »
I can't find the thread entitled "TP7 w/ MySQL: Full instructions by PeteW1959" anywhere on your forum.

That thread must have been lost in the conversion to the current forum software, but it wouldn't have been of much help anyway because it concerned ThumbsPlus 7, which had a very different database format.

Its author, PeteW1959, later published a MySQL database creation script for ThumbsPlus 9 which many found useful. If I'm not mistaken, ThumbsPlus 10 uses the same format. If interested (it also contains some rudimentary instructions), you can download it here:

I can successfully connect to my MariaDB box through a 32 bit ODBC connection so I think I'm good as long as I can get the schema working.

For MySQL, two solutions to common problems are:

- Use the Unicode driver, not the ANSI version.
- Put this in your my.ini configuration file:

I've never used MariaDB, so I don't know if any of this is actually relevant to your problem :)

ThumbsPlus v10 Questions / Re: Webp files (Chrome)
« on: 2019-05-14 09:35:32 »
I'm having an extremely difficult time trying to view these files in Thumbsplus 10.2

There was a post from nearly three years ago, but that really hasn't helped (Missing link).

This link is said to be working:

However you may want to read the recent discussion here about it causing Photo Viewer in the latest Win10's to show Webp images darker::

why can I not see the Import function?

I don't know - it could be for either of the reasons that you cite. Or maybe they removed the import/export commands (I'm using an older v10, build 4001 from July 2015) but I don't see that mentioned in the release notes.

Do you also still have the older TP version and the *.td4 database that it produced 9 years ago? And are the image files regular JPGs? If so, you could:

1) Re-install that older version of ThumbsPlus in a folder of its own (e.g. C:\TP7 - not under program files).
2) (temporarily) Use Explorer to change the volume label of drive C: to "EH" (without the quotes), which seems to be what it was on the older PC.
3) Re-create the folder C:\JLM History Picture Project
4) Copy the folder and files from the backup to this project folder, such that their structure within that folder is identical to what it was 9 years go.
5) Then (and ONLY then) launch the old TP with the old *.td4 database and see if you can properly browse and view the old images, as well as see their annotations, in the new program folder.

If you can get that working, the next step would be to incorporate the annotations into the image files themselves in the form of IPTC metadata. That would allow TP10 and other software to access it later.

So, that's one possible approach. Alternatively, for instance if all that you have is that exported text file, you can try to import it into TP10 using Database | Advanced | Import, which may or may not work (that part of TP is a bit wonky).  The old volume label and old main folder name no longer exist though, so you could either recreate that old situation (as above) or try to edit the TXT data beforehand (use Search and Replace in a text editor to replace the old label and folder names with the new ones). TP needs the volume labels and paths that were recorded in the database for each thumbnail to be the same as they are in reality, on your current hard drive, or it can't match up the image files with their records in the database.

I'm not sure exactly what to change, or how to do it.

The order of fields in a TP7 .txt export is:

,"UserFields([0;Original Date/Time;uf_Original_DateTime;12;23])","Galleries"

Is there a way to do that in TP - e.g. can I point to TP to the new top-level folder for the database (in this case change "JLM History Picture Project" to "041128 JLM History Photos Backup") and have it do the redirect or is there some other way?

Yes, and this would be approach No. 3.  If you keep backups of your database(s), there IS a simple method that lets you re-match orphaned folders in the database (as they're called) with their new equivalents on the harddisk. In that case you won't have to recreate the old situation, nor edit the .txt file - you would just import the old data. Next, you would look up the (greyed-out, orphaned) old folder such as Album 002 in the tree, and drag-and-drop it onto its new location (Album 002 in the new '041128 JLM History Photos Backup' folder) (it helps if you open all relevant folders beforehand). At that point, TP will carry the data from the orphaned old image files over to their same-named brethren in the new folder.

That's usually the easiest method, but you must be sure to keep backups in case anything goes wrong (if you're dealing with tens or hundreds of folders it's easy to drop one at the wrong place). Also before doing this, in TP10, you must make sure that this option is off: "Options | Preferences | Thumbnails | Autoremove Orphans". If you try this, be sure to verify afterwards that all images really have their annotations back.

I've got backups of everything but, I've gotten new computers and all the drive paths have changed even though I've got exactly the same file/folder structure beneath.

Make sure that the drive volume labels are exactly the same as before, too (for the drives that hold images).

Which version of TP do you have?

That's possible only if you have configured TP to copy the desired IPTC values from the image files into user fields in its database.

For this to work you must have "Automatically populate user fields from image metadata" on in Options | Prefs | Metadata, and you must have made one or more user fields (Database | Setup User Fields) whose names are identical to those of the IPTC fields that you want to copy into the database. The user fields must be of type 'Text' and long enough to hold the data. From then on, when you make (or re-make) thumbnails, ThumbsPlus will copy the values from the IPTC fields to the matching user fields in your database, which enables you to search them (ThumbsPlus doesn't search files, it only searches its own database, which is much faster and which allows you to search media items stored offline).

P.S. for a list of iptc / user field names, see

ThumbsPlus v10 Questions / Re: Keyword Problem
« on: 2019-04-21 10:44:05 »
What you see there are probably your "Most Recently Used keywords", which are stored in the configuration file THUMBS10.INI.

You can either just ignore them, or use a different method to enter keywords (e.g. press Ctrl-K / Strg-K ).

If you really, really want to get rid of them, maybe you can use a utility that edits ini-files from the command line to remove the [MruKeywords] section from thumbs10.ini. I have never used it, but it looks like INIFILE (link) can do this for you.

So, what you would do is create a batchfile that first runs INIFILE to clear the keywords and then it launches ThumbsPlus (or, you could create 2 batchfiles -- one for each of your databases!). Somewhat like this (you'll have to change the paths and filenames for your setup) :

@Echo off
INIFILE thumbs10.ini [MruKeywords] /remove 
"C:\Program Files\Thumbs10\Bin\Thumbs10.exe" "D:\Data\FirstDatabase.tpdb8"

Finally, you would make a shortcut (icon) on your desktop for each batch file, and from then on you can launch ThumbsPlus with the desired database with a single double-click.

General Discussion / Re: Locating Orphans
« on: 2019-04-18 17:10:36 »
I have a 20 year old database with tens of thousands of pictures in hundreds if not thousands of folders.  Is there a way to search the entire database for orphans.

You could select a drive in the Location panel, right-click on it and turn on 'show child folders' so that thumbnails from all its folders and subfolders will be shown.

Then go to Edit | Select By | Orphans to select all orphans. Maybe from there you can add them to a new gallery, from which you can examine them and get back to them later.

Repeat this for any other drives that may have orphans.


p.s. In the Options | Preferences | Thumbnails screen, please be sure to have the "Show Orphans" setting ON and "Auto Remove Orphans" OFF.  I think those are the default values, but just in case... :)

This is hard to explain, so I think I'll just suggest to you what I would do:

1) Go to Window | Layout and choose Default Layout as a good starting point.

2) Grab the bottom-right Tasks window by its title bar and drag it towards the bottom-left Preview window. When you hover over this Preview window (with the left mouse button still pressed down), a sign wil appear that shows four arrows around a tabbed little window. Position your cursor over that tabbed window in the center of the sign and let go of the left mouse button. The Tasks panel will now join the Preview panel, and little tabs at the bottom let you switch between these views/functions. I'd click on the Preview tab to activate that view.

3) Close the big Metadata panel on the right by clicking its little 'x' button.

4) Back to the left side of the screen, hover the cursor over the divider between the Location panel and the Preview/Tasks panel, until the cursor changes shape and shows tiny up and down arrows. You can now drag the divider down so you get a larger location window and a smaller Preview/Tasks window. Put it wherever you prefer to have it.
5) Likewise, grab the vertical divider between the Location panel and the big thumbnails pane, and make the location panel smaller (leaving more space for thumbnails).

You should now have an efficient layout that shows you all the most used information, and where eveything stays at its place as long as you don't press any pins and don't drag any panels around (if you ever find yourself mistakenly dragging a panel away, you can press Esc to cancel that action).

I hope this helps! If the resulting layout is not how you wanted things to look, you can use Window | Show Panels to select the panels that you want to see, and use the methods from steps 2 and 4/5 to arrange them.

ThumbsPlus v10 Questions / Re: Strange Keyword behavior
« on: 2019-04-05 09:05:46 »
Ideas as to what happened..

None whatsoever.. I'm afraid this may be a bug that would be best reported to the developers.

I will go back and manuall re-add the keyword of day 01 thru day 09 and it WILL show up as a query field, but then I will duplicates int he image database window ( but only a single one in the Edit Keywords list , BTW)

You should be able to use Database | Edit Keywords to look up and delete those dupes.

Pages: 1 2 [3] 4 5 ... 56