search

robotmay / photographer-io

An open source photography community. No longer in production but still open source.
MIT License
664 stars 165 forks source link

Issue with DB setup #215

Closed AlainPilon closed 10 years ago

AlainPilon commented 10 years ago

I installed all the gem but when I do the bundle exec rake db:setup, I get this:

base-7:photographer-io alain$ rake db:setup
[deprecated] I18n.enforce_available_locales will default to true in the future. If you really want to skip validation of your locale you can set I18n.enforce_available_locales = false to avoid this message.
You have 63 pending migrations:
  20130429234245 DeviseCreateUsers
  20130430001433 CreatePhotographs
  20130430084054 CreateMetadata
  20130430092117 RenameImageColumnOnPhotographs
  20130430214315 EnableHstoreExtension
  20130430214425 SwitchToHstoreForMetadata
  20130502000100 CreateCollections
  20130502000711 CreateCollectionPhotographs
  20130503110219 AddSafeForWorkColumnToPhotograph
  20130503110857 CreateLicenses
  20130503174811 AddNewFieldsToUserTable
  20130503222325 AddAvatarColumnToUser
  20130503225818 AddGinIndexToMetadata
  20130504071626 AddFullTextSearchIndicesToMetadata
  20130504202315 AddLocationOptionFieldsToPhotoAndUser
  20130504210246 DeviseInvitableAddToUsers
  20130504213832 AddShowNotSafeForWorkColumnToUser
  20130505180844 CreateRecommendations
  20130505185219 AddRecommendationQuotaToUsers
  20130506003536 AddIndicesToMetadataHstores
  20130506222702 CreateCategories
  20130507101348 AddCounterCacheToUsers
  20130507130212 AddShowCopyrightOptions
  20130507230144 AddStandardisedImageAccessorToPhotographs
  20130508183202 CreateFavourites
  20130508222338 AddExtraFieldsToUsers
  20130509123705 AddRecommendationsCountColumnToUsers
  20130510225834 AddChannelKeyToUsers
  20130510231125 AddCounterCacheToPhotographs
  20130512093545 AddMagicAttributesToPhotographs
  20130512100329 AddNewImageUidsToPhotographs
  20130512105305 DeviseCreateAdminUsers
  20130512105909 AddProcessingColumnToPhotograph
  20130512114945 AddMimeTypeToPhotographs
  20130516212700 CreateFollowings
  20130518102856 AddUploadQuotaToUsers
  20130521173713 CreateCommentThreads
  20130521174315 CreateComments
  20130522122447 AddNestedSetColumnsToComments
  20130523163304 CreateNotifications
  20130523225313 AddNotifyColumnToUser
  20130530180641 AddReadColumnToNotifications
  20130530221819 AddEmailColumnToNotifications
  20130602092220 AddFavouritesPrivacyOptionToUsers
  20130602171743 AddSharingOptionToCollections
  20130603083149 CreateAuthorisations
  20130604173711 AddEnabledColumnToAuthorisations
  20130604201040 AddSocialDisableOptionToUsers
  20130608105451 AddUsernameFieldToUsers
  20130608154646 CreateOldUsernames
  20130708120849 RenamePublicColumn
  20130711162130 AddLocaleToUsers
  20130713123834 SwitchNlLocalesToNlNl
  20130715225941 AddEnableCommentThreadsByDefaultToUsers
  20130718114116 CreateReports
  20130718220746 AddGhostColumns
  20130719122054 AddModeratorColumnToUsers
  20130728122457 AddDescriptionToCollections
  20130731183731 AddProfileBackgroundFieldsToUser
  20130826132056 AddSmallThumbnailImageColumnToPhotographs
  20130826172509 AddLastPhotoAddedAtColumnToCollections
  20130830080641 ChangeLastPhotoCreatedAtColumn
  20131103133641 AddSlugToLicenses
Run `rake db:migrate` to update your database then try again.

And when I run the rake db:migrate, I get this:

base-7:photographer-io alain$ bundle exec rake db:migrate
[deprecated] I18n.enforce_available_locales will default to true in the future. If you really want to skip validation of your locale you can set I18n.enforce_available_locales = false to avoid this message.
==  DeviseCreateUsers: migrating ==============================================
-- create_table(:users)
   -> 0.0109s
-- add_index(:users, :email, {:unique=>true})
   -> 0.0047s
-- add_index(:users, :reset_password_token, {:unique=>true})
   -> 0.0033s
==  DeviseCreateUsers: migrated (0.0191s) =====================================

