Should have read up on integrity_check before posting the results... I re-worked my tool and here is the output:

pragma integrity_check;

*** in database main ***
On tree page 11 cell 0: Rowid 424 out of order
wrong # of entries in index sqlite_autoindex_messages_priority_1
**2 rows returned**



On 2/13/2017 11:58 AM, R Smith wrote:
Could you run and post the output of your tool to the following two queries please:

pragma integrity_check;

select '<'||id||'>',created from messages_priority order by id limit ;


Thanks,
Ryan


On 2017/02/13 7:32 PM, Jeff B. wrote:
Hi Everyone,

Sorry for the strange subject, but the situation I'm facing is so odd that I wasn't even sure how to summarize it. First, a little context: I'm using v1.0.104 of System.Data.SQLite.Core in my C#/.NET 4.5 project. I have a table that is created as follows....//

_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to