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

Recent Posts

Pages: 1 [2] 3 4 ... 10
11
ThumbsPlus v10 Questions / Re: MYSQL
« Last post by Daan van Rooijen on 2020-06-16 15:39:43 »
Frankly it's all Greek to me  :-X

Are you sure that the ANSI quotes mode is active? Are you using the Unicode (not ANSI) version of the Mysql driver?
12
ThumbsPlus v10 Questions / Re: MYSQL
« Last post by wingfield on 2020-06-16 14:56:00 »
Daan,

here's the ODBC trace file.  I don't know what it's telling us, if anything.  thoughts?

David
13
ThumbsPlus v10 Questions / Re: MYSQL
« Last post by Daan van Rooijen on 2020-06-16 14:51:36 »
I have no further thoughts for now (well, not on Msql :D ) but you may find a few more pointers in this topic:

http://forum.thumbsplus.com/forum/index.php?topic=5103.msg6179#msg6179
14
ThumbsPlus v10 Questions / Re: MYSQL
« Last post by wingfield on 2020-06-16 13:44:20 »
Hello Daan,

as always, your replies are greatly appreciated!

>> Has the my.sql settings file changed, in particular the setting about ANSI quotes?
I have the ansi quotes setup in the ODBC system connection.  I'd think this overrides anything in the my.sql file; but I will check.

>> Have you tried running ThumbsPlus with full Admin rights?
yes

>> Have you tried to (temporarily!) turn on tracing in Windows' ODBC panel?
I will try this.  my recollection is that this creates a very long file that's difficult to understand ;>)

>> In theory TP might be incompatible with your new Mysql version, but I have no details on what goes with which.
this is possible; but I'm doubting it

I'll cycle back after trying these items.  any other thoughts, please let me know.

David
15
ThumbsPlus v10 Questions / Re: MYSQL
« Last post by Daan van Rooijen on 2020-06-16 09:22:02 »
Just some thoughts..:

Has the my.sql settings file changed, in particular the setting about ANSI quotes?
Have you tried running ThumbsPlus with full Admin rights?
Have you tried to (temporarily!) turn on tracing in Windows' ODBC panel?
In theory TP might be incompatible with your new Mysql version, but I have no details on what goes with which.
 
16
ThumbsPlus v10 Questions / MYSQL
« Last post by wingfield on 2020-06-15 19:57:13 »
hello,

I've been successfully using TP on MYSQL on my WAMP server for years.  Today, I upgraded my WAMP server and TP no longer successfully accesses my MYSQL db.  it gives the below error message.  the only thing I can see that has changed is that the port MYSQL uses has changed from (by memory 3306??) to 3308.  I've gone ahead and changed this in the ODBC connection and the "test" function provides a successfull connection to the database from the ODBC.

Database error : The selected database is not a Thumbsplus database.  If you are connecting to a client/server Thumbsplus database, check with the database administrator to ensure your login has appropriate priveleges.


any ideas on how to fix this issue?
17
How would I use SQLite3? Thanks in advance.

Go to Database | New, give your new database a name and change its format to SQLite3. Set the thumbnail size and JPEG quality to your desired values and press Save. Experiment with it to see if you like its performance and reliability.

When you exit and re-launch TP, it may be using its regular Access type database again - this depends on your setting for 'initial database' in Options | Prefs | Startup.
18
How would I use SQLite3? Thanks in advance.
19
Thank you. That worked.
20
I did. The image gets a little bit larger but still way smaller than the area of the thumbnail, i.e. still lots of white space. In the attached SS, the first two TN's have been remade.
The magnifying glass in the toolbar above the thumbnails shows that the thumbnail display is being magnified to 300%. Please reset that to 100%.

Then go to Options | Preferences | Thumbnails and verify that a large size, e.g. 320x320, has been set here (btw, it's best to use multiples of 8 for width and height).

Then go back to the thumbnails, press Ctrl-A to select all the files in the folder and press F3 to re-make them. They really should look good at that point.. hopefully they will.

p.s. Of course the increased thumbnail size comes at a price, which is that the database will reach its 2GB maximum size much sooner. If that is a concern, you may want to use the SQLite3 database format instead of the default Access format (Database | New). SQLite3 does not have a size limit. Or, maybe you can still use small thumbnails, but turn on the Preview of the file-under-the-cursor using Window | Show Panels | Preview. Yet another alternative is Options | Preferences | Thumbnail View | Enable Popup Tips, which shows a magnified thumbnail when the mouse pointer hovers over a file.
Pages: 1 [2] 3 4 ... 10