==  CreatePhotographs: migrating ==============================================
-- create_table(:photographs)
   -> 0.0030s
-- add_index(:photographs, :user_id)
   -> 0.0020s
==  CreatePhotographs: migrated (0.0051s) =====================================

==  CreateMetadata: migrating =================================================
-- create_table(:metadata)
   -> 0.0042s
-- add_index(:metadata, :photograph_id)
   -> 0.0021s
==  CreateMetadata: migrated (0.0064s) ========================================

==  RenameImageColumnOnPhotographs: migrating =================================
-- rename_column(:photographs, :image, :image_uid)
   -> 0.0024s
==  RenameImageColumnOnPhotographs: migrated (0.0024s) ========================

==  EnableHstoreExtension: migrating ==========================================
-- execute("CREATE EXTENSION hstore")
rake aborted!
An error has occurred, this and all later migrations canceled:

PG::Error: ERROR:  extension "hstore" already exists
: CREATE EXTENSION hstore/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in `exec'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in `block in execute'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/connection_adapters/abstract_adapter.rb:435:in `block in log'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activesupport-4.0.2/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/connection_adapters/abstract_adapter.rb:430:in `log'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/connection_adapters/postgresql/database_statements.rb:127:in `execute'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:625:in `block in method_missing'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:597:in `block in say_with_time'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:597:in `say_with_time'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:617:in `method_missing'
/Users/alain/github/photographer-io/db/migrate/20130430214315_enable_hstore_extension.rb:3:in `up'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:574:in `exec_migration'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:555:in `block (2 levels) in migrate'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:554:in `block in migrate'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in `with_connection'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:553:in `migrate'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:709:in `migrate'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:959:in `block in execute_migration_in_transaction'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:1005:in `block in ddl_transaction'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:202:in `block in transaction'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:210:in `within_new_transaction'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:202:in `transaction'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/transactions.rb:209:in `transaction'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:1005:in `ddl_transaction'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:958:in `execute_migration_in_transaction'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:920:in `block in migrate'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:916:in `each'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:916:in `migrate'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:764:in `up'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:742:in `migrate'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/railties/databases.rake:42:in `block (2 levels) in <top (required)>'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/bin/ruby_executable_hooks:15:in `eval'
/Users/alain/.rvm/gems/ruby-2.0.0-p353/bin/ruby_executable_hooks:15:in `<main>'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
base-7:photographer-io alain$
cassiuschen commented 10 years ago

I don't know whether it'll work but can you just try bundle exec rake db:rollback and do the migration again?

Cassius Chen, 2014

在 2014年2月20日，上午10:55，Alain Pilon notifications@github.com 写道：

I installed all the gem but when I do the bundle exec rake db:setup, I get this:

base-7:photographer-io alain$ rake db:setup [deprecated] I18n.enforce_available_locales will default to true in the future. If you really want to skip validation of your locale you can set I18n.enforce_available_locales = false to avoid this message. You have 63 pending migrations: 20130429234245 DeviseCreateUsers 20130430001433 CreatePhotographs 20130430084054 CreateMetadata 20130430092117 RenameImageColumnOnPhotographs 20130430214315 EnableHstoreExtension 20130430214425 SwitchToHstoreForMetadata 20130502000100 CreateCollections 20130502000711 CreateCollectionPhotographs 20130503110219 AddSafeForWorkColumnToPhotograph 20130503110857 CreateLicenses 20130503174811 AddNewFieldsToUserTable 20130503222325 AddAvatarColumnToUser 20130503225818 AddGinIndexToMetadata 20130504071626 AddFullTextSearchIndicesToMetadata 20130504202315 AddLocationOptionFieldsToPhotoAndUser 20130504210246 DeviseInvitableAddToUsers 20130504213832 AddShowNotSafeForWorkColumnToUser 20130505180844 CreateRecommendations 20130505185219 AddRecommendationQuotaToUsers 20130506003536 AddIndicesToMetadataHstores 20130506222702 CreateCategories 20130507101348 AddCounterCacheToUsers 20130507130212 AddShowCopyrightOptions 20130507230144 AddStandardisedImageAccessorToPhotographs 20130508183202 CreateFavourites 20130508222338 AddExtraFieldsToUsers 20130509123705 AddRecommendationsCountColumnToUsers 20130510225834 AddChannelKeyToUsers 20130510231125 AddCounterCacheToPhotographs 20130512093545 AddMagicAttributesToPhotographs 20130512100329 AddNewImageUidsToPhotographs 20130512105305 DeviseCreateAdminUsers 20130512105909 AddProcessingColumnToPhotograph 20130512114945 AddMimeTypeToPhotographs 20130516212700 CreateFollowings 20130518102856 AddUploadQuotaToUsers 20130521173713 CreateCommentThreads 20130521174315 CreateComments 20130522122447 AddNestedSetColumnsToComments 20130523163304 CreateNotifications 20130523225313 AddNotifyColumnToUser 20130530180641 AddReadColumnToNotifications 20130530221819 AddEmailColumnToNotifications 20130602092220 AddFavouritesPrivacyOptionToUsers 20130602171743 AddSharingOptionToCollections 20130603083149 CreateAuthorisations 20130604173711 AddEnabledColumnToAuthorisations 20130604201040 AddSocialDisableOptionToUsers 20130608105451 AddUsernameFieldToUsers 20130608154646 CreateOldUsernames 20130708120849 RenamePublicColumn 20130711162130 AddLocaleToUsers 20130713123834 SwitchNlLocalesToNlNl 20130715225941 AddEnableCommentThreadsByDefaultToUsers 20130718114116 CreateReports 20130718220746 AddGhostColumns 20130719122054 AddModeratorColumnToUsers 20130728122457 AddDescriptionToCollections 20130731183731 AddProfileBackgroundFieldsToUser 20130826132056 AddSmallThumbnailImageColumnToPhotographs 20130826172509 AddLastPhotoAddedAtColumnToCollections 20130830080641 ChangeLastPhotoCreatedAtColumn 20131103133641 AddSlugToLicenses Run rake db:migrate to update your database then try again. And when I run the rake db:migrate, I get this:

