I have been running Sqlite on Linux and Windows for about 5 years now and in the last two weeks or so I have reinstalled roughly 5-10 times because of this issue. Sqlite is turning out to be less reliable than other systems (they all have some issues) it is frustrating when you lose serious time involved in producing quality work. I think I may just concentrate on using MySQL for now or even the forbidden Sql Server might just do for now but SQLite has some frustrating issues such as this one.