Re: [sqlite] Database schema has changed?

2011-09-13 Thread Brad Stiles
> Mmmm. Looks like there's no elegant way to do it. I looked into this a couple > of years ago when designing the setup. So: > > 1) Leave things as they are. Downside is the unexplained error every few > months and it's a slightly clumsy method. Upside is if the schema changes > there's no

Re: [sqlite] Database schema has changed?

2011-09-13 Thread Tim Streater
On 13 Sep 2011 at 17:03, Simon Slavin wrote: > On 13 Sep 2011, at 4:38pm, Tim Streater wrote: > >> In general the row could get moved around any number of databases and then >> back to the original one. > > That's one reason I think making absid unique then manually

Re: [sqlite] Database schema has changed?

2011-09-13 Thread Gerry Snyder
On 9/13/2011 8:38 AM, Tim Streater wrote: I don't see an easy way of solving conflicting absids. The hard way of solving this is to select all the fields of the messages table explicitly (except absid), so I can then insert them into a new row in the destination table. But I'm trying to avoid

Re: [sqlite] Database schema has changed?

2011-09-13 Thread Simon Slavin
On 13 Sep 2011, at 4:38pm, Tim Streater wrote: > In general the row could get moved around any number of databases and then > back to the original one. That's one reason I think making absid unique then manually manipulating absid values is a bad idea. Labelling which system each row

Re: [sqlite] Database schema has changed?

2011-09-13 Thread Tim Streater
On 13 Sep 2011 at 13:04, Simon Slavin wrote: > On 13 Sep 2011, at 12:13pm, Tim Streater wrote: > >> SQLite error: general code: HY000 error: 17, database schema has changed >> >> and since all the rest of the time the code works fine I'm having some >> trouble pinning

Re: [sqlite] Database schema has changed?

2011-09-13 Thread Simon Slavin
On 13 Sep 2011, at 12:13pm, Tim Streater wrote: > SQLite error: general code: HY000 error: 17, database schema has changed > > and since all the rest of the time the code works fine I'm having some > trouble pinning down whether it's my bug (more likely) and if so where, or an > SQLite bug

Re: [sqlite] Database schema has changed?

2011-09-13 Thread Igor Tandetnik
Tim Streater wrote: > I'm using the PDO interface in PHP and what I do is ($dbh is a handle to the > source database): > > $dbh->query ("attach database ':memory:' as mem"); > $dbh->query ($create_messages); // Create the messages table in > the memory

[sqlite] Database schema has changed?

2011-09-13 Thread Tim Streater
About once every few months I get this error (under OS X 10.7.1): SQLite error: general code: HY000 error: 17, database schema has changed and since all the rest of the time the code works fine I'm having some trouble pinning down whether it's my bug (more likely) and if so where, or an

Re: [sqlite] "SQLite Database schema has changed" error

2009-06-18 Thread D. Richard Hipp
On Jun 18, 2009, at 9:22 AM, manohar s wrote: > Hi, > > I am using SQLite 3.6.13, After issuing a vaccuum, I am inserting > into the > SQLite db, that time I am getting "SQLite Database schema has changed" > error. > > According to this: > http://www.mai

[sqlite] "SQLite Database schema has changed" error

2009-06-18 Thread manohar s
Hi, I am using SQLite 3.6.13, After issuing a vaccuum, I am inserting into the SQLite db, that time I am getting "SQLite Database schema has changed" error. According to this: http://www.mail-archive.com/sqlite-users@sqlite.org/msg04902.html, It should never occur in SQLite 3.0

Re: [sqlite] database schema has changed

2005-06-02 Thread D. Richard Hipp
On Thu, 2005-06-02 at 15:11 +0100, Ben Clewett wrote: > The posting seemed to indicate a user was experiencing the 'database > schema has changed' during the first INSERT after a VACUUM. > > The suggested solution was to close/open the db after the VACUUM. > I do not know who suggested a

Re: [sqlite] database schema has changed

2005-06-02 Thread Ben Clewett
Tito Ciuro wrote: Hi Ben, What do you mean? Try to reopen the database after VACUUM. That should do it... The posting seemed to indicate a user was experiencing the 'database schema has changed' during the first INSERT after a VACUUM. The suggested solution was to close/open the db after

Re: [sqlite] database schema has changed

2005-06-02 Thread Demitri Muna
On the subject of "database schema has changed" error messages I'm getting the same whenever I try to use precompiled queries in 3.2.1. Is anyone else seeing the same thing? Is there a reason that this should be happening? Taking the time to close/reopen the db seems to defeat the

[sqlite] database schema has changed

2005-06-01 Thread Ben Clewett
Dear SQLite, I am experiencing a problem. Every so often, say one in 100,000 'SELECT' queries, I get this error: "database schema has changed" This is false, the schema has not changed. Can any person offer a reason why this might be, and possibly a solution to this problem? I am using

RE: [sqlite] DATABASE SCHEMA HAS CHANGED

2004-11-22 Thread mike cariotoglou
> In SQLite version 3.0, when a schema change occurs, SQLite > automatically goes back to step 1, rereads the schema, and > tries again. So you should never get an SQLITE_SCHEMA error > in version 3.0. Back in version 2.8, you could get an > SQLITE_SCHEMA error in some circumstances. When

Re: [sqlite] DATABASE SCHEMA HAS CHANGED

2004-11-20 Thread Randall Fox
On Sat, 20 Nov 2004 08:08:48 -0500, you wrote: >So to answer your questions: > > No, this is not a serious bug. You just need to be prepared to > reissue any SQL statement that returns SQLITE_SCHEMA. > > Yes, this issue is fixed in version 3.0. Thank you.. It seems the original poster

Re: [sqlite] DATABASE SCHEMA HAS CHANGED

2004-11-20 Thread D. Richard Hipp
Randall Fox wrote: I believe VACUUM changes the schema version numbering. After you VACUUM, your sqlite3 struct holds information about your previous database version. Solution: reopen the database and SQLite will pick up the new changes. After that, INSERT will not report an error (until you

Re: [sqlite] DATABASE SCHEMA HAS CHANGED

2004-11-20 Thread Randall Fox
>I believe VACUUM changes the schema version numbering. After you >VACUUM, your sqlite3 struct holds information about your previous >database version. Solution: reopen the database and SQLite will pick up >the new changes. After that, INSERT will not report an error (until you >VACUUM again,

Re: [sqlite] DATABASE SCHEMA HAS CHANGED

2004-11-19 Thread P. Morandi
Thank you Tito. I'll try it. Bye - Original Message - From: "Tito Ciuro" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 19, 2004 12:38 PM Subject: Re: [sqlite] DATABASE SCHEMA HAS CHANGED > Hello Paolo, > > On Nov 19, 2004, at 10:

Re: [sqlite] DATABASE SCHEMA HAS CHANGED

2004-11-19 Thread Tito Ciuro
Hello Paolo, On Nov 19, 2004, at 10:24, P. Morandi wrote: Hi everybody. After using VACUUM on a sqlite db, the first time I try to do an INSERT in a table (always the same table) I get the "DATABASE SCHEMA HAS CHANGED" error, but later queries have no problems, only the first one. If I don't

[sqlite] DATABASE SCHEMA HAS CHANGED

2004-11-19 Thread P. Morandi
Hi everybody. After using VACUUM on a sqlite db, the first time I try to do an INSERT in a table (always the same table) I get the "DATABASE SCHEMA HAS CHANGED" error, but later queries have no problems, only the first one. If I don't pack the db (no using of VACUUM) no problem. Does anyone have