Spree sample data fetch giving error on bundle exec rake db:seed

Question

Trying to get the sample data for my spree app. Used following steps:

bundle exec rake railties:install:migrations
bundle exec rake db:migrate
bundle exec rake db:seed
bundle exec rake spree_sample:load

but on bundle exec rake db:seed, the following error is thrown:

loading ruby /usr/local/rvm/gems/ruby-2.2.1/gems/spree_core-3.0.2/db/default/spree/countries.rb
rake aborted!
ActiveRecord::StatementInvalid: SQLite3::SQLException: near ",": syntax error: INSERT INTO spree_countries ("name", "iso3", "iso", "iso_name", "numcode", "states_required")
VALUES ('Andorra', 'AND', 'AD', 'ANDORRA', '020', 't') .. ('Zimbabwe', 'ZWE', 'ZW', 'ZIMBABWE', '716', 't');
/usr/local/rvm/gems/ruby-2.2.1/gems/sqlite3-1.3.10/lib/sqlite3/database.rb:91:in initialize' /usr/local/rvm/gems/ruby-2.2.1/gems/sqlite3-1.3.10/lib/sqlite3/database.rb:91:innew'
/usr/local/rvm/gems/ruby-2.2.1/gems/sqlite3-1.3.10/lib/sqlite3/database.rb:91:in prepare' /usr/local/rvm/gems/ruby-2.2.1/gems/sqlite3-1.3.10/lib/sqlite3/database.rb:134:inexecute'
/usr/local/rvm/gems/ruby-2.2.1/gems/activerecord-4.2.3/lib/active_record/connection_adapters/sqlite3_adapter.rb:329:in block in execute' /usr/local/rvm/gems/ruby-2.2.1/gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:473:inblock in log'
/usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/notifications/instrumenter.rb:20:in instrument' /usr/local/rvm/gems/ruby-2.2.1/gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:467:inlog'
/usr/local/rvm/gems/ruby-2.2.1/gems/activerecord-4.2.3/lib/active_record/connection_adapters/sqlite3_adapter.rb:329:in execute' /usr/local/rvm/gems/ruby-2.2.1/gems/spree_core-3.0.2/db/default/spree/countries.rb:24:in'
/usr/local/rvm/gems/ruby-2.2.1/gems/polyglot-0.3.5/lib/polyglot.rb:65:in require' /usr/local/rvm/gems/ruby-2.2.1/gems/polyglot-0.3.5/lib/polyglot.rb:65:inrequire'
/usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/dependencies.rb:274:in block in require' /usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/dependencies.rb:240:inload_dependency'
/usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/dependencies.rb:274:in require' /usr/local/rvm/gems/ruby-2.2.1/gems/spree_core-3.0.2/lib/tasks/core.rake:11:inblock (2 levels) in '
/usr/local/rvm/gems/ruby-2.2.1/gems/spree_core-3.0.2/lib/tasks/core.rake:30:in block (3 levels) in <top (required)>' /usr/local/rvm/gems/ruby-2.2.1/gems/spree_core-3.0.2/lib/tasks/core.rake:24:ineach'
/usr/local/rvm/gems/ruby-2.2.1/gems/spree_core-3.0.2/lib/tasks/core.rake:24:in block (2 levels) in <top (required)>' /usr/local/rvm/gems/ruby-2.2.1/gems/spree_core-3.0.2/db/seeds.rb:5:in'
/usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/dependencies.rb:268:in load' /usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/dependencies.rb:268:inblock in load'
/usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/dependencies.rb:240:in load_dependency' /usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/dependencies.rb:268:inload'
/usr/local/rvm/gems/ruby-2.2.1/gems/railties-4.2.3/lib/rails/engine.rb:547:in load_seed' /usr/local/rvm/gems/ruby-2.2.1/gems/railties-4.2.3/lib/rails/railtie.rb:194:inpublic_send'
/usr/local/rvm/gems/ruby-2.2.1/gems/railties-4.2.3/lib/rails/railtie.rb:194:in method_missing' /home/aparna/my_store/db/seeds.rb:10:in'
/usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/dependencies.rb:268:in load' /usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/dependencies.rb:268:inblock in load'
/usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/dependencies.rb:240:in load_dependency' /usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/dependencies.rb:268:inload'
/usr/local/rvm/gems/ruby-2.2.1/gems/railties-4.2.3/lib/rails/engine.rb:547:in load_seed' /usr/local/rvm/gems/ruby-2.2.1/gems/activerecord-4.2.3/lib/active_record/tasks/database_tasks.rb:250:inload_seed'
/usr/local/rvm/gems/ruby-2.2.1/gems/activerecord-4.2.3/lib/active_record/railties/databases.rake:180:in block (2 levels) in <top (required)>' SQLite3::SQLException: near ",": syntax error /usr/local/rvm/gems/ruby-2.2.1/gems/sqlite3-1.3.10/lib/sqlite3/database.rb:91:ininitialize'
/usr/local/rvm/gems/ruby-2.2.1/gems/sqlite3-1.3.10/lib/sqlite3/database.rb:91:in new' /usr/local/rvm/gems/ruby-2.2.1/gems/sqlite3-1.3.10/lib/sqlite3/database.rb:91:inprepare'
/usr/local/rvm/gems/ruby-2.2.1/gems/sqlite3-1.3.10/lib/sqlite3/database.rb:134:in execute' /usr/local/rvm/gems/ruby-2.2.1/gems/activerecord-4.2.3/lib/active_record/connection_adapters/sqlite3_adapter.rb:329:inblock in execute'
/usr/local/rvm/gems/ruby-2.2.1/gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:473:in block in log' /usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/notifications/instrumenter.rb:20:ininstrument'
/usr/local/rvm/gems/ruby-2.2.1/gems/activerecord-4.2.3/lib/active_record/connection_adapters/abstract_adapter.rb:467:in log' /usr/local/rvm/gems/ruby-2.2.1/gems/activerecord-4.2.3/lib/active_record/connection_adapters/sqlite3_adapter.rb:329:inexecute'
/usr/local/rvm/gems/ruby-2.2.1/gems/spree_core-3.0.2/db/default/spree/countries.rb:24:in <top (required)>' /usr/local/rvm/gems/ruby-2.2.1/gems/polyglot-0.3.5/lib/polyglot.rb:65:inrequire'
/usr/local/rvm/gems/ruby-2.2.1/gems/polyglot-0.3.5/lib/polyglot.rb:65:in require' /usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/dependencies.rb:274:inblock in require'
/usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/dependencies.rb:240:in load_dependency' /usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/dependencies.rb:274:inrequire'
/usr/local/rvm/gems/ruby-2.2.1/gems/spree_core-3.0.2/lib/tasks/core.rake:11:in block (2 levels) in <top (required)>' /usr/local/rvm/gems/ruby-2.2.1/gems/spree_core-3.0.2/lib/tasks/core.rake:30:inblock (3 levels) in '
/usr/local/rvm/gems/ruby-2.2.1/gems/spree_core-3.0.2/lib/tasks/core.rake:24:in each' /usr/local/rvm/gems/ruby-2.2.1/gems/spree_core-3.0.2/lib/tasks/core.rake:24:inblock (2 levels) in '
/usr/local/rvm/gems/ruby-2.2.1/gems/spree_core-3.0.2/db/seeds.rb:5:in <top (required)>' /usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/dependencies.rb:268:inload'
/usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/dependencies.rb:268:in block in load' /usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/dependencies.rb:240:inload_dependency'
/usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/dependencies.rb:268:in load' /usr/local/rvm/gems/ruby-2.2.1/gems/railties-4.2.3/lib/rails/engine.rb:547:inload_seed'
/usr/local/rvm/gems/ruby-2.2.1/gems/railties-4.2.3/lib/rails/railtie.rb:194:in public_send' /usr/local/rvm/gems/ruby-2.2.1/gems/railties-4.2.3/lib/rails/railtie.rb:194:inmethod_missing'
/home/aparna/my_store/db/seeds.rb:10:in <top (required)>' /usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/dependencies.rb:268:inload'
/usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/dependencies.rb:268:in block in load' /usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/dependencies.rb:240:inload_dependency'
/usr/local/rvm/gems/ruby-2.2.1/gems/activesupport-4.2.3/lib/active_support/dependencies.rb:268:in load' /usr/local/rvm/gems/ruby-2.2.1/gems/railties-4.2.3/lib/rails/engine.rb:547:inload_seed'
/usr/local/rvm/gems/ruby-2.2.1/gems/activerecord-4.2.3/lib/active_record/tasks/database_tasks.rb:250:in load_seed' /usr/local/rvm/gems/ruby-2.2.1/gems/activerecord-4.2.3/lib/active_record/railties/databases.rake:180:inblock (2 levels) in '
Tasks: TOP => db:load_dir
(See full trace by running task with --trace)

