if I create dump using sqlite3.5.4 and recreate DB using that dump data using sqlite3.5.4,everything works fine. if I create dump using sqlite3.5.4 and recreate DB using that dump data using sqlite3.6.15,gets error. Pls find attached file. The text generated from .dump command of sqlite3 version 3.5.4. CREATE TABLE Users ( ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT , name VARCHAR(50) NOT NULL COLLATE NOCASE, Page VARCHAR(255) NULL DEFAULT ("../xyz/main.asp") );
Changed text to CREATE TABLE Users ( ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT , name VARCHAR(50) NOT NULL COLLATE NOCASE, Page VARCHAR(255) NULL DEFAULT ('../xyz/main.asp') ); After changing everything seems to be fine. Thanks, -Kalyani -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of D. Richard Hipp Sent: Tuesday, June 16, 2009 12:23 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Sqlite3 database upgrade from 3.5.4 to 3.6.15 issue On Jun 16, 2009, at 3:10 PM, Kalyani Phadke wrote: > But before entering the bug , I would like to find out how this > happened. Whats the cause of it. Because I am not able to duplicate it > all the time. IS there any way to find out what went wrong? > Thanks, >> I have to go manually and edit sql ,make changes so that everything >> works fine. >> What do you have to manually edit to make it work. Please show us the text before and after you edit. D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users