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.
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
