[Radiant] Import_export module problem

[Jamey Cribbs]

I had a similar problem recently.  IIRC, the import rake task is doing
a remigrate, which is basically a migrate VERSION=0, followed by a
migrate.  Well, this resets the extension_meta table (or whatever its
called) that holds the migration level that all the extensions are at.
 Then the import task does a migrate:extensions.  Well, since the
extension_meta table is reset, it tries to do all the extension
migrations from scratch.  But all of the extension tables never got
deleted, because a remigrate only messes with the radiant tables, not
any of the extension tables.  This is all from memory, so I may have
gotten it wrong.

Jamey


On Wed, Jun 4, 2008 at 6:51 AM, Stefan Urbanek <stefan at agentfarms.net> wrote:
> Hi,
>
> I am trying to use the import_export module:
>
> get production DB:
>    rake production db:export
> move it to local DB:
>    rake db:import
>
> on import I am getting:
>
> ...
> == 1 CreatePageAttachmentsExtensionSchema: migrating
> ==========================
> -- create_table("page_attachments")
> rake aborted!
> SQLite3::SQLException: table page_attachments already exists: CREATE TABLE
> page_attachments ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
> "content_type" varchar(255) DEFAULT NULL, "filename" varchar(255) DEFAULT
> NULL, "size" integer DEFAULT NULL, "parent_id" integer DEFAULT NULL,
> "thumbnail" varchar(255) DEFAULT NULL, "width" integer DEFAULT NULL,
> "height" integer DEFAULT NULL, "created_at" datetime DEFAULT NULL,
> "created_by" integer DEFAULT NULL, "updated_at" datetime DEFAULT NULL,
> "updated_by" integer DEFAULT NULL, "page_id" integer DEFAULT NULL)
>
> (See full trace by running task with --trace)
>
> I have same schemas on both environments - development and production.
>
> Any ideas what I might have wrong?
>
> Thanks,
>
> Stefan Urbanek
>
>
> _______________________________________________
> Radiant mailing list
> Post:   Radiant at radiantcms.org
> Search: http://radiantcms.org/mailing-list/search/
> Site:   http://lists.radiantcms.org/mailman/listinfo/radiant
>