Sqlite error with timezones

Any ideas where I should look, have this error while deploying to
Heroku,

ActiveRecord::StatementInvalid (PGError: ERROR: function
strftime(unknown, timestamp without time zone, unknown) does not exist
LINE 1: SELECT strftime(’%Y’, created_at) as year, strftime(’…

I’ve checked the SqlLite documentation but can’t find anything regarding
this, the timezone is set in the Rails app, weird error

John G. wrote:

Any ideas where I should look, have this error while deploying to
Heroku,

ActiveRecord::StatementInvalid (PGError: ERROR: function
strftime(unknown, timestamp without time zone, unknown) does not exist
LINE 1: SELECT strftime(’%Y’, created_at) as year, strftime(’…

I’ve checked the SqlLite documentation but can’t find anything regarding
this, the timezone is set in the Rails app, weird error

run:
rake time:zones:local
to find your current time zone setting.
check your config/environment.rb, find the following statement:
config.time_zone = ‘UTC’
change it to whatever you want.

PGError comes from postgres adapter, not sqlite, you might want to
look at http://www.postgresql.org/docs/manuals/ instead of the sqlite
docs.

On Sep 18, 8:58 pm, John G. [email protected]

yep, i was trying to push an app to Heroku, little did i know it takes
mysql or sqlite db’s and dumps them into PostGreSQL format.

i’ll eventually crack the importing, gonna try a smaller app before the
big one.

thanks for the help.

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs