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 PostgreSQL: Documentation 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.