Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Posted February 26, 2013 4:47am by

Scoping lesson - test errors

When I run the test after I put in another user and his information in the users.yml and the statuses.ym (also changed the @statuses = Status.all to @statuses = @user.statuses.all); I get a rather large error for all 4 tests running on my profiles_controller_test file:

1) Error: test_should_get_show(ProfilesControllerTest): ActiveRecord::Fixture::FormatError: ActiveRecord::Fixture::FormatError C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.6/lib/ active_record/fixtures/file.rb:60:in validate' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.6/lib/ active_record/fixtures/file.rb:47:inrows' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.6/lib/ active_record/fixtures/file.rb:29:in each' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.6/lib/ active_record/fixtures.rb:670:inblock (2 levels) in read_fixture_files' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.6/lib/ active_record/fixtures/file.rb:20:in open' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.6/lib/ active_record/fixtures.rb:669:inblock in read_fixture_files' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.6/lib/ active_record/fixtures.rb:668:in each' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.6/lib/ active_record/fixtures.rb:668:inread_fixture_files' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.6/lib/ active_record/fixtures.rb:548:in initialize' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.6/lib/ active_record/fixtures.rb:482:innew' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.6/lib/ active_record/fixtures.rb:482:in block (2 levels) in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.6/lib/ active_record/fixtures.rb:479:inmap' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.6/lib/ active_record/fixtures.rb:479:in block in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.6/lib/ active_record/connection_adapters/abstract_adapter.rb:168:indisable_referentia l_integrity' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.6/lib/ active_record/fixtures.rb:476:in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.6/lib/ active_record/fixtures.rb:895:inload_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.6/lib/ active_record/fixtures.rb:849:in setup_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.6/lib /active_support/callbacks.rb:429:inrun568588364setup591442292callback s' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.6/lib /active_support/callbacks.rb:405:in `_run_callback' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.6/lib /active_support/callbacks.rb:385:in _run_setup_callbacks' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.6/lib /active_support/callbacks.rb:81:inrun_callbacks' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.6/lib /active_support/testing/setup_and_teardown.rb:35:in `run'

Its the same message for the other tests (so 4 errors). Do I need to update gems in ruby? I can't find the syntax error if there is one.

3 Answers

February 27, 2013 10:07am

Hi Allan! We've let the teaching team know, so they'll respond to your question soon. :)

February 28, 2013 11:33pm

Hey Allan! That usually means you have a format error in your fixtures file. Try opening it up and changing any tabs to spaces. There should be a setting for this in your text editor. Hope that helps!

September 4, 2013 3:22am

I'm having the same problem and it's still not working - are there any other fixes? I'm doing the following lesson: Programming > Build a Simple Ruby on Rails Application > Writing Tests > Fixtures

Here is the error list:

C:\Sites\treebook>ruby -Itest test/unit/user_test.rb Run options:

Running tests:

EEEE

Finished tests in 0.128028s, 31.2432 tests/s, 0.0000 assertions/s.

1) Error: test_a_user_should_enter_a_first_name(UserTest): ActiveRecord::StatementInvalid: SQLite3::SQLException: table users has no column named password: INSERT INTO "users" ("first_name", "last_name", "email", "passw ord", "password_confirmation", "created_at", "updated_at", "id") VALUES ('Jason' , 'Seifer', 'jason@teamtreehouse.com', 'password', 'password', '2013-09-04 03:20 :02', '2013-09-04 03:20:02', 149087659) C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/sqlite3-1.3.8-x86-mingw 32/lib/sqlite3/database.rb:91:in initialize' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/sqlite3-1.3.8-x86-mingw 32/lib/sqlite3/database.rb:91:innew' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/sqlite3-1.3.8-x86-mingw 32/lib/sqlite3/database.rb:91:in prepare' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/sqlite3-1.3.8-x86-mingw 32/lib/sqlite3/database.rb:134:inexecute' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/sqlite_adapter.rb:278:in block in execute' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/abstract_adapter.rb:280:inblock in log' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/notifications/instrumenter.rb:20:in instrument' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/abstract_adapter.rb:275:inlog' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/sqlite_adapter.rb:278:in execute' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/abstract/database_statements.rb:277:ininser t_fixture' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:502:in block (5 levels) in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:501:ineach' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:501:in block (4 levels) in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:500:ineach' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:500:in block (3 levels) in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:492:ineach' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:492:in block (2 levels) in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/abstract/database_statements.rb:192:intrans action' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:491:in block in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/abstract_adapter.rb:168:indisable_referenti al_integrity' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:476:in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:895:inload_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:849:in setup_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/callbacks.rb:407:inrun942514381setup918249263callbac ks' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/callbacks.rb:405:in `_run_callback' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/callbacks.rb:385:in _run_setup_callbacks' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/callbacks.rb:81:inrun_callbacks' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/testing/setup_and_teardown.rb:35:in `run'

