search

anlek / mongify

Mongify allows you to map your data from a sql database and into a mongodb document database.
http://github.com/anlek/mongify
MIT License
316 stars 81 forks source link

Error while using sync command #188

Open MOHAMMAD-FATHA opened 2 years ago

MOHAMMAD-FATHA commented 2 years ago

I am facing issue while using sync command kindly me over it I have been asking question since last so many days I request you to help me, The error I am facing is : TinyTds::Error: Invalid column name 'updated_at'.: EXEC sp_executesql N'SELECT t.* FROM mongify_sync_helper t, mongify_sync_helper u WHERE t.updated_at > u.last_updated_at AND u.table_name = ''mongify_sync_helper''' (ActiveRecord::StatementInvalid)

anlek commented 2 years ago

Hmm, I'm not sure what caused this error. Can you check in your SQL database that mongify_sync_helper table has an updated_at column?

MOHAMMAD-FATHA commented 2 years ago

But it's written is source code of mongify then why it's throwing error. And in my sql table there is no updated at column is present

On Fri, 11 Feb 2022, 21:46 Andrew Kalek, @.***> wrote:

Hmm, I'm not sure what caused this error. Can you check in your SQL database that mongify_sync_helper table has an updated_at column?

— Reply to this email directly, view it on GitHub https://github.com/anlek/mongify/issues/188#issuecomment-1036377957, or unsubscribe https://github.com/notifications/unsubscribe-auth/AKPMPSRR7CP3XKPGUB5JG63U2UY6NANCNFSM5NWRXTAA . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you authored the thread.Message ID: @.***>