[typo] Migrate Problems
cyril.mougel at gmail.com
Mon Aug 20 11:30:48 EDT 2007
On 8/20/07, Mitch Pirtle <mitch at spacemonkeylabs.com> wrote:
> Quoting James Carscadden <james at carscadden.org>, who spaketh thusly:
> > Hi folks..,
> > I'm trying to upgrade from an old typo (4.0.3) to the new 4.1.1
> > having problems in the db:migrate though.
> > Specifically:
> > == CleanupContentsTable: migrating
> > ============================================
> > -- remove_index(:contents, :article_id)
> > -- remove_column(:contents, :article_id)
> > rake aborted!
> > SQLite3::SQLException: table contents has no column named article_id:
> > CREATE INDEX "altered_contents_article_id_index" ON contents
> > ("article_id")
> > Obviously I'm using SQLite database.
> That error is because SQLite is trying to create an index for a column
> that doesn't exist in your database.
> My experience with SQLite in the past was similar, and when I switched
> to a different database (didn't matter what) everything worked again.
> Experimentation taught me that SQLite doesn't like SQL statements that
> alter tables or columns - or at least doesn't like them as much as
> other DBMS.
If it's this bug. I Think that a bug report and Patch totest the Type
Database it's good.
More information about the Typo-list