2) Error: test_a_user_should_enter_a_last_name(UserTest): ActiveRecord::StatementInvalid: SQLite3::SQLException: table users has no column named password: INSERT INTO "users" ("first_name", "last_name", "email", "passw ord", "password_confirmation", "created_at", "updated_at", "id") VALUES ('Jason' , 'Seifer', 'jason@teamtreehouse.com', 'password', 'password', '2013-09-04 03:20 :02', '2013-09-04 03:20:02', 149087659) C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/sqlite3-1.3.8-x86-mingw 32/lib/sqlite3/database.rb:91:in initialize' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/sqlite3-1.3.8-x86-mingw 32/lib/sqlite3/database.rb:91:innew' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/sqlite3-1.3.8-x86-mingw 32/lib/sqlite3/database.rb:91:in prepare' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/sqlite3-1.3.8-x86-mingw 32/lib/sqlite3/database.rb:134:inexecute' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/sqlite_adapter.rb:278:in block in execute' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/abstract_adapter.rb:280:inblock in log' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/notifications/instrumenter.rb:20:in instrument' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/abstract_adapter.rb:275:inlog' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/sqlite_adapter.rb:278:in execute' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/abstract/database_statements.rb:277:ininser t_fixture' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:502:in block (5 levels) in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:501:ineach' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:501:in block (4 levels) in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:500:ineach' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:500:in block (3 levels) in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:492:ineach' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:492:in block (2 levels) in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/abstract/database_statements.rb:192:intrans action' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:491:in block in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/abstract_adapter.rb:168:indisable_referenti al_integrity' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:476:in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:895:inload_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:849:in setup_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/callbacks.rb:407:inrun942514381setup918249263callbac ks' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/callbacks.rb:405:in `_run_callback' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/callbacks.rb:385:in _run_setup_callbacks' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/callbacks.rb:81:inrun_callbacks' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/testing/setup_and_teardown.rb:35:in `run'

3) Error: test_a_user_should_enter_a_profile_name(UserTest): ActiveRecord::StatementInvalid: SQLite3::SQLException: table users has no column named password: INSERT INTO "users" ("first_name", "last_name", "email", "passw ord", "password_confirmation", "created_at", "updated_at", "id") VALUES ('Jason' , 'Seifer', 'jason@teamtreehouse.com', 'password', 'password', '2013-09-04 03:20 :02', '2013-09-04 03:20:02', 149087659) C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/sqlite3-1.3.8-x86-mingw 32/lib/sqlite3/database.rb:91:in initialize' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/sqlite3-1.3.8-x86-mingw 32/lib/sqlite3/database.rb:91:innew' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/sqlite3-1.3.8-x86-mingw 32/lib/sqlite3/database.rb:91:in prepare' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/sqlite3-1.3.8-x86-mingw 32/lib/sqlite3/database.rb:134:inexecute' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/sqlite_adapter.rb:278:in block in execute' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/abstract_adapter.rb:280:inblock in log' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/notifications/instrumenter.rb:20:in instrument' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/abstract_adapter.rb:275:inlog' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/sqlite_adapter.rb:278:in execute' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/abstract/database_statements.rb:277:ininser t_fixture' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:502:in block (5 levels) in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:501:ineach' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:501:in block (4 levels) in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:500:ineach' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:500:in block (3 levels) in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:492:ineach' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:492:in block (2 levels) in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/abstract/database_statements.rb:192:intrans action' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:491:in block in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/abstract_adapter.rb:168:indisable_referenti al_integrity' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:476:in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:895:inload_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:849:in setup_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/callbacks.rb:407:inrun942514381setup918249263callbac ks' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/callbacks.rb:405:in `_run_callback' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/callbacks.rb:385:in _run_setup_callbacks' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/callbacks.rb:81:inrun_callbacks' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/testing/setup_and_teardown.rb:35:in `run'

4) Error: test_a_user_should_have_a_unique_profile_name(UserTest): ActiveRecord::StatementInvalid: SQLite3::SQLException: table users has no column named password: INSERT INTO "users" ("first_name", "last_name", "email", "passw ord", "password_confirmation", "created_at", "updated_at", "id") VALUES ('Jason' , 'Seifer', 'jason@teamtreehouse.com', 'password', 'password', '2013-09-04 03:20 :02', '2013-09-04 03:20:02', 149087659) C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/sqlite3-1.3.8-x86-mingw 32/lib/sqlite3/database.rb:91:in initialize' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/sqlite3-1.3.8-x86-mingw 32/lib/sqlite3/database.rb:91:innew' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/sqlite3-1.3.8-x86-mingw 32/lib/sqlite3/database.rb:91:in prepare' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/sqlite3-1.3.8-x86-mingw 32/lib/sqlite3/database.rb:134:inexecute' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/sqlite_adapter.rb:278:in block in execute' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/abstract_adapter.rb:280:inblock in log' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/notifications/instrumenter.rb:20:in instrument' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/abstract_adapter.rb:275:inlog' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/sqlite_adapter.rb:278:in execute' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/abstract/database_statements.rb:277:ininser t_fixture' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:502:in block (5 levels) in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:501:ineach' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:501:in block (4 levels) in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:500:ineach' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:500:in block (3 levels) in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:492:ineach' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:492:in block (2 levels) in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/abstract/database_statements.rb:192:intrans action' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:491:in block in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/connection_adapters/abstract_adapter.rb:168:indisable_referenti al_integrity' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:476:in create_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:895:inload_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activerecord-3.2.14/lib /active_record/fixtures.rb:849:in setup_fixtures' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/callbacks.rb:407:inrun942514381setup918249263callbac ks' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/callbacks.rb:405:in `_run_callback' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/callbacks.rb:385:in _run_setup_callbacks' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/callbacks.rb:81:inrun_callbacks' C:/RailsInstaller/Ruby1.9.3/lib/ruby/gems/1.9.1/gems/activesupport-3.2.14/li b/active_support/testing/setup_and_teardown.rb:35:in `run'

4 tests, 0 assertions, 0 failures, 4 errors, 0 skips

September 4, 2013 7:25pm

Remove the "password" and "password_confirmation" lines from your users.yml fixture and that should fix it.

October 16, 2013 7:48am

Hi, Allan..did you get a solution to your errors? I have the same error:(

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.

Welcome to the Treehouse Community

Looking to learn something new?

Allan Evans

Allan Evans

Scoping lesson - test errors

3 Answers

Faye Bridge

Faye Bridge

Jason Seifer

Jason Seifer

Ezra Okon

Ezra Okon

Running tests:

Jason Seifer

Jason Seifer

Muthuri Mutuma

Muthuri Mutuma