ThumbsPlus

All forums => ThumbsPlus v10 Questions => Topic started by: YvesDurand on 2016-10-07 04:59:02

Title: Database error when doing a search
Post by: YvesDurand on 2016-10-07 04:59:02

I am trying to switch from TP V6 to TP V10 (evaluation).

I have translated my database from .td4 to .tdps8 successfully.
 
But when I attempt to do a search using  the new tdps8 database, I get a long sequence of errors.

 As soon as I go Ctrl-F, the following happens:

Database error:

[Microsoft] [ODBC Microsoft Access Driver]

The Microsoft Jet database engine cannot find the input table or query 'FindCriteria'.

 Make sure it exists and that its name is spelled correctly..

ThumbsPlus Message <5015-8033>

I tried to do a database repair but the problem is still there.

The problem does not occur if I use a brand new Database.

Any idea ?

Title: Database error when doing a search
Post by: Daan van Rooijen on 2016-10-07 08:41:08

> Any idea ?

Wow, that sounds like ThumbsPlus is forgetting to add that table when it converts a .TD4 database!

If you would like to fix this manually:

Download and install Alex Nolan's excellent and free [link=http://www.alexnolan.net/software/mdb_viewer_plus.htm]MDB Viewer Plus[/link]

• Open the .tpdb8 database in MDB Viewer Plus
• Click on the Tables button
• Click New
• Enter the desired Table Name and the Field Names, Data Types and Field Sizes exactly as in the image below, and make 'key' the Primary Key.
• Click Create to finish this operation.

(http://images/uploaded/2016100712381257f7973454c30.jpg)

Note 1: To be safe, keep a backup of your original database!
Note 2: A full specification of the ThumbsPlus 8/9/10 database structure in PDF format is available [link=https://dl.dropboxusercontent.com/u/11281844/ThumbsPlus-9-database-structure.pdf]HERE[/link].

Title: Database error when doing a search
Post by: Pete Wieland on 2016-10-07 08:52:35

I had just typed pretty much the same reply and noticed you beat me to it Daan before I hit 'Submit'!

It might be worth comparing the converted database to a new tpdb8 as other tables may have been missed that aren't immediately obvious. Some of the tables are used 'on the fly' only for certain functions, typically search results and user fields, and if they were missing wouldn't produce an error until you tried to use the function, as with search.

Title: Database error when doing a search
Post by: YvesDurand on 2016-10-08 10:20:24

Thank you Daan,

I had to create another table named FoundThumbs.

I used the following statements :

CREATE TABLE FindCriteria (   [idList] INTEGER,   [key] TEXT(255) Primary Key,   [value] MEMO)
CREATE TABLE  FoundThumbs (   [idList] INTEGER ,   [idThumb] INTEGER ,   [flags] INTEGER)
ALTER    TABLE FoundThumbs PRIMARY KEY(idList ,idThumb)

The find command is incredibly fast !

Thanks again

Title: Database error when doing a search
Post by: Daan van Rooijen on 2016-10-08 14:18:04

Hi Pete and Yves,

Good to hear that it worked. Do you think all missing tables have now been identified?
(If so, I'll report it to Cerious)