Fredrik,

At the beginning of using the database, I had filled the tool "Ignore when sorting" with many prefixes ( Le, La, Les, L', Un, Una, Der, Die, Das, and many others )

A first problem was with L' : In french it's attached to the next word ( without space ), sample :
L'affaire Baldwin ( in english : The Baldwin Affair ). I should enter and record the book first, and then re-open the book to edit manually the Title sort to obtain : Affaire Baldwin, L'

Same with different languages in the same database :same words means diffent things :

French:
Il tue son voisin ( in english : He kills his neighbour ) : it's classed under the letter i

Italian :
Il prezzo del silenzio ( in english : The price of the silence ) : it's classed under the letter p

The only way to do it was to edit manually the Title sort

The second problem was when I updated Bookcat to 10.14 ( it never happened before with previous upgrades, and I use Bookcat since 2005 ) :
Most of my manually editions of Title Sort turned back automatically to the default sorting :

Sample with Un, Una,...


I'm really disappointed ! I must now re-edit all the database ( nearly 14.000 books ) one by one and without being sure it will not happen again when future updates.

It did not happened in the sorting order of Series or Persons : another Sample :



Do you have any idea what happened ? and to avoid such things for the future ?

Hi

Looking at your sample for Un, Una etc, it appears that you have lost the Title Sort information altogether.

I've checked my database & my Title Sort is still there correctly, so I don't know why yours has gone. I know my Title Sort order has extensive changes done to it - magazines entered as 01 for January issue, 02 for February etc, for starters. It would be a pain to have to recreate that.


Actually no, I do have a problem with the sort order, in that the numerical replacement of the month number as stated above has disappeared and I'm back to an alphabetical listing of the months.

So, I agree something has broken with BookCAT.

Kevin Martin

I have not heard of this happening before. Could be the database is corrupted. What version did you use before 10.14?

Hi Fredrik

I have run Tools > Repair database & the problem has gone. I wonder if the last update somehow corrupted the sort title field & repairing has fixed it?


Kevin Martin

Could have been a corrupt index. "Repair db" will recreate all indexes.

Fredrick,

This Week-end, I tried to understand what happened. And I finally remembered what I did the week before.
I launched a "Database Maintenance" and it was "Update Title Sort" ( of course ! ) that caused the mess.
I tried again with new datas and personal title sort : That same operation came to the same result.

One idea for new versions ( and for newcomers to the software ) would be alarm warning :
"Pay attention, when updating title sort, you'll loose your personal sort" ( or something just like this ).

To fix titles starting with L' you can use the SqlUpdate add-on to update the Title Sort field:

1. Backup your database.

2. Download and run http://www.fnprg.com/dl/sqlupdate.exe

3. Click the ... button and select your database.

4. Run this SQL Update query:


This will move L' to the end of the title, and make the first letter upper case.

It works very well, thanks !

I must remember and never forget : never "update title sort " ( maintenance )