Messages

31

ThumbsPlus v10 Questions / Error when connection to Maria DB on NAS

« on: 2016-04-03 21:35:03 »

Udo,

read the below link and pay attention to the "ansi quotes" part.  this is a killer for anyone using SQL databases, since the program does not check to ensure this setting is properly set.  further, (at least in my case), the default setting for this variable is not what TP requires, so I need to manually set the stupid thing just about everytime I get in to the db; even though I have it coded in my .ini file.

at current, my program doesn't work as their current version for home network has a problem with filling the user count and not resetting when you reboot.  unfortunately, I'm dead in the water; but hopefully this "ansi quotes" setting fixes your issue.

http://forums.cerious.com/forum/index.php?id=4284

David

32

ThumbsPlus v10 Questions / another v10 error message

« on: 2016-01-27 20:03:22 »

Hello,

Daan or other folks,

any idea what this one might mean??



thank you,

david

33

ThumbsPlus v10 Questions / v10 error message

« on: 2016-01-25 21:00:48 »

so you're suggesting I reinstall in a different directory?  TP defaults to the program files directory.  I guess I can try this; but I'd think Cerious wouldn't default install to a directory that doesn't work??  odd.

34

ThumbsPlus v10 Questions / v10 error message

« on: 2016-01-25 18:56:01 »

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

35

ThumbsPlus v10 Questions / v10 error message

« on: 2016-01-25 18:52:06 »

Daan,

I really appreciate the time you take to answer questions on this forum.

>> Well, it should be specific to that particular database, so, double-click on another database and you should be back into the program.
yep, can get back in.

>> But as to working with this particular database, I don't have much information to go by. Make sure that you have full read/write access to the database.
correct.  remember that I got into this database successfully on prior attempt.


>>Is it in a plain non-system folder on a regular local disk?
TP, or the database?  TP is in "program files".  the db is MYSql, and is also in "program files"

>> Does running ThumbsPlus as Admin help?
nope.  same set of error messages.

>> Do you get the error straight away or only after a long time, maybe after energy saving has kicked in?
straight away.

any other thoughts?

David

36

ThumbsPlus v10 Questions / v10 error message

« on: 2016-01-24 22:12:16 »

Daan,

thank you very much for your response.  any idea on how to fix this so I can get back into the program??

David

37

ThumbsPlus v10 Questions / v10 error message

« on: 2016-01-24 17:23:17 »

folks,

any idea what this error means.  I successfully got in to TPv10 earlier today after a v7 to v10 restore.  played around with some stuff, mostly just setting favorites.  I got out, then an hour or so later, got back in and I get the below error.

thank you for any help.

38

ThumbsPlus v10 Questions / convert mysql database from v7 to v10

« on: 2016-01-23 17:11:06 »

folks,

when I try to convert v7 db to v10 db, I get the error shown below.  any ideas?

additional info.  the db works in v7.  only other info possibly relevant is that I just did a new windows 10 install.  I had this working in win7 before I upgraded.

39

ThumbsPlus v10 Questions / v10 MYSql

« on: 2016-01-23 17:07:24 »

folks,

anyone know if there are mysql scripts for tp v10?

thank you,

40

ThumbsPlus v7-v9 Questions / new computer. how to make TP7 sp2 recognize.

« on: 2015-04-19 17:31:33 »

Daan,

yes, I successfully converted from v7 sp2 to v9.  it took some work; and frankly I'm not sure I can recreate all the steps.  I had Mariadb installed and had successfully gotten v7 sp2 to work; however, I found issues.  for example, I could not create user fields without getting a permission error.  as I'm not a DBA, I decided I didn't want to mess with SQL issues on permission grants.  basically, I'm thinking the Cerious SQL script that created the db had some things missing.  so back to MySQL.  you will remember that I had serious issues with MySQL not allowing me to set sql_mode = "ansi_quotes".  well, I finally managed to get around it after literally months of messing with it.  I ended up creating a new windows user profile, completely uninstalling MySQL, then reinstalling it.  after that, I used the v7 SQL script on the cerious website.  it has issues.  as an example, the script on the cerious site has the following commands which are depracated and no longer work, so I had to remove them.

TYPE=InnoDB;

also, to even run the script, I had to use workbench to manually set the "sql mode" to ansi quotes.  once I did this, I ran the modified script.  it successfully created the v7 sp2 database.  next I had to make sure I had 32bit ODBC installed, as TP will apparently not work with 64 bit ODBC.  got my ODBC connector created, opened TP v7 sp2, and voila.  working database.  finally, I restored my actual data / db from backup.

the conversion to v9 at this point was somewhat trivial.  I backed up my v7 db again from my now working version.  I did this from within the program and also used workbench.  I installed v9, and simply used the database / advanced / convert client/server command.  it converted the v7 db in place.

finally - I modified my "my.ini" file so that it had sql mode = "ansi_quotes" whenever the mysql service starts.  from now on, I'm thinking I'll never have the problem again of being in the wrong mode.

