anlek
commented
7 years ago The issue is that updated_at is a required field for sync to work. See issue #109
Closed bhumipatel1512 closed 7 years ago
anlek
commented
7 years ago The issue is that updated_at is a required field for sync to work. See issue #109
i am trying to migrate postgresql database. sync command not working it gives an error like
/home/bhumi/.rvm/gems/ruby-2.3.0/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/postgresql_adapter.rb:1163:in'
from /home/bhumi/.rvm/gems/ruby-2.3.0/bin/ruby_executable_hooks:15:in '
async_exec': PG::UndefinedColumn: ERROR: column t.updated_at does not exist (ActiveRecord::StatementInvalid) LINE 1: ....* FROM scsemp t, __mongify_sync_helper__ u WHERE t.updated_... ^ : SELECT t.* FROM scsemp t, __mongify_sync_helper__ u WHERE t.updated_at > u.last_updated_at AND u.table_name = 'scsemp' from /home/bhumi/.rvm/gems/ruby-2.3.0/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/postgresql_adapter.rb:1163:inexec_no_cache' from /home/bhumi/.rvm/gems/ruby-2.3.0/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/postgresql_adapter.rb:660:inblock in exec_query' from /home/bhumi/.rvm/gems/ruby-2.3.0/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/abstract_adapter.rb:280:inblock in log' from /home/bhumi/.rvm/gems/ruby-2.3.0/gems/activesupport-3.2.22.2/lib/active_support/notifications/instrumenter.rb:20:ininstrument' from /home/bhumi/.rvm/gems/ruby-2.3.0/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/abstract_adapter.rb:275:inlog' from /home/bhumi/.rvm/gems/ruby-2.3.0/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/postgresql_adapter.rb:659:inexec_query' from /home/bhumi/.rvm/gems/ruby-2.3.0/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/postgresql_adapter.rb:1262:inselect' from /home/bhumi/.rvm/gems/ruby-2.3.0/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/abstract/database_statements.rb:18:inselect_all' from /home/bhumi/.rvm/gems/ruby-2.3.0/gems/activerecord-3.2.22.2/lib/active_record/connection_adapters/abstract/query_cache.rb:63:inselect_all' from /home/bhumi/.rvm/gems/ruby-2.3.0/gems/mongify-1.2.4/lib/mongify/database/sql_connection.rb:108:inselect_by_query' from /home/bhumi/.rvm/gems/ruby-2.3.0/gems/mongify-1.2.4/lib/mongify/translation/sync.rb:61:inblock in sync_data' from /home/bhumi/.rvm/gems/ruby-2.3.0/gems/mongify-1.2.4/lib/mongify/translation/sync.rb:58:ineach' from /home/bhumi/.rvm/gems/ruby-2.3.0/gems/mongify-1.2.4/lib/mongify/translation/sync.rb:58:insync_data' from /home/bhumi/.rvm/gems/ruby-2.3.0/gems/mongify-1.2.4/lib/mongify/translation/sync.rb:29:insync' from /home/bhumi/.rvm/gems/ruby-2.3.0/gems/mongify-1.2.4/lib/mongify/cli/command/worker.rb:71:inexecute' from /home/bhumi/.rvm/gems/ruby-2.3.0/gems/mongify-1.2.4/lib/mongify/cli/application.rb:28:inexecute!' from /home/bhumi/.rvm/gems/ruby-2.3.0/gems/mongify-1.2.4/bin/mongify:15:in<top (required)>' from /home/bhumi/.rvm/gems/ruby-2.3.0/bin/mongify:23:inload' from /home/bhumi/.rvm/gems/ruby-2.3.0/bin/mongify:23:ineval' from /home/bhumi/.rvm/gems/ruby-2.3.0/bin/ruby_executable_hooks:15:in