September 16 First thing in the morning run

gistfile1.txt

Finished in 213.104354756 seconds.

  1) Error:
test_import_entity(EntitiesTest):
ActiveRecord::StatementInvalid: PG::SyntaxError: ERROR:  syntax error at or near "["
LINE 1: ...t_formats"."entity_id" IN (1,61,62,63))  ORDER BY ["entities...
                                                             ^
: SELECT "receipt_formats"."id" AS t0_r0, "receipt_formats"."name" AS t0_r1, "receipt_formats"."info" AS t0_r2, "receipt_formats"."entity_id" AS t0_r3, "receipt_formats"."created_by" AS t0_r4, "receipt_formats"."create_method" AS t0_r5, "receipt_formats"."created_on" AS t0_r6, "receipt_formats"."modified_by" AS t0_r7, "receipt_formats"."updated_on" AS t0_r8, "receipt_formats"."activate_at" AS t0_r9, "receipt_formats"."version_id" AS t0_r10, "receipt_formats"."status_id" AS t0_r11, "receipt_formats"."max_messages" AS t0_r12, "receipt_formats"."dv_base" AS t0_r13, "receipt_formats"."dv_base_alt" AS t0_r14, "receipt_formats"."min_messages" AS t0_r15, "receipt_formats"."max_length" AS t0_r16, "receipt_formats"."min_length" AS t0_r17, "entities"."id" AS t1_r0, "entities"."entity_type_id" AS t1_r1, "entities"."name" AS t1_r2, "entities"."info" AS t1_r3, "entities"."enterprise" AS t1_r4, "entities"."lft" AS t1_r5, "entities"."rgt" AS t1_r6, "entities"."parent_id" AS t1_r7, "entities"."signature" AS t1_r8, "entities"."segment_type_id" AS t1_r9, "entities"."created_by" AS t1_r10, "entities"."create_method" AS t1_r11, "entities"."created_on" AS t1_r12, "entities"."modified_by" AS t1_r13, "entities"."updated_on" AS t1_r14, "entities"."update_sw_version" AS t1_r15, "entities"."store_number" AS t1_r16, "entities"."billing_status" AS t1_r17, "entities"."sign_up_date" AS t1_r18, "entities"."paid_date" AS t1_r19, "entities"."paid_through_date" AS t1_r20, "entities"."active_date" AS t1_r21, "entities"."cancel_date" AS t1_r22, "entities"."payment_method" AS t1_r23, "entities"."billing_interval" AS t1_r24, "entities"."fees_upfront" AS t1_r25, "entities"."fees_ongoing" AS t1_r26, "entities"."contact_name" AS t1_r27, "entities"."contact_email" AS t1_r28, "entities"."contact_phone" AS t1_r29, "entities"."street_address" AS t1_r30, "entities"."city" AS t1_r31, "entities"."state" AS t1_r32, "entities"."zipcode" AS t1_r33, "entities"."status" AS t1_r34, "entities"."cancel_reason" AS t1_r35, "entities"."account_number" AS t1_r36, "entities"."has_components" AS t1_r37, "entities"."lat" AS t1_r38, "entities"."lng" AS t1_r39, "entities"."street_address_2" AS t1_r40 FROM "receipt_formats"  LEFT OUTER JOIN "entities" ON "entities".id = "receipt_formats".entity_id WHERE ("receipt_formats"."entity_id" IN (1,61,62,63))  ORDER BY ["entities.rgt, receipt_formats.id DESC"] LIMIT 1
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/connection_adapters/abstract_adapter.rb:227:in `rescue in log'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/connection_adapters/abstract_adapter.rb:204:in `log'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/connection_adapters/postgresql_adapter.rb:520:in `execute'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/connection_adapters/postgresql_adapter.rb:1002:in `select_raw'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/connection_adapters/postgresql_adapter.rb:989:in `select'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/connection_adapters/abstract/query_cache.rb:62:in `select_all_with_query_cache'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/associations.rb:1622:in `select_all_rows'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/associations.rb:1401:in `block in find_with_associations'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/associations.rb:1399:in `catch'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/associations.rb:1399:in `find_with_associations'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/base.rb:1580:in `find_every'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/base.rb:1539:in `find_initial'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/base.rb:617:in `find'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/named_scope.rb:186:in `block in method_missing'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/base.rb:2186:in `with_scope'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/named_scope.rb:118:in `with_scope'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/named_scope.rb:179:in `method_missing'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/named_scope.rb:186:in `block in method_missing'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/base.rb:2186:in `with_scope'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/named_scope.rb:118:in `with_scope'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/named_scope.rb:118:in `with_scope'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/named_scope.rb:179:in `method_missing'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activerecord-2.3.15/lib/active_record/named_scope.rb:137:in `first'
    /nutricate/vagrant/admin/lib/entity_creation_tools.rb:10:in `get_or_create_receipt_format'
    /nutricate/vagrant/admin/lib/entity_creation_tools.rb:50:in `get_or_create_device_group'
    /nutricate/vagrant/admin/lib/entity_creation_tools.rb:134:in `auto_create_device'
    /nutricate/vagrant/admin/lib/entity_creation_tools.rb:268:in `create_entity'
    /nutricate/vagrant/admin/test/unit/entities_test.rb:203:in `test_import_entity'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activesupport-2.3.15/lib/active_support/testing/setup_and_teardown.rb:62:in `run'

  2) Error:
test_pos_deprecation(ItemsTest):
RuntimeError: can't add a new key into hash during iteration
    /nutricate/vagrant/admin/app/models/item.rb:170:in `[]='
    /nutricate/vagrant/admin/app/models/item.rb:170:in `block in initialize'
    /nutricate/vagrant/admin/app/models/item.rb:166:in `each'
    /nutricate/vagrant/admin/app/models/item.rb:166:in `initialize'
    /nutricate/vagrant/admin/test/unit/items_test.rb:17:in `new'
    /nutricate/vagrant/admin/test/unit/items_test.rb:17:in `new_item'
    /nutricate/vagrant/admin/test/unit/items_test.rb:28:in `test_pos_deprecation'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activesupport-2.3.15/lib/active_support/testing/setup_and_teardown.rb:62:in `run'

  3) Error:
test_download_feed(RssReaderTestCase):
Errno::ENOENT: No such file or directory - /tmp/feeds/__nutricate__vagrant__admin__test__fixtures__files__www.receipt.com__feeds__news.xml
    /nutricate/vagrant/admin/test/unit/rss_reader_test.rb:39:in `initialize'
    /nutricate/vagrant/admin/test/unit/rss_reader_test.rb:39:in `open'
    /nutricate/vagrant/admin/test/unit/rss_reader_test.rb:39:in `test_download_feed'
    /usr/local/rvm/gems/ruby-1.9.3-p448/gems/activesupport-2.3.15/lib/active_support/testing/setup_and_teardown.rb:62:in `run'

213 tests, 603 assertions, 0 failures, 3 errors
rake aborted!

Error 1: ianwhite/pickle@3e8df19
First attempt at fixing the issue.

SOLVED