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 ... 55
Have you checked ?

Are you using the same type and size of images as before?

Is editing images in ThumbsPlus the only thing that is slow, or do other tasks in ThumbsPlus, or other programs, now work more slowly too?

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


This would disable the built-in virtual memory manager - but that will likely only make a difference if not just the editing but also the loading of image files has become slow.

(ps: This is the correct place for your question, so I have removed the cross-post from the General Discussion section)

My guess would be that you may have used File | Jpeg | Turn, which is a lossless operation that cannot be undone (the file is directly modified).

The regular Turn operations under Transform | Turn & Mirror are undoable (well, except if Undo has been turned off to save memory. In the viewer/editor, see View | Preferences | Tab:Editing | Disable Undo if that might be the case).

I have been through Preferences and Customize but can see no button for Undo/redo.

Undo/Redo are only available in the Viewer/Editor.

If that's where you were looking, try View | Customize | Tab:Toolbars and turn on the 'Edit' toolbar - that's whereyou should find them.

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.

Pages: [1] 2 3 ... 55