base-7:photographer-io alain$ bundle exec rake db:migrate [deprecated] I18n.enforce_available_locales will default to true in the future. If you really want to skip validation of your locale you can set I18n.enforce_available_locales = false to avoid this message. == DeviseCreateUsers: migrating ============================================== -- create_table(:users) -> 0.0109s -- add_index(:users, :email, {:unique=>true}) -> 0.0047s -- add_index(:users, :reset_password_token, {:unique=>true}) -> 0.0033s == DeviseCreateUsers: migrated (0.0191s) =====================================

== CreatePhotographs: migrating ============================================== -- create_table(:photographs) -> 0.0030s -- add_index(:photographs, :user_id) -> 0.0020s == CreatePhotographs: migrated (0.0051s) =====================================

== CreateMetadata: migrating ================================================= -- create_table(:metadata) -> 0.0042s -- add_index(:metadata, :photograph_id) -> 0.0021s == CreateMetadata: migrated (0.0064s) ========================================

== RenameImageColumnOnPhotographs: migrating ================================= -- rename_column(:photographs, :image, :image_uid) -> 0.0024s == RenameImageColumnOnPhotographs: migrated (0.0024s) ========================

== EnableHstoreExtension: migrating ========================================== -- execute("CREATE EXTENSION hstore") rake aborted! An error has occurred, this and all later migrations canceled:

