Hi there, I'm trying to use import_export (a really useful extension if I could get it to work)and have seen that a number of people have experienced an error similar to this one, regarding importing users:
Creating Users...FAILED rake aborted! User expected, got Fixnum I've read Luca Erzegovesi's post on the subject: http://lists.radiantcms.org/pipermail/radiant/2007-June/005083.html but his workaround doesn't work for me. Is there any plan to fix this bug or should we look for alternatives to the import_export extension? Thanks Ramie Here's the full trace after successfuly exporting the data, using the command: $ rake --trace production db:import TEMPLATE=export.tml ** Invoke production (first_time) ** Execute production ** Invoke environment (first_time) ** Execute environment ** Invoke db:import (first_time) ** Invoke db:remigrate (first_time) ** Invoke environment ** Execute db:remigrate This task will destroy any data in the database. Are you sure you want to continue? [yn] y == AddOptimisticLocking: reverting ============================================ -- remove_column(:pages, :lock_version) -> 0.0029s -- remove_column(:layouts, :lock_version) -> 0.0023s -- remove_column(:snippets, :lock_version) -> 0.0020s -- remove_column(:users, :lock_version) -> 0.0018s == AddOptimisticLocking: reverted (0.0094s) =================================== == RenameConfigDefaultPartsKey: reverting ===================================== == RenameConfigDefaultPartsKey: reverted (0.0081s) ============================ == AddNotesFieldToUser: reverting ============================================= -- remove_column("users", "notes") -> 0.0016s == AddNotesFieldToUser: reverted (0.0018s) ==================================== == CreateExtensionMeta: reverting ============================================= -- drop_table("extension_meta") -> 0.0046s == CreateExtensionMeta: reverted (0.0048s) ==================================== == RenameTypeColumnOnPageToClassName: reverting =============================== -- rename_column("pages", "class_name", "type") -> 0.0014s == RenameTypeColumnOnPageToClassName: reverted (0.0016s) ====================== == MergeBehaviorsAndPages: reverting ========================================== -- rename_column(:pages, :type, :behavior_id) -> 0.0013s == MergeBehaviorsAndPages: converting class names back to behavior names ====== == MergeBehaviorsAndPages: reverted (0.0042s) ================================= == AddContentTypeFieldToLayout: reverting ===================================== -- remove_column("layouts", "content_type") -> 0.0016s == AddContentTypeFieldToLayout: reverted (0.0020s) ============================ == AddVirtualColumnToPageAgain: reverting ===================================== -- remove_column("pages", "virtual") -> 0.0019s == AddVirtualColumnToPageAgain: reverted (0.0021s) ============================ == RemoveVirtualColumnFromPage: reverting ===================================== -- add_column("pages", "virtual", :boolean, {:default=>false, :null=>false}) -> 0.0058s == RemoveVirtualColumnFromPage: reverted (0.0060s) ============================ == IntegerColumnsToBoolean: reverting ========================================= == IntegerColumnsToBoolean: saving User data ================================== -- remove_column("users", "admin") -> 0.0023s -- add_column("users", "admin", :integer, {:default=>0, :null=>false, :limit=>1}) -> 0.0062s == IntegerColumnsToBoolean: restoring User data =============================== == IntegerColumnsToBoolean: saving User data ================================== -- remove_column("users", "developer") -> 0.0025s -- add_column("users", "developer", :integer, {:default=>0, :null=>false, :limit=>1}) -> 0.0059s == IntegerColumnsToBoolean: restoring User data =============================== == IntegerColumnsToBoolean: reverted (0.0608s) ================================ == AddVirtualColumnToPage: reverting ========================================== -- remove_column("pages", "virtual") -> 0.0019s == AddVirtualColumnToPage: reverted (0.0020s) ================================= == RenameFilterColumn: reverting ============================================== -- rename_column(:page_parts, :filter_id, :filter) -> 0.0013s -- rename_column(:snippets, :filter_id, :filter) -> 0.0014s == RenameFilterColumn: reverted (0.0031s) ===================================== == RenameBehaviorColumn: reverting ============================================ -- rename_column(:pages, :behavior_id, :behavior) -> 0.0013s == RenameBehaviorColumn: reverted (0.0014s) =================================== == InsertInitialData: reverting =============================================== == InsertInitialData: reverted (0.0000s) ====================================== == CreateRadiantTables: reverting ============================================= -- drop_table("pages") -> 0.0041s -- drop_table("page_parts") -> 0.0047s -- drop_table("snippets") -> 0.0059s -- drop_table("layouts") -> 0.0050s -- drop_table("users") -> 0.0071s -- drop_table("config") -> 0.0047s == CreateRadiantTables: reverted (0.0326s) ==================================== ** Invoke db:migrate (first_time) ** Invoke environment ** Execute db:migrate ** Invoke db:schema:dump (first_time) ** Invoke environment ** Execute db:schema:dump == CreateRadiantTables: migrating ============================================= -- create_table("config", {:force=>true}) -> 0.0071s -- add_index("config", ["key"], {:unique=>true, :name=>"key"}) -> 0.0036s -- create_table("pages", {:force=>true}) -> 0.0097s -- create_table("page_parts", {:force=>true}) -> 0.0122s -- create_table("snippets", {:force=>true}) -> 0.0120s -- add_index("snippets", ["name"], {:unique=>true, :name=>"name"}) -> 0.0039s -- create_table("layouts", {:force=>true}) -> 0.0098s -- create_table("users", {:force=>true}) -> 0.0079s -- add_index("users", ["login"], {:unique=>true, :name=>"login"}) -> 0.0029s == CreateRadiantTables: migrated (0.0715s) ==================================== == InsertInitialData: migrating =============================================== == InsertInitialData: migrated (0.0000s) ====================================== == RenameBehaviorColumn: migrating ============================================ -- rename_column(:pages, :behavior, :behavior_id) -> 0.0013s == RenameBehaviorColumn: migrated (0.0015s) =================================== == RenameFilterColumn: migrating ============================================== -- rename_column(:page_parts, :filter, :filter_id) -> 0.0013s -- rename_column(:snippets, :filter, :filter_id) -> 0.0015s == RenameFilterColumn: migrated (0.0031s) ===================================== == AddVirtualColumnToPage: migrating ========================================== -- add_column("pages", "virtual", :boolean, {:default=>false, :null=>false}) -> 0.0060s == AddVirtualColumnToPage: migrated (0.0061s) ================================= == IntegerColumnsToBoolean: migrating ========================================= == IntegerColumnsToBoolean: saving User data ================================== -- remove_column("users", "admin") -> 0.0019s -- add_column("users", "admin", :boolean, {:default=>false, :null=>false}) -> 0.0057s == IntegerColumnsToBoolean: restoring User data =============================== == IntegerColumnsToBoolean: saving User data ================================== -- remove_column("users", "developer") -> 0.0019s -- add_column("users", "developer", :boolean, {:default=>false, :null=>false}) -> 0.0051s == IntegerColumnsToBoolean: restoring User data =============================== == IntegerColumnsToBoolean: migrated (0.0199s) ================================ == RemoveVirtualColumnFromPage: migrating ===================================== -- remove_column("pages", "virtual") -> 0.0023s == RemoveVirtualColumnFromPage: migrated (0.0024s) ============================ == AddVirtualColumnToPageAgain: migrating ===================================== -- add_column("pages", "virtual", :boolean, {:default=>false, :null=>false}) -> 0.0053s == AddVirtualColumnToPageAgain: migrated (0.0055s) ============================ == AddContentTypeFieldToLayout: migrating ===================================== -- add_column("layouts", "content_type", :string, {:limit=>40}) -> 0.0016s == AddContentTypeFieldToLayout: migrated (0.0017s) ============================ == MergeBehaviorsAndPages: migrating ========================================== == MergeBehaviorsAndPages: converting behavior names to class names =========== -- rename_column(:pages, :behavior_id, :type) -> 0.0013s == MergeBehaviorsAndPages: migrated (0.0034s) ================================= == RenameTypeColumnOnPageToClassName: migrating =============================== -- rename_column("pages", "type", "class_name") -> 0.0015s == RenameTypeColumnOnPageToClassName: migrated (0.0017s) ====================== == CreateExtensionMeta: migrating ============================================= -- create_table("extension_meta", {:force=>true}) -> 0.0384s == CreateExtensionMeta: migrated (0.0386s) ==================================== == AddNotesFieldToUser: migrating ============================================= -- add_column("users", "notes", :text) -> 0.0045s == AddNotesFieldToUser: migrated (0.0047s) ==================================== == RenameConfigDefaultPartsKey: migrating ===================================== == RenameConfigDefaultPartsKey: migrated (0.0020s) ============================ == AddOptimisticLocking: migrating ============================================ -- add_column(:pages, :lock_version, :integer, {:default=>0}) -> 0.0036s -- add_column(:layouts, :lock_version, :integer, {:default=>0}) -> 0.0043s -- add_column(:snippets, :lock_version, :integer, {:default=>0}) -> 0.0032s -- add_column(:users, :lock_version, :integer, {:default=>0}) -> 0.0036s == AddOptimisticLocking: migrated (0.0156s) =================================== ** Invoke db:schema:dump ** Invoke db:schema:dump ** Execute db:import Creating Users...FAILED rake aborted! User expected, got Fixnum /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/vendor/rails/activerecord/li b/active_record/associations/association_proxy.rb:148:in `raise_on_type_mismatch' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/vendor/rails/activerecord/li b/active_record/associations/belongs_to_association.rb:22:in `replace' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/vendor/rails/activerecord/li b/active_record/associations.rb:908:in `created_by=' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/vendor/rails/activerecord/li b/active_record/base.rb:1672:in `send' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/vendor/rails/activerecord/li b/active_record/base.rb:1672:in `attributes=' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/vendor/rails/activerecord/li b/active_record/base.rb:1671:in `each' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/vendor/rails/activerecord/li b/active_record/base.rb:1671:in `attributes=' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/vendor/rails/activerecord/li b/active_record/base.rb:1505:in `initialize_without_callbacks' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/vendor/rails/activerecord/li b/active_record/callbacks.rb:225:in `initialize' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/lib/radiant/setup.rb:144:in `new' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/lib/radiant/setup.rb:144:in `create_records' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/lib/radiant/setup.rb:143:in `each' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/lib/radiant/setup.rb:143:in `create_records' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/lib/radiant/setup.rb:204:in `step' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/lib/radiant/setup.rb:142:in `create_records' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/lib/radiant/setup.rb:191:in `feedback' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/lib/radiant/setup.rb:138:in `create_records' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/lib/radiant/setup.rb:137:in `each' /usr/local/lib/ruby/gems/1.8/gems/radiant-0.6.2/lib/radiant/setup.rb:137:in `create_records' /Users/ramie/Documents/work/SVNProjectsRoot/abg-cms/config/../vendor/extensi ons/import_export/lib/tasks/import_export_extension_tasks.rake:23:in `send' /Users/ramie/Documents/work/SVNProjectsRoot/abg-cms/config/../vendor/extensi ons/import_export/lib/tasks/import_export_extension_tasks.rake:23 /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `call' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `each' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:392:in `execute' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:362:in `invoke' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `synchronize' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:355:in `invoke' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in `top_level' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in `each' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1739:in `top_level' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1761:in `standard_exception_handling' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1733:in `top_level' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1711:in `run' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1761:in `standard_exception_handling' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/lib/rake.rb:1708:in `run' /usr/local/lib/ruby/gems/1.8/gems/rake-0.7.3/bin/rake:7 /usr/local/bin/rake:16:in `load' /usr/local/bin/rake:16 _______________________________________________ Radiant mailing list Post: [email protected] Search: http://radiantcms.org/mailing-list/search/ Site: http://lists.radiantcms.org/mailman/listinfo/radiant
