FTS expression tree is too large message

Post Reply
simato73
Posts: 56
Joined: 27 Nov 16 22:10

FTS expression tree is too large message

Post by simato73 »

I get the title message when I try to compress the catalog.
I know there is another old thread mentioning FTS expression tree is too large, but the context seems to be different.
I haven't deleted or moved files outside recently, which could have caused the message.

While I could live ignoring it, I suspect it is not a good thing, if this means it is no longer to periodically compact the catalog.
If anyone has any suggestion of how to fix this issue it would be much appreciated.

Thanks,
Simone
Simone
simato73
Posts: 56
Joined: 27 Nov 16 22:10

Re: FTS expression tree is too large message

Post by simato73 »

I just found out in the last import I mistakenly used a dash - instead of an underscore _ in my naming.
That is probably what has caused the message, will confirm when I have batch renamed the files.
Simone
simato73
Posts: 56
Joined: 27 Nov 16 22:10

Re: FTS expression tree is too large message

Post by simato73 »

That was definitely not the reason. There are plenty of other files containing a dash in the name and in the past it has not been a problem.
I keep having the same problem compressing the catalog.

Any suggestion of what could I try to trace the origin of the problem and fix it?

Thanks,
Simone
Simone
Hert
Posts: 7870
Joined: 13 Sep 03 6:24

Re: FTS expression tree is too large message

Post by Hert »

Did you try this with the latest build?
This is a user-to-user forum. If you have suggestions, requests or need support then please send a message
simato73
Posts: 56
Joined: 27 Nov 16 22:10

Re: FTS expression tree is too large message

Post by simato73 »

Hi Hert,

Sorry I was away on holidays.
I update the software promptly whenever there is a notification.
The error message above remained throughout July, it appeared every time I tried to compact the database.

Today as I returned from holidays I got notification of an update and updated to the latest, which required updating the catalog.
Unfortunately I was too stupid to remember doing a backup and now I am stuck.

I got the error message below:
Screenshot 2022-08-01 at 19.41.49.png
Screenshot 2022-08-01 at 19.41.49.png (44.44 KiB) Viewed 2905 times
to which for the moment I said abort.

I tried roll back to a previous version of PSu, but I cannot because this catalog is not backward compatible and as I said I have no backup.

Any suggestion on what I should do is highly appreciated - if possible bearing in mind that I am not that competent...
Simone
Hert
Posts: 7870
Joined: 13 Sep 03 6:24

Re: FTS expression tree is too large message

Post by Hert »

Please share the catalog database. Only the cat.db is needed, not the thumbs.db.
Best to upload a ZIPPED copy of the cat.db file to your cloud space and send a download link to support@idimager.com.
This is a user-to-user forum. If you have suggestions, requests or need support then please send a message
simato73
Posts: 56
Joined: 27 Nov 16 22:10

Re: FTS expression tree is too large message

Post by simato73 »

Thank you Hert!
I have just sent a link by email.
Simone
simato73
Posts: 56
Joined: 27 Nov 16 22:10

Re: FTS expression tree is too large message

Post by simato73 »

All problems solved, thank you Hert.
The catalog is larger than before, but not excessively so.
Simone
Post Reply