On Fri, Apr 20, 2012 at 2:06 AM, wjzhhr wjzhhr <wjz...@gmail.com> wrote:
> help:database disk image is malformed > Hi, sqlite team: > Do you know "database disk image is malformed" how to happen??? > http://www.sqlite.org/howtocorrupt.html > I use sqlite3 as my web database, but today, it says "database disk > image is malformed" and I can't open my website. > > my localhost web site environment:xpsp3+apache2.2.21+php5.3.8+pdo_sqlite. > I found one table has two same ID,and ID's create statement > is:primary key autoincrement. I delete this ID, but then the previous > ID will become two same ID. It is strange. Then I delete the same ID, > but also have problem with next ID, see the attachment, you can use > sqlitespy.exe to open the attachment > database[tt_bad_one-table_less_data.sql]. you can use sql:select ID > from into_tttt, but can't use select * from into_tttt. > > Though this link: > http://hotfile.com/dl/153478413/b58e245/tt_bad_one-table_less_data.7z.html > , > you can download it. > > > Can you tell me how does this happen ?? How to solution this problem???? > > Thank you very much! > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
