Diagnose problem

[Richard McCoy]

One other thing, just noticed. I can unselect "Unique" and "Index"  in 
studio and it appears to solve the problem. The diagnose comes back clean. 
However, when I try to check the "Unique" setting again I get the error 
message attached. Any way to resolve this?

Thanks.


----- Original Message ----- 
From: "Ruslan Zasukhin" <ruslan_zasukhin at valentina-db.com>
To: <valentina at lists.macserve.net>
Sent: Friday, August 07, 2009 4:11 PM
Subject: Re: Diagnose problem


> On 8/7/09 11:01 PM, "Richard McCoy" <mcrmedia1 at insightbb.com> wrote:
>
> Hi Richard,
>
> * This list do not allow attachments, so I do not see them.
>
> * your table keep plain english ?
>
> * you can try CLONE DB, to try repair it.
>
> Let me know. May be send DB offlist in ZIP
>
>
>> Okay, I've gone into Valentina Studio 4 and used the query:
>>
>> select * from Kwrd_List where KwrdName = 'Concert'
>>
>> and get no results. But the word "Concert" is record 2148 and is clearly
>> visible in the table. Using the following query I can get all words 
>> beginning
>> with "C", including "Concert":
>>
>> select KwrdName from Kwrd_List where substring (upper(KwrdName) from 1 
>> for 1 =
>> 'C'
>>
>> I can add the word "Concert" to the table as record 2187. Now I have the 
>> word
>> "Concert" in the table as record 2148 AND 2187, even though the field is 
>> set
>> to Unique and should not allow redundancies.
>>
>> Do I simply have a corrupt table? What gives? Reindexing does nothing. 
>> Any
>> work arounds? I can't rebuild the table from scratch because other 
>> records are
>> dependent on the table RecIDs. Any suggestion would be appreciated.
>>
>> Thanks.
>>   ----- Original Message -----
>>   From: Richard McCoy
>>   To: Richard McCoy ; Valentina Developers
>>   Sent: Friday, August 07, 2009 3:43 PM
>>   Subject: Re: Diagnose problem
>>
>>
>>   Since sending this post I've been testing and discovered that there is 
>> a
>> problem. Some words are not recognized in the table with basic queries 
>> even
>> though they are in the table. When adding the word again it is appended 
>> to the
>> table with a new RecID even though it already exists and the table is set 
>> to
>> UNIQUE. This absolutely should NEVER happen!
>>
>>   Any idea why a unique field would allow redundant entries of a single 
>> word?
>> If Valentina allows for redundancies such as this then my entire keyword
>> indexing system falls apart.
>>
>>   Thanks.
>>     ----- Original Message -----
>>     From: Richard McCoy
>>     To: Valentina Developers
>>     Sent: Friday, August 07, 2009 9:34 AM
>>     Subject: Diagnose problem
>>
>>
>>     Including the diagnose report for this table. This is a table with 
>> one
>> field named "KwrdName" that is set to be Unique. Its purpose is to 
>> collect
>> keywords entered into the system by users without redundancy. When I 
>> diagnose
>> the entire database, everything comes back OK except this field (see
>> attachment).
>>
>>     I've reindexed this field and the table and also cloned and reloaded 
>> the
>> entire database. Nothing seems to work in resolving this reported 
>> discrepancy.
>>
>>     You'll notice from the provided JPGs that the record count is 
>> correct. No
>> records have ever been deleted from this field. However, the error report
>> indicates 74 missing records. The Index count differs from the field 
>> record
>> count.
>>
>>     Field: KwrdName. Index record count (2112) differ from field one 
>> (2186).
>>     Field: KwrdName. Index have 74 missing records.
>>
>>     This doesn't appear to affect the database record retrieval in any 
>> way and
>> I haven't noticed any problems. But is this something to be concerned 
>> about?
>> If so, how can I correct the problem. Have no idea why the index should 
>> be
>> reporting missing records when the record count for the field is entirely
>> accurate.
>>
>>
>>     Thanks.
>>
>>     Richard McCoy
>>     Executive Creative Director
>>     MCR Media Associates, LLC
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>
> -- 
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Kernel Error.jpg
Type: image/jpeg
Size: 19348 bytes
Desc: not available
Url : http://lists.macserve.net/pipermail/valentina/attachments/20090807/52eeabbb/attachment-0001.jpg