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
--
Posted via http://www.ruby-forum.com/.
John Griffiths 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 Griffiths <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> 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 > -- > Posted viahttp://www.ruby-forum.com/.
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. -- Posted via http://www.ruby-forum.com/.