hope this helps.  I probably could have given a more logical step wise procedure of what I did; but this should be pretty close.

David

41

ThumbsPlus v7-v9 Questions / new computer. how to make TP7 sp2 recognize.

« on: 2015-04-16 21:59:33 »

Daan,

ah, but of course.  I was copying the files, since I was keeping my old NAS as a 2nd backup.  I've tried "moving" the files, and that worked like a charm.

again, thank you very much.

I've now successfully moved my v7 db to v9 in MySQL.  

David

42

ThumbsPlus v7-v9 Questions / new computer. how to make TP7 sp2 recognize.

« on: 2015-04-16 18:22:07 »

Daan,

if I might ask one more related question.  how do I get the galleries over??

David

43

ThumbsPlus v7-v9 Questions / TP7 to TP9 MySQL conversion error : part 1

« on: 2015-04-15 22:08:01 »

hello,

in trying to convert a working v7 MySQL db to v9, I get the following errors.  any thoughts on this would be appreciated.

Opening database for conversion.
Identifying database...
Database server type is MySQL.
Mappings: {u'TEXT': u'longtext', u'COUNTER': u'int(11) not null primary key auto_increment', u'FLAG': u'bit', u'INT64': u'bigint(20)', u'DATE': u'varchar(32)', u'ID': u'int(11)', u'INT32': u'int(11)', u'INT16': u'smallint(5)', u'BIN64': u'tinyblob', u'BLOB': u'longblob', u'WCHAR': u'varchar'}
Removing pre-v7 cruft.
Exec (nocheck): drop table [ActiveUsers]
Exec (nocheck): drop table [CurrentUsers]

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.currentusers'
<1051•42S02>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.currentusers'
Exec (nocheck): drop table [Logins]

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.logins'
<1051•42S02>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.logins'
Exec (nocheck): drop table [DoesPathHaveThumbs]

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.doespathhavethumbs'
<1051•42S02>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.doespathhavethumbs'
Exec (nocheck): drop table [GalleryThumbStart]

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.gallerythumbstart'
<1051•42S02>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.gallerythumbstart'
Exec (nocheck): drop table [GetThumbnail]

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.getthumbnail'
<1051•42S02>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.getthumbnail'
Exec (nocheck): drop table [KeywordByFile]

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.keywordbyfile'
<1051•42S02>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.keywordbyfile'
Exec (nocheck): drop table [KeywordGroupCount]

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.keywordgroupcount'
<1051•42S02>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.keywordgroupcount'
Exec (nocheck): drop table [ThumbnailGallery]

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.thumbnailgallery'
<1051•42S02>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.thumbnailgallery'
Exec (nocheck): drop table [ThumbnailPath]

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.thumbnailpath'
<1051•42S02>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.thumbnailpath'
Exec (nocheck): drop table [ThumbnailUDF]

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.thumbnailudf'
<1051•42S02>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.thumbnailudf'
Exec (nocheck): drop table [UpdatePathNames]

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.updatepathnames'
<1051•42S02>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Unknown table 'thumbs.updatepathnames'
Creating new tables.
Exec (nocheck):

    create table [ThumbsPlusDatabase] (
        [attribute] varchar(50) not null primary key,
        [value]     varchar(255) not null
    )



   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Table 'thumbsplusdatabase' already exists
<1050•42S01>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Table 'thumbsplusdatabase' already exists
Exec (nocheck):

    create table [FoundLists] (
        [idList"     int(11) not null primary key,
        [ListName]   varchar(255) not null,
        [TableName]  varchar(255) not null,
        [SQLText]    longtext
    )

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Table 'foundlists' already exists
<1050•42S01>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Table 'foundlists' already exists
Exec (nocheck): alter table [FoundLists] add constraint [U_FoundListName] unique ([ListName])

   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Duplicate key name 'U_FoundListName'
<1061•HY000>
   [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.24-log]Duplicate key name 'U_FoundListName'
Exec (nocheck):

    create table [FoundThumbs] (
        [idList]     int(11) not null,
        [idThumb]    int(11) not null,
        [flags]      int(11) not null
    )

44

ThumbsPlus v7-v9 Questions / new computer. how to make TP7 sp2 recognize.

« on: 2015-04-15 18:38:07 »

Daan,

as always, the support you provide to forum members is very much appreciated.  thank you so much for the prompt response.  fortunately, I still had the drive, so I went with option number one.

David

45

ThumbsPlus v7-v9 Questions / new computer. how to make TP7 sp2 recognize.

« on: 2015-04-14 21:59:39 »

hello - hoping Daan or someone else here can help answer this question.  I've purchased and installed a new NAS.  unfortunately, I just grabbed my entire data directory and copied it over to the new NAS.  as such, thumbsplus still thinks all my files are on the old NAS server.  how would I go about fixing this issue so that I don't lose all my galleries, user defined fields, etc?  is there some way to point TP7 sp2 to the new NAS server?  if not, is there an alternate way to fix this problem?