Index corruption on database close

[Steve Albin]

This issue has been resolved via the Mantis submission and it is quite simple.  The database was encoded using UTF-16BE.  Ivan suggested to clone the database and that solved the problem.  Easy!

The particular database was my personal database originally created years ago on a Mac 6500 which explains why it may have been using UTF-16BE.

Steve

--
Steve Albin, Montclair, NJ
http://www.steve-albin.com
http://www.jazzdiscography.com

On Jul 23, 2014, at 12:31 PM, Steve Albin <steve at steve-albin.com> wrote:

> I have 2 different databases where I can reproduce this error.   I have 2 other customer databases where I cannot reproduce this error no matter what I try.  All 4 databases have the same schema.   The error seems to be related to the actual data on the database.
> 
> At first, I assumed it was my code using V5RB, but I get this to happen in Valentina Studio so I know it is not my poor coding.
> 
> Steve
> 
> --
> Steve Albin, Montclair, NJ
> http://www.steve-albin.com
> http://www.jazzdiscography.com
> 
> On Jul 23, 2014, at 11:46 AM, Beatrix Willius <bwillius at gmx.de> wrote:
> 
>> Interesting...
>> 
>> I can reproduce the problem with ordering in Valentina Studio 5.5.8. But I don't see a corrupt index in the Diagnose. However, after re-indexing the order of the SQL query was okay again.
>> 
>> Correction: this is still VStudio 5.5.6 beta something from beginning of May.
>> 
>> On 22.07.2014, at 18:48, Steve Albin <steve at steve-albin.com> wrote:
>> 
>>> cCatnum is a VarChar of 100 bytes.  The cTitleIdx that I'm using along with it in the SQL is also VarChar and 504 bytes.  
>>> 
>>> I submitted a Mantis report that has a link to a copy of my database if you would like to have a look.  My situation is reproducable with that database and one other that I had, but oddly, not with a third different database.  The only thing I could see on the third database was that there were very few duplicate fields.
>> 
>> Mit freundlichen Grüßen/Regards
>> 
>> Trixi Willius
>> 
>> http://www.mothsoftware.com
>> Mail Archiver X: The email archiving solution for professionals
>> 
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>