Any idea what should be done?

score 1 · Answer 1 · answered Aug 09 '15 at 05:12

oh spree.

there is something amiss with the sql statements generated in the country/states seed files.

here is my replacement, that is slower but works

spree_core/db/default/spree/countries.rb

require 'carmen'

Carmen::Country.all.map do |country|
  name = country.name
  iso3 = country.alpha_3_code
  iso = country.alpha_2_code
  iso_name = country.name.upcase
  numcode = country.numeric_code
  states_required = country.subregions?

  # country_inserts << [name, iso3, iso, iso_name, numcode, states_required].join(", ")
  Spree::Country.new(      :name => name,
      :iso3 => iso3,
      :iso => iso,
      :iso_name => iso_name,
      :numcode => numcode,
      :states_required => states_required
  ).save!
end

canada = Spree::Country.find_by(iso: "CA")
Spree::Config[:default_country_id] = canada.id

and

spree_core/db/default/spree/states.rb

connection = ActiveRecord::Base.connection
state_inserts = []

Spree::Country.where(states_required: true).each do |country|
  carmen_country = Carmen::Country.named(country.name)
  carmen_country.subregions.each do |subregion|
    name = connection.quote subregion.name
    abbr = connection.quote subregion.code
    country_id = connection.quote country.id

    state_inserts << [name, abbr, country_id].join(", ")
    Spree::State.new(:name => name, :abbr => abbr, :country_id => country_id).save!
  end
end

score 0 · Answer 2 · answered Oct 12 '15 at 05:52

Spree's specs usually use the latest SQLite version. I'm guessing this hasn't been caught since we never tested pre-3.7.11. I would say the issue is actually with the SQLite DB being out of date. I can't see Spree wanting to support an old version of SQLite.

I'm guessing you're DB is pre-3.7.11. If it is, can you update it?

Spree sample data fetch giving error on bundle exec rake db:seed

2 Answers2