PG::Error: ERROR: extension "hstore" already exists : CREATE EXTENSION hstore/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in exec' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:inblock in execute' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/connection_adapters/abstract_adapter.rb:435:in block in log' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activesupport-4.0.2/lib/active_support/notifications/instrumenter.rb:20:ininstrument' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/connection_adapters/abstract_adapter.rb:430:in log' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/connection_adapters/postgresql/database_statements.rb:127:inexecute' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:625:in block in method_missing' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:597:inblock in say_with_time' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:597:in say_with_time' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:617:inmethod_missing' /Users/alain/github/photographer-io/db/migrate/20130430214315_enable_hstore_extension.rb:3:in up' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:574:inexec_migration' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:555:in block (2 levels) in migrate' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:554:inblock in migrate' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/connection_adapters/abstract/connection_pool.rb:294:in with_connection' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:553:inmigrate' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:709:in migrate' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:959:inblock in execute_migration_in_transaction' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:1005:in block in ddl_transaction' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:202:inblock in transaction' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:210:in within_new_transaction' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/connection_adapters/abstract/database_statements.rb:202:intransaction' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/transactions.rb:209:in transaction' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:1005:inddl_transaction' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:958:in execute_migration_in_transaction' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:920:inblock in migrate' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:916:in each' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:916:inmigrate' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:764:in up' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/migration.rb:742:inmigrate' /Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/railties/databases.rake:42:in block (2 levels) in <top (required)>' /Users/alain/.rvm/gems/ruby-2.0.0-p353/bin/ruby_executable_hooks:15:ineval' /Users/alain/.rvm/gems/ruby-2.0.0-p353/bin/ruby_executable_hooks:15:in `

' Tasks: TOP => db:migrate (See full trace by running task with --trace) base-7:photographer-io alain$ — Reply to this email directly or view it on GitHub.

AlainPilon commented 10 years ago

Nah.. that is the part I dont understand. It crashes because it says that the hstore extension already exists and if I comment out execute 'CREATE EXTENSION hstore', on the next migration it tells me PG::Error: ERROR: type "hstore" does not exist, which does not make sense...

BTW, is there a reason why you are using the PG gem v0.15 instead of the 0.17 ? Maybe it is totally unrelated but I always used the 0.17 and never had any issues with the hstore extension.

cassiuschen commented 10 years ago

Well, I don't think it's caused by the pg's version problem cause nobody else report this issue before. The error 'Hstore not find' must be dropped out when rake is doing a migration include type 'hstore', not about making 'hstore' available.

Could you please try to update pg's version and edit the migration which include the 'CREATE EXTENSION hstore' to the codes below:

class SetUpHstore < ActiveRecord::Migration def change enable_extension "hstore" end end

Then do 'rollback' and migrate again. Cassius Chen, 2014

在 2014年2月20日，下午9:10，Alain Pilon notifications@github.com 写道：

Nah.. that is the part I dont understand. It crashes because it says that the hstore extension already exists and if I comment out execute 'CREATE EXTENSION hstore', on the next migration it tells me PG::Error: ERROR: type "hstore" does not exist, which does not make sense...

BTW, is there a reason why you are using the PG gem v0.15 instead of the 0.17 ? Maybe it is totally unrelated but I always used the 0.17 and never had any issues with the hstore extension.

— Reply to this email directly or view it on GitHub.

AlainPilon commented 10 years ago

getting this now which is very conflicting:

==  SwitchToHstoreForMetadata: migrating ======================================
-- enable_extension("hstore")
   -> 0.0026s
-- add_column(:metadata, :camera, :hstore)
rake aborted!
An error has occurred, this and all later migrations canceled:

PG::UndefinedObject: ERROR:  type "hstore" does not exist
LINE 1: ALTER TABLE "metadata" ADD COLUMN "camera" hstore
                                                   ^
: ALTER TABLE "metadata" ADD COLUMN "camera" hstore/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in `async_exec'
cassiuschen commented 10 years ago

What's your PostgreSQL version?

Cassius Chen, 2014

在 2014年2月20日，下午9:43，Alain Pilon notifications@github.com 写道：

getting this now which is very conflicting:

== SwitchToHstoreForMetadata: migrating ====================================== -- enable_extension("hstore") -> 0.0026s -- add_column(:metadata, :camera, :hstore) rake aborted! An error has occurred, this and all later migrations canceled:

PG::UndefinedObject: ERROR: type "hstore" does not exist LINE 1: ALTER TABLE "metadata" ADD COLUMN "camera" hstore ^ : ALTER TABLE "metadata" ADD COLUMN "camera" hstore/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in `async_exec' — Reply to this email directly or view it on GitHub.

AlainPilon commented 10 years ago

I am using postgresapp.com . which is pg 9.3.something

On Thu, Feb 20, 2014 at 9:05 AM, Cassius Chen notifications@github.comwrote:

What's your PostgreSQL version?

Cassius Chen, 2014

在 2014年2月20日，下午9:43，Alain Pilon notifications@github.com 写道：

getting this now which is very conflicting:

== SwitchToHstoreForMetadata: migrating

-- enable_extension("hstore") -> 0.0026s -- add_column(:metadata, :camera, :hstore) rake aborted! An error has occurred, this and all later migrations canceled:

PG::UndefinedObject: ERROR: type "hstore" does not exist LINE 1: ALTER TABLE "metadata" ADD COLUMN "camera" hstore ^ : ALTER TABLE "metadata" ADD COLUMN "camera" hstore/Users/alain/.rvm/gems/ruby-2.0.0-p353/gems/activerecord-4.0.2/lib/active_record/connection_adapters/postgresql/database_statements.rb:128:in `async_exec' — Reply to this email directly or view it on GitHub.

— Reply to this email directly or view it on GitHubhttps://github.com/afternoonrobot/photographer-io/issues/215#issuecomment-35623935 .

AlainPilon commented 10 years ago

Fixed the issue by adding: schema_search_path: "public,hstore" to database.yml