61
ThumbsPlus v7-v9 Questions / 3928 No database import
« on: 2013-08-14 11:14:45 »
Doug, you can install v8, do the import there and the new database will open in v9 as the database format in 8 and 9 is exactly the same.
User Forums
News:
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.
62
ThumbsPlus v7-v9 Questions / Client/Server Conversion fails instantly.
« on: 2013-07-25 15:54:49 »
Unless you want to wait for the next service release when the conversion script is fixed, you will have to install TP8 to do the conversion. TP9 can then open the TP8 database without any further conversion.
I don't know exactly how long 28,000 records will take to convert, but it shouldn't take too long, perhaps and hour or two? Leave it running overnight perhaps?
Just a quick word of warning; BACKUP YOUR TP7 SQL DATABASE FIRST. THE CONVERSION IS DONE 'IN PLACE' AND THERE IS NO EASY ROUTE BACK IF IT GOES WRONG!
I don't know exactly how long 28,000 records will take to convert, but it shouldn't take too long, perhaps and hour or two? Leave it running overnight perhaps?
Just a quick word of warning; BACKUP YOUR TP7 SQL DATABASE FIRST. THE CONVERSION IS DONE 'IN PLACE' AND THERE IS NO EASY ROUTE BACK IF IT GOES WRONG!
63
ThumbsPlus v7-v9 Questions / There are still issues with poor support
« on: 2013-07-09 04:43:31 »
Last week I was going to go for the upgrade offer as support had seemed to be getting their act together.
However my upgrade path wasn't on the special offer list (TP9 Pro to TP9 Home Network). I emailed sales for clarification and I'm still waiting for a reply.
A reply now would be useless, as the summer sale offer has ended, and I haven't been able to take advantage.
I am glad about the recent support improvements, but come on Cerious, if you want to be taken seriously as a software house, you still need to do better.
However my upgrade path wasn't on the special offer list (TP9 Pro to TP9 Home Network). I emailed sales for clarification and I'm still waiting for a reply.
A reply now would be useless, as the summer sale offer has ended, and I haven't been able to take advantage.
I am glad about the recent support improvements, but come on Cerious, if you want to be taken seriously as a software house, you still need to do better.
64
ThumbsPlus v7-v9 Questions / ODBC on Win7 64 bit: Pitfalls & Advice
« on: 2013-07-08 03:29:29 »
I am running TP9 on 64 bit Win 7, with 64 bit MySQL and 32 bit MySQL ODBC connector and it works fine.
You have to download and install the 32 bit MySQL ODBC connector manually as it doesn't come as part of the 64 bit MySQL package.
[link]http://dev.mysql.com/downloads/connector/odbc/3.51.html[/link]
TP9 does indeed crash with 64 bit ODBC drivers, but TP9 is a 32 bit app so it is to be expected.
You have to download and install the 32 bit MySQL ODBC connector manually as it doesn't come as part of the 64 bit MySQL package.
[link]http://dev.mysql.com/downloads/connector/odbc/3.51.html[/link]
TP9 does indeed crash with 64 bit ODBC drivers, but TP9 is a 32 bit app so it is to be expected.
65
ThumbsPlus v7-v9 Questions / 3928 won't import .txt to MySQL
« on: 2013-07-07 05:06:19 »
I have a database with external thumbnails, which need to be processed into the new MySQL database. This is why I can't just use an SQL script to do the conversion.
However it doesn't matter what format (external or internal thumbnails) the database is in, the import process is broken (as Laura has confirmed), and doesn't even get started.
I realise that the process is going to be slow (it took 7 hours to create the export file), but that isn't the problem.
However it doesn't matter what format (external or internal thumbnails) the database is in, the import process is broken (as Laura has confirmed), and doesn't even get started.
I realise that the process is going to be slow (it took 7 hours to create the export file), but that isn't the problem.
66
ThumbsPlus v7-v9 Questions / 3928 won't import .txt to MySQL
« on: 2013-06-29 04:07:52 »
In this instance I do need TP to do the conversion.
I want to convert a .tpdb8 with external thumbnail files to MySQL, and I need TP to generate the thumbnail fields. I have no idea how to do this with SQL scripts.
I want to convert a .tpdb8 with external thumbnail files to MySQL, and I need TP to generate the thumbnail fields. I have no idea how to do this with SQL scripts.
67
ThumbsPlus v7-v9 Questions / 3928 won't import .txt to MySQL
« on: 2013-06-28 04:38:01 »
Further investigation has revealed that the export format has changed for TP9 to that in my previous post.
TP8 used the same format as TP7, a basic csv layout with column headers in the first line and then one line per thumbnail.
I have run some tests and TP9 can't import a TP8 .txt file either. TP8 won't import the TP9 .txt, but as the format seems to have changed I am not surprised.
TP8 used the same format as TP7, a basic csv layout with column headers in the first line and then one line per thumbnail.
I have run some tests and TP9 can't import a TP8 .txt file either. TP8 won't import the TP9 .txt, but as the format seems to have changed I am not surprised.
68
ThumbsPlus v7-v9 Questions / 3928 won't import .txt to MySQL
« on: 2013-06-27 17:06:17 »
Have just checked and all annotations are null.
I don't know what the format should be, but there is something that strikes me as odd.
All of the fields have 3 sets of quotes, with the exception of metric1, metric2, md5 and thumbnail which only have 1.
This is the beginning of the file, up to the end of the first thumbnail (I have truncated the metrics and thumbnail fields so they fit on the page):-
idVol="""1"""
vtype="""3"""
serialno="""2900577186"""
maxcomplen="""255"""
vchar="""65470719"""
filesystem="""NTFS"""
label="""Data"""
netname="""\\AMD-3GHZ\d$"""
alias=""""""
idPath="""1"""
idVol="""1"""
pathtype="""1"""
name=""""""
idPath="""2"""
idVol="""1"""
pathtype="""1"""
name="""Users\Public\Pictures\Deb Train Meal"""
idThumb="""1"""
idPath="""1"""
idFiletype="""0"""
file_time_iso="""2007-11-07T08:00:40.000"""
thumbnail_time_iso="""2013-06-27T19:40:58.956"""
taken_time_iso=""""""
filelength="""5686"""
checksum="""4263651906"""
width="""96"""
height="""48"""
horiz_res="""2834"""
vert_res="""2834"""
colortype="""2"""
colordepth="""8"""
gamma="""0"""
thumbnail_width="""96"""
thumbnail_height="""48"""
thumbnail_type="""518"""
thumbnail_size="""311"""
idUser="""1"""
idHost="""1"""
name="""DSCF4924.JPG"""
rating="""0"""
xmp=""""""
metric1="00000000000000000000000000000"
metric2="00000000000000000000000000000"
md5="06fba95313f26e300917c6cea4480890"
thumbnail="ffd8ffe000104a46494600010100"
annotation=""""""
I don't know what the format should be, but there is something that strikes me as odd.
All of the fields have 3 sets of quotes, with the exception of metric1, metric2, md5 and thumbnail which only have 1.
This is the beginning of the file, up to the end of the first thumbnail (I have truncated the metrics and thumbnail fields so they fit on the page):-
idVol="""1"""
vtype="""3"""
serialno="""2900577186"""
maxcomplen="""255"""
vchar="""65470719"""
filesystem="""NTFS"""
label="""Data"""
netname="""\\AMD-3GHZ\d$"""
alias=""""""
idPath="""1"""
idVol="""1"""
pathtype="""1"""
name=""""""
idPath="""2"""
idVol="""1"""
pathtype="""1"""
name="""Users\Public\Pictures\Deb Train Meal"""
idThumb="""1"""
idPath="""1"""
idFiletype="""0"""
file_time_iso="""2007-11-07T08:00:40.000"""
thumbnail_time_iso="""2013-06-27T19:40:58.956"""
taken_time_iso=""""""
filelength="""5686"""
checksum="""4263651906"""
width="""96"""
height="""48"""
horiz_res="""2834"""
vert_res="""2834"""
colortype="""2"""
colordepth="""8"""
gamma="""0"""
thumbnail_width="""96"""
thumbnail_height="""48"""
thumbnail_type="""518"""
thumbnail_size="""311"""
idUser="""1"""
idHost="""1"""
name="""DSCF4924.JPG"""
rating="""0"""
xmp=""""""
metric1="00000000000000000000000000000"
metric2="00000000000000000000000000000"
md5="06fba95313f26e300917c6cea4480890"
thumbnail="ffd8ffe000104a46494600010100"
annotation=""""""
69
ThumbsPlus v7-v9 Questions / 3928 won't import .txt to MySQL
« on: 2013-06-27 12:51:53 »
Create empty MySQL database. Export from .tpbd8 with external thumbnails.
Import file to MySQL gives the error message "<5114> D:\Pictures\ThumbsTest.txt: Format error in file."
This happens for multiple databases, including one with only 6 thumbnails from one folder in.
Import file to MySQL gives the error message "<5114> D:\Pictures\ThumbsTest.txt: Format error in file."
This happens for multiple databases, including one with only 6 thumbnails from one folder in.
70
ThumbsPlus v7-v9 Questions / 3928 Export crashes on orphans
« on: 2013-06-27 12:46:56 »
tpdb8 database with external thumbnails, approx 1.8 million lines.
Export to .txt TP crashes after a couple of minutes. Examine the generated .txt and the last enry it was working on was an orphan.
Remove that orphan, run again and it crashes a bit further on, again on an orphan.
Remove orphans from entire drive (all the files in this database are on the one drive) and it runs through as expected.
However the exported .txt won't import (see seperate thread).
Export to .txt TP crashes after a couple of minutes. Examine the generated .txt and the last enry it was working on was an orphan.
Remove that orphan, run again and it crashes a bit further on, again on an orphan.
Remove orphans from entire drive (all the files in this database are on the one drive) and it runs through as expected.
However the exported .txt won't import (see seperate thread).
71
ThumbsPlus v7-v9 Questions / Beware if you are submitting a crash report
« on: 2013-06-27 07:38:45 »
TP9 just crashed whilst doing an export, and offered to send a crash report to Cerious.
I had a look through the files it was going to send to see if there was anything that might have helped me to fix the problem myself.
In amongst the usual log and dump files was a .png. THIS IS A SCREEN DUMP OF EVERYTHING ON YOUR SCREENS (YES, BOTH OF THEM) AT THE TIME OF THE CRASH!
At the time I had my online banking open on my second monitor, and there for all to see was my full account details!
Now I am not suggesting that Cerious would take advantage of this, but it could be a potential security risk if the message was intercepted.
Before sending your crash report, either exclude the .png, or at the very least edit to redact any sensitive information.
I can see how a screen dump might be useful as fault diagnosis tool, but this is a serious breach of security and privacy.
Cerious can we please have the .png omitted by default, or at the very least a prominent warning on the crash dump submission form that the .png could contain personal information. The dump creates a new .png for each crash, so if it was deemed neccessary for Phillip to see it he could always request it later.
I had a look through the files it was going to send to see if there was anything that might have helped me to fix the problem myself.
In amongst the usual log and dump files was a .png. THIS IS A SCREEN DUMP OF EVERYTHING ON YOUR SCREENS (YES, BOTH OF THEM) AT THE TIME OF THE CRASH!
At the time I had my online banking open on my second monitor, and there for all to see was my full account details!
Now I am not suggesting that Cerious would take advantage of this, but it could be a potential security risk if the message was intercepted.
Before sending your crash report, either exclude the .png, or at the very least edit to redact any sensitive information.
I can see how a screen dump might be useful as fault diagnosis tool, but this is a serious breach of security and privacy.
Cerious can we please have the .png omitted by default, or at the very least a prominent warning on the crash dump submission form that the .png could contain personal information. The dump creates a new .png for each crash, so if it was deemed neccessary for Phillip to see it he could always request it later.
72
ThumbsPlus v7-v9 Questions / 3928 No database import
« on: 2013-06-27 07:15:12 »
Clicking on Database|Advanced|Import database... does absolutely nothing.
No menu, no dialog box, no error, nothing left in the log.
However adding the import command icon to a tool bar does work.
No menu, no dialog box, no error, nothing left in the log.
However adding the import command icon to a tool bar does work.
73
ThumbsPlus v7-v9 Questions / SQL Database Conversion: what is file_time_iso for?
« on: 2013-06-26 10:13:48 »
It is a while since I upgraded a large database, but I seem to remember that around a million lines took 3-4 hours, so your timings seem to be about right.
This does all seem to add up; the thumbnails are being modified within the database, which will be quick, but to read every image file header from the OS, and then write the time to the database is going to be VERY slow!
Afraid I can't help you with advice on stopping the process. I don't know what TP does with the file_time_iso field, and don't know what else there is left to do when it has finished that.
This does all seem to add up; the thumbnails are being modified within the database, which will be quick, but to read every image file header from the OS, and then write the time to the database is going to be VERY slow!
Afraid I can't help you with advice on stopping the process. I don't know what TP does with the file_time_iso field, and don't know what else there is left to do when it has finished that.
74
ThumbsPlus v7-v9 Questions / Client/Server Conversion fails instantly.
« on: 2013-06-24 18:48:25 »
It works for me, and I see no reason why it wouldn't work for anyone else as the database specification hasn't changed.
Of course it would be prudent to take a backup before you start, as this process is irreversable, and converts the database in place and doesn't make a copy, unlike the conversion of the .td4 database.
Of course it would be prudent to take a backup before you start, as this process is irreversable, and converts the database in place and doesn't make a copy, unlike the conversion of the .td4 database.
75
ThumbsPlus v7-v9 Questions / Client/Server Conversion fails instantly.
« on: 2013-06-24 11:47:57 »
The client/server conversion in TP9 hasn't been working since at least the first production release, and maybe even longer. I went from TP8 to 9 so didn't ahve to convert so didn't notice this right away.
A workround is to download and install TP8 and do the conversion in that; TP8 and 9 databases are the same format.
A workround is to download and install TP8 and do the conversion in that; TP8 and 9 databases are the same format.