Messages

1

ThumbsPlus v10 Questions / Thumbs 10 Pro - MySQL

« on: 2016-03-03 23:59:33 »

First you should post your questions to the right category.  Announcements is for Cerious to announce new software versions.

Second, please follow the instructions per the thread entitled "TP7 w/ MySQL: Full instructions by PeteW1959".  This is the most complete information on the forums.

Third, if you still have problems after reading the above information, you will need to provide information, on what exactly the error message states.

Only the pro and network versions of ThumbsPlus are able to use the external MySQL/Maria/PostgreSQL/etc databases.

2

ThumbsPlus v10 Questions / Thumbs 10 Pro - MySQL

« on: 2016-03-03 08:49:57 »

ferraltek please go to the support page and click on database support or you can use the direct link: http://www.cerious.com/databases.shtml

3

ThumbsPlus v10 Questions / v10 error message

« on: 2016-02-11 09:02:40 »

> Daan,
>
> on the home network version, how does that work?  they just upgraded me, so perhaps I'm missing something.  I took a look at the db in HeidiSQL and I see a table called userid.  it's populated with a user; but this is not the user that I'm using to connect with ODBC.  are these the same, or is this userid table for use by the program to handle the 5 concurrent logins?  when I first got in successfully, I never had to enter a user.  odd.
>
> David

table userid?   That table name is not in my database.  I have activeusers, username and usersettings tables among the other required tables.  I do not use the network version, but I would assume either you did not have a completely successful conversion from V7 to V9 (unknown table userid) or maybe your activeusers table has 5 entries of past successful logins and upon past program exits/crashes, those entries were not removed from the table.  Try clearing the data from activeusers (using a copy of your database) and see if it works.
First though, try to create a fresh V9/V10 database using the V9/V10 scripts to verify that everything is set up correctly and you can create thumbnails and log in and out of your network version.

4

General Discussion / TP9 Database Statistics: How Large?

« on: 2015-06-12 09:05:07 »

Sorry, have not upgraded to TP9 yet.  Here is the stats of my TP 7 DB using MySQL.
When TP9 is stable and ready for prime time I will convert.  The size of the database files (MyIsm not Innodb) is 14.6Gb.

5

ThumbsPlus v7-v9 Questions / ThumbsPlus V9 Beta 3 Scroll wheel zoom problem

« on: 2014-10-19 10:14:05 »

Thanks for the information Gary.  I have no problem with the program automatically choosing the "active" window based upon whichever window the mouse is within.  It just does not make sense to zoom the preview window AND scroll the main window at the same time. It should be one or the other.

The program now requires another click in the preview window to be able to zoom it without scrolling the main window.

6

ThumbsPlus v7-v9 Questions / ThumbsPlus V9 Beta 3 Scroll wheel zoom problem

« on: 2014-10-18 06:42:18 »

If you click in the main window the mouse scroll wheel can be used to page through your images as designed.  If you click into the preview window for the currently selected image, the scroll wheel will zoom the image in and out as designed.

But... if you select an image in the main window and hover over the image in the preview window, the scroll wheel will zoom the preview image AND scroll the images in the main window. I have not seen this behavior before and don't think this should occur.

7

ThumbsPlus v7-v9 Questions / ThumbsPlus 7 : MySQL database : Part 1

« on: 2014-08-23 18:01:00 »

Mysql Server 5.6.17 on Win 64
Mysql ODBC 5.3 Unicode Driver version 5.03.02.00  Using "system data source"
Mysql Workbench 6.1, and SQLyog
SQL script.  I created my database in 2006 before Phillip posted his version on the website.  I used Mysql rather than the InnoDB file system.

I think you should use the scripts provided by Phillip at http://www.cerious.com/databases.shtml.
I made script mods (tweeking storage sizes for some table items, I didn't keep track of my mods)that may make upgrading to the V9 or 10 database difficult.  I have not tried upgrading yet.

Steve

8

ThumbsPlus v7-v9 Questions / So, where to from here...?!

« on: 2011-06-11 12:43:38 »

Nzmike, you may want to check out ThumbsPlus_8_001.schema and the Python script upgradeserver.py in the Thumbsplus program dir.  You will see what the new V8 table formats should be and the upgrade script goes through each V7 table to alter the tables to V8.  This same procedure could have been written in SQL rather than Python and fed to the sql engine.

Hope this helps.  I am not an expert in either language so I can not offer much futher help.

Sjoinca