On Mar 11, 2010, at 12:18 PM, Skand wrote:
>>
>> Run REINDEX on your database.
>>
>> Get SQLite 3.6.23 and use that in place of 3.3.6 moving forward.
>>
>
> REINDEX throws following error:
>
> SQL error: indexed columns are not unique
>
> Is there a graceful way to fix this?
Run
sqlite3 olddatabase >file.txt
Then edit file.txt to remove the duplicate entries. Then:
sqlite3 newdatabase <file.txt
> Can you hypothesize the cause for this
> error given that the schema specifies that the primary key consists
> of all 3
> columns in the database?
http://www.sqlite.org/lockingv3.html#how_to_corrupt
D. Richard Hipp
d...@hwaci.com
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
