Hello everyone

I am desperately in need of help because a website created by Ruby on Rails
has gone down after remotely rebooting a VPS server.
The site is this: http://offeriland.com/

I could not let update reflect in the site, so I rebooted the site using
the web host's remote VPS control system. The site now only displays ' We're
sorry, but something went wrong.'
I have searched across the web for a solution with no luck.

Please someone do help me.

Best regards,

Ead


--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/29252ccf-8278-45bf-8f03-750b3371378f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Search Discussions

  • Frederick Cheung at Apr 17, 2014 at 2:28 pm

    On Thursday, April 17, 2014 3:25:38 PM UTC+1, Ead wrote:
    Hello everyone

    I am desperately in need of help because a website created by Ruby on
    Rails has gone down after remotely rebooting a VPS server.
    The site is this: http://offeriland.com/

    I could not let update reflect in the site, so I rebooted the site using
    the web host's remote VPS control system. The site now only displays ' We're
    sorry, but something went wrong.'
    I have searched across the web for a solution with no luck.
    This isn't solvable without more information. The first step would for you
    to take a look at the logfiles for the application (by default this will be
    in log/production.log in the folder where the rails app is checked out).
    This should have more information about the error. For example perhaps one
    of the services on the server didn't start up when you restarted the server.

    Fred

    --
    You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
    To post to this group, send email to rubyonrails-talk@googlegroups.com.
    To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/895aaa71-bd00-406a-9648-252270d3ae7d%40googlegroups.com.
    For more options, visit https://groups.google.com/d/optout.
  • Ead at Apr 17, 2014 at 2:45 pm
    Thank you so much for the reply. The below is the top portion of the
    production.log.
    It shows 500 Internal Server Error at the 5th line from the top. I don't
    understand the cause of the error because
    hardly anything has changed since the time before the boot. I would be
    every so grateful if you would could suggest any potential solutions.


    Connecting to database specified by database.yml
    Connecting to database specified by database.yml
    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:20 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 109ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "registers"
    does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
                                             ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
                          pg_get_expr(d.adbin, d.adrelid), a.attnotnull,
    a.atttypid, a.atttypmod
                   FROM pg_attribute a LEFT JOIN pg_attrdef d
                     ON a.attrelid = d.adrelid AND a.attnum = d.adnum
                  WHERE a.attrelid = '"registers"'::regclass
                    AND a.attnum > 0 AND NOT a.attisdropped
                  ORDER BY a.attnum
    ):
       app/controllers/static_pages_controller.rb:16:in `new'
       app/controllers/static_pages_controller.rb:16:in `register'


    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:22 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 113ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "registers"
    does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
                                             ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
                          pg_get_expr(d.adbin, d.adrelid), a.attnotnull,
    a.atttypid, a.atttypmod
                   FROM pg_attribute a LEFT JOIN pg_attrdef d
                     ON a.attrelid = d.adrelid AND a.attnum = d.adnum
                  WHERE a.attrelid = '"registers"'::regclass
                    AND a.attnum > 0 AND NOT a.attisdropped
                  ORDER BY a.attnum
    ):
       app/controllers/static_pages_controller.rb:16:in `new'
       app/controllers/static_pages_controller.rb:16:in `register'


    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:23 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 1ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "registers"
    does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
                                             ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
                          pg_get_expr(d.adbin, d.adrelid), a.attnotnull,
    a.atttypid, a.atttypmod
                   FROM pg_attribute a LEFT JOIN pg_attrdef d
                     ON a.attrelid = d.adrelid AND a.attnum = d.adnum
                  WHERE a.attrelid = '"registers"'::regclass
                    AND a.attnum > 0 AND NOT a.attisdropped
                  ORDER BY a.attnum
    ):
       app/controllers/static_pages_controller.rb:16:in `new'
       app/controllers/static_pages_controller.rb:16:in `register'

    On Thursday, 17 April 2014 23:28:45 UTC+9, Frederick Cheung wrote:


    On Thursday, April 17, 2014 3:25:38 PM UTC+1, Ead wrote:

    Hello everyone

    I am desperately in need of help because a website created by Ruby on
    Rails has gone down after remotely rebooting a VPS server.
    The site is this: http://offeriland.com/

    I could not let update reflect in the site, so I rebooted the site using
    the web host's remote VPS control system. The site now only displays ' We're
    sorry, but something went wrong.'
    I have searched across the web for a solution with no luck.
    This isn't solvable without more information. The first step would for you
    to take a look at the logfiles for the application (by default this will be
    in log/production.log in the folder where the rails app is checked out).
    This should have more information about the error. For example perhaps one
    of the services on the server didn't start up when you restarted the server.

    Fred
    --
    You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
    To post to this group, send email to rubyonrails-talk@googlegroups.com.
    To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/b7a4f0b6-0b38-44da-9317-1d1109a050fa%40googlegroups.com.
    For more options, visit https://groups.google.com/d/optout.
  • Mike Villa at Apr 17, 2014 at 3:06 pm
    New migration? Check with the last engineer who checked in code. Might need to update ur database rake db:migrate. Someone who is familiar with or db should do that. Check with ur db admin first too

    Sent from my iPhone
    On Apr 17, 2014, at 7:45 AM, Ead wrote:

    Thank you so much for the reply. The below is the top portion of the production.log.
    It shows 500 Internal Server Error at the 5th line from the top. I don't understand the cause of the error because
    hardly anything has changed since the time before the boot. I would be every so grateful if you would could suggest any potential solutions.


    Connecting to database specified by database.yml
    Connecting to database specified by database.yml
    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:20 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 109ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "registers" does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
    ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
    pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
    FROM pg_attribute a LEFT JOIN pg_attrdef d
    ON a.attrelid = d.adrelid AND a.attnum = d.adnum
    WHERE a.attrelid = '"registers"'::regclass
    AND a.attnum > 0 AND NOT a.attisdropped
    ORDER BY a.attnum
    ):
    app/controllers/static_pages_controller.rb:16:in `new'
    app/controllers/static_pages_controller.rb:16:in `register'


    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:22 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 113ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "registers" does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
    ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
    pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
    FROM pg_attribute a LEFT JOIN pg_attrdef d
    ON a.attrelid = d.adrelid AND a.attnum = d.adnum
    WHERE a.attrelid = '"registers"'::regclass
    AND a.attnum > 0 AND NOT a.attisdropped
    ORDER BY a.attnum
    ):
    app/controllers/static_pages_controller.rb:16:in `new'
    app/controllers/static_pages_controller.rb:16:in `register'


    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:23 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 1ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "registers" does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
    ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
    pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod
    FROM pg_attribute a LEFT JOIN pg_attrdef d
    ON a.attrelid = d.adrelid AND a.attnum = d.adnum
    WHERE a.attrelid = '"registers"'::regclass
    AND a.attnum > 0 AND NOT a.attisdropped
    ORDER BY a.attnum
    ):
    app/controllers/static_pages_controller.rb:16:in `new'
    app/controllers/static_pages_controller.rb:16:in `register'

    On Thursday, 17 April 2014 23:28:45 UTC+9, Frederick Cheung wrote:

    On Thursday, April 17, 2014 3:25:38 PM UTC+1, Ead wrote:
    Hello everyone

    I am desperately in need of help because a website created by Ruby on Rails has gone down after remotely rebooting a VPS server.
    The site is this: http://offeriland.com/

    I could not let update reflect in the site, so I rebooted the site using the web host's remote VPS control system. The site now only displays ' We're sorry, but something went wrong.'
    I have searched across the web for a solution with no luck.
    This isn't solvable without more information. The first step would for you to take a look at the logfiles for the application (by default this will be in log/production.log in the folder where the rails app is checked out). This should have more information about the error. For example perhaps one of the services on the server didn't start up when you restarted the server.

    Fred
    --
    You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
    To post to this group, send email to rubyonrails-talk@googlegroups.com.
    To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/b7a4f0b6-0b38-44da-9317-1d1109a050fa%40googlegroups.com.
    For more options, visit https://groups.google.com/d/optout.
    --
    You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
    To post to this group, send email to rubyonrails-talk@googlegroups.com.
    To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/0F34D538-A10D-4EF3-A9AE-1097C1D2C470%40gmail.com.
    For more options, visit https://groups.google.com/d/optout.
  • Ead at Apr 17, 2014 at 3:12 pm
    Thank you for the reply. Running rake db:migrate returns the message below:


    rake aborted!
    No Rakefile found (looking for: rakefile, Rakefile, rakefile.rb,
    Rakefile.rb)
    /home/tadashi-toyokura/.rvm/gems/ruby-2.0.0-p247/bin/ruby_noexec_wrapper:14:in
    `eval'
    /home/tadashi-toyokura/.rvm/gems/ruby-2.0.0-p247/bin/ruby_noexec_wrapper:14:in
    `<main>'
    (See full trace by running task with --trace)

    The other engineer has not done anything with the databases and I'm
    completely stuck. Some more advice would be deeply appreciated.

    Best regards,

    Ead

    On Friday, 18 April 2014 00:05:03 UTC+9, Mike Villa wrote:

    New migration? Check with the last engineer who checked in code. Might
    need to update ur database rake db:migrate. Someone who is familiar with or
    db should do that. Check with ur db admin first too

    Sent from my iPhone

    On Apr 17, 2014, at 7:45 AM, Ead <dai...@gmail.com <javascript:>> wrote:

    Thank you so much for the reply. The below is the top portion of the
    production.log.
    It shows 500 Internal Server Error at the 5th line from the top. I don't
    understand the cause of the error because
    hardly anything has changed since the time before the boot. I would be
    every so grateful if you would could suggest any potential solutions.


    Connecting to database specified by database.yml
    Connecting to database specified by database.yml
    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:20 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 109ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "registers"
    does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
    ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
    pg_get_expr(d.adbin, d.adrelid), a.attnotnull,
    a.atttypid, a.atttypmod
    FROM pg_attribute a LEFT JOIN pg_attrdef d
    ON a.attrelid = d.adrelid AND a.attnum = d.adnum
    WHERE a.attrelid = '"registers"'::regclass
    AND a.attnum > 0 AND NOT a.attisdropped
    ORDER BY a.attnum
    ):
    app/controllers/static_pages_controller.rb:16:in `new'
    app/controllers/static_pages_controller.rb:16:in `register'


    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:22 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 113ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "registers"
    does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
    ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
    pg_get_expr(d.adbin, d.adrelid), a.attnotnull,
    a.atttypid, a.atttypmod
    FROM pg_attribute a LEFT JOIN pg_attrdef d
    ON a.attrelid = d.adrelid AND a.attnum = d.adnum
    WHERE a.attrelid = '"registers"'::regclass
    AND a.attnum > 0 AND NOT a.attisdropped
    ORDER BY a.attnum
    ):
    app/controllers/static_pages_controller.rb:16:in `new'
    app/controllers/static_pages_controller.rb:16:in `register'


    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:23 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 1ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "registers"
    does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
    ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
    pg_get_expr(d.adbin, d.adrelid), a.attnotnull,
    a.atttypid, a.atttypmod
    FROM pg_attribute a LEFT JOIN pg_attrdef d
    ON a.attrelid = d.adrelid AND a.attnum = d.adnum
    WHERE a.attrelid = '"registers"'::regclass
    AND a.attnum > 0 AND NOT a.attisdropped
    ORDER BY a.attnum
    ):
    app/controllers/static_pages_controller.rb:16:in `new'
    app/controllers/static_pages_controller.rb:16:in `register'

    On Thursday, 17 April 2014 23:28:45 UTC+9, Frederick Cheung wrote:


    On Thursday, April 17, 2014 3:25:38 PM UTC+1, Ead wrote:

    Hello everyone

    I am desperately in need of help because a website created by Ruby on
    Rails has gone down after remotely rebooting a VPS server.
    The site is this: http://offeriland.com/

    I could not let update reflect in the site, so I rebooted the site using
    the web host's remote VPS control system. The site now only displays ' We're
    sorry, but something went wrong.'
    I have searched across the web for a solution with no luck.
    This isn't solvable without more information. The first step would for
    you to take a look at the logfiles for the application (by default this
    will be in log/production.log in the folder where the rails app is checked
    out). This should have more information about the error. For example
    perhaps one of the services on the server didn't start up when you
    restarted the server.

    Fred
    --
    You received this message because you are subscribed to the Google Groups
    "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send an
    email to rubyonrails-ta...@googlegroups.com <javascript:>.
    To post to this group, send email to rubyonra...@googlegroups.com<javascript:>
    .
    To view this discussion on the web visit
    https://groups.google.com/d/msgid/rubyonrails-talk/b7a4f0b6-0b38-44da-9317-1d1109a050fa%40googlegroups.com<https://groups.google.com/d/msgid/rubyonrails-talk/b7a4f0b6-0b38-44da-9317-1d1109a050fa%40googlegroups.com?utm_medium=email&utm_source=footer>
    .
    For more options, visit https://groups.google.com/d/optout.
    --
    You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
    To post to this group, send email to rubyonrails-talk@googlegroups.com.
    To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/1a0bf482-341a-437f-b8fb-fca3840fac50%40googlegroups.com.
    For more options, visit https://groups.google.com/d/optout.
  • Tommaso Visconti at Apr 17, 2014 at 3:14 pm
    are you sure the app works outside the server (e.g. in your development
    machine)?


    2014-04-17 17:12 GMT+02:00 Ead <dai2809@gmail.com>:
    Thank you for the reply. Running rake db:migrate returns the message
    below:


    rake aborted!
    No Rakefile found (looking for: rakefile, Rakefile, rakefile.rb,
    Rakefile.rb)
    /home/tadashi-toyokura/.rvm/gems/ruby-2.0.0-p247/bin/ruby_noexec_wrapper:14:in
    `eval'
    /home/tadashi-toyokura/.rvm/gems/ruby-2.0.0-p247/bin/ruby_noexec_wrapper:14:in
    `<main>'
    (See full trace by running task with --trace)

    The other engineer has not done anything with the databases and I'm
    completely stuck. Some more advice would be deeply appreciated.

    Best regards,

    Ead

    On Friday, 18 April 2014 00:05:03 UTC+9, Mike Villa wrote:

    New migration? Check with the last engineer who checked in code. Might
    need to update ur database rake db:migrate. Someone who is familiar with or
    db should do that. Check with ur db admin first too

    Sent from my iPhone

    On Apr 17, 2014, at 7:45 AM, Ead wrote:

    Thank you so much for the reply. The below is the top portion of the
    production.log.
    It shows 500 Internal Server Error at the 5th line from the top. I don't
    understand the cause of the error because
    hardly anything has changed since the time before the boot. I would be
    every so grateful if you would could suggest any potential solutions.


    Connecting to database specified by database.yml
    Connecting to database specified by database.yml
    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:20 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 109ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "registers"
    does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
    ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
    pg_get_expr(d.adbin, d.adrelid), a.attnotnull,
    a.atttypid, a.atttypmod
    FROM pg_attribute a LEFT JOIN pg_attrdef d
    ON a.attrelid = d.adrelid AND a.attnum = d.adnum
    WHERE a.attrelid = '"registers"'::regclass
    AND a.attnum > 0 AND NOT a.attisdropped
    ORDER BY a.attnum
    ):
    app/controllers/static_pages_controller.rb:16:in `new'
    app/controllers/static_pages_controller.rb:16:in `register'


    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:22 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 113ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "registers"
    does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
    ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
    pg_get_expr(d.adbin, d.adrelid), a.attnotnull,
    a.atttypid, a.atttypmod
    FROM pg_attribute a LEFT JOIN pg_attrdef d
    ON a.attrelid = d.adrelid AND a.attnum = d.adnum
    WHERE a.attrelid = '"registers"'::regclass
    AND a.attnum > 0 AND NOT a.attisdropped
    ORDER BY a.attnum
    ):
    app/controllers/static_pages_controller.rb:16:in `new'
    app/controllers/static_pages_controller.rb:16:in `register'


    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:23 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 1ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "registers"
    does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
    ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
    pg_get_expr(d.adbin, d.adrelid), a.attnotnull,
    a.atttypid, a.atttypmod
    FROM pg_attribute a LEFT JOIN pg_attrdef d
    ON a.attrelid = d.adrelid AND a.attnum = d.adnum
    WHERE a.attrelid = '"registers"'::regclass
    AND a.attnum > 0 AND NOT a.attisdropped
    ORDER BY a.attnum
    ):
    app/controllers/static_pages_controller.rb:16:in `new'
    app/controllers/static_pages_controller.rb:16:in `register'

    On Thursday, 17 April 2014 23:28:45 UTC+9, Frederick Cheung wrote:


    On Thursday, April 17, 2014 3:25:38 PM UTC+1, Ead wrote:

    Hello everyone

    I am desperately in need of help because a website created by Ruby on
    Rails has gone down after remotely rebooting a VPS server.
    The site is this: http://offeriland.com/

    I could not let update reflect in the site, so I rebooted the site
    using the web host's remote VPS control system. The site now only displays
    ' We're sorry, but something went wrong.'
    I have searched across the web for a solution with no luck.
    This isn't solvable without more information. The first step would for
    you to take a look at the logfiles for the application (by default this
    will be in log/production.log in the folder where the rails app is checked
    out). This should have more information about the error. For example
    perhaps one of the services on the server didn't start up when you
    restarted the server.

    Fred
    --
    You received this message because you are subscribed to the Google Groups
    "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send an
    email to rubyonrails-ta...@googlegroups.com.
    To post to this group, send email to rubyonra...@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/
    msgid/rubyonrails-talk/b7a4f0b6-0b38-44da-9317-
    1d1109a050fa%40googlegroups.com<https://groups.google.com/d/msgid/rubyonrails-talk/b7a4f0b6-0b38-44da-9317-1d1109a050fa%40googlegroups.com?utm_medium=email&utm_source=footer>
    .
    For more options, visit https://groups.google.com/d/optout.

    --
    You received this message because you are subscribed to the Google Groups
    "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send an
    email to rubyonrails-talk+unsubscribe@googlegroups.com.
    To post to this group, send email to rubyonrails-talk@googlegroups.com.
    To view this discussion on the web visit
    https://groups.google.com/d/msgid/rubyonrails-talk/1a0bf482-341a-437f-b8fb-fca3840fac50%40googlegroups.com<https://groups.google.com/d/msgid/rubyonrails-talk/1a0bf482-341a-437f-b8fb-fca3840fac50%40googlegroups.com?utm_medium=email&utm_source=footer>
    .

    For more options, visit https://groups.google.com/d/optout.
    --
    You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
    To post to this group, send email to rubyonrails-talk@googlegroups.com.
    To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CAK4fz2pVxah6S1oB17K3bbnkUCcPhbRi_-mJ6vapmWJ-cVKJOg%40mail.gmail.com.
    For more options, visit https://groups.google.com/d/optout.
  • Ead at Apr 17, 2014 at 3:20 pm
    I could only run the website from the development and production branches
    of the VPS server as my local machine did not have an environment that
    could run Ruby files.
    Before the reboot, the site ran perfectly from the server, so I just cannot
    start thinking how I could go about debugging this.
    On Friday, 18 April 2014 00:14:23 UTC+9, Tommaso Visconti wrote:

    are you sure the app works outside the server (e.g. in your development
    machine)?


    2014-04-17 17:12 GMT+02:00 Ead <dai...@gmail.com <javascript:>>:
    Thank you for the reply. Running rake db:migrate returns the message
    below:


    rake aborted!
    No Rakefile found (looking for: rakefile, Rakefile, rakefile.rb,
    Rakefile.rb)
    /home/tadashi-toyokura/.rvm/gems/ruby-2.0.0-p247/bin/ruby_noexec_wrapper:14:in
    `eval'
    /home/tadashi-toyokura/.rvm/gems/ruby-2.0.0-p247/bin/ruby_noexec_wrapper:14:in
    `<main>'
    (See full trace by running task with --trace)

    The other engineer has not done anything with the databases and I'm
    completely stuck. Some more advice would be deeply appreciated.

    Best regards,

    Ead

    On Friday, 18 April 2014 00:05:03 UTC+9, Mike Villa wrote:

    New migration? Check with the last engineer who checked in code. Might
    need to update ur database rake db:migrate. Someone who is familiar with or
    db should do that. Check with ur db admin first too

    Sent from my iPhone

    On Apr 17, 2014, at 7:45 AM, Ead wrote:

    Thank you so much for the reply. The below is the top portion of the
    production.log.
    It shows 500 Internal Server Error at the 5th line from the top. I don't
    understand the cause of the error because
    hardly anything has changed since the time before the boot. I would be
    every so grateful if you would could suggest any potential solutions.


    Connecting to database specified by database.yml
    Connecting to database specified by database.yml
    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:20 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 109ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "registers"
    does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
    ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
    pg_get_expr(d.adbin, d.adrelid), a.attnotnull,
    a.atttypid, a.atttypmod
    FROM pg_attribute a LEFT JOIN pg_attrdef d
    ON a.attrelid = d.adrelid AND a.attnum = d.adnum
    WHERE a.attrelid = '"registers"'::regclass
    AND a.attnum > 0 AND NOT a.attisdropped
    ORDER BY a.attnum
    ):
    app/controllers/static_pages_controller.rb:16:in `new'
    app/controllers/static_pages_controller.rb:16:in `register'


    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:22 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 113ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "registers"
    does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
    ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
    pg_get_expr(d.adbin, d.adrelid), a.attnotnull,
    a.atttypid, a.atttypmod
    FROM pg_attribute a LEFT JOIN pg_attrdef d
    ON a.attrelid = d.adrelid AND a.attnum = d.adnum
    WHERE a.attrelid = '"registers"'::regclass
    AND a.attnum > 0 AND NOT a.attisdropped
    ORDER BY a.attnum
    ):
    app/controllers/static_pages_controller.rb:16:in `new'
    app/controllers/static_pages_controller.rb:16:in `register'


    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:23 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 1ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "registers"
    does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
    ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
    pg_get_expr(d.adbin, d.adrelid), a.attnotnull,
    a.atttypid, a.atttypmod
    FROM pg_attribute a LEFT JOIN pg_attrdef d
    ON a.attrelid = d.adrelid AND a.attnum = d.adnum
    WHERE a.attrelid = '"registers"'::regclass
    AND a.attnum > 0 AND NOT a.attisdropped
    ORDER BY a.attnum
    ):
    app/controllers/static_pages_controller.rb:16:in `new'
    app/controllers/static_pages_controller.rb:16:in `register'

    On Thursday, 17 April 2014 23:28:45 UTC+9, Frederick Cheung wrote:


    On Thursday, April 17, 2014 3:25:38 PM UTC+1, Ead wrote:

    Hello everyone

    I am desperately in need of help because a website created by Ruby on
    Rails has gone down after remotely rebooting a VPS server.
    The site is this: http://offeriland.com/

    I could not let update reflect in the site, so I rebooted the site
    using the web host's remote VPS control system. The site now only displays
    ' We're sorry, but something went wrong.'
    I have searched across the web for a solution with no luck.
    This isn't solvable without more information. The first step would for
    you to take a look at the logfiles for the application (by default this
    will be in log/production.log in the folder where the rails app is checked
    out). This should have more information about the error. For example
    perhaps one of the services on the server didn't start up when you
    restarted the server.

    Fred
    --
    You received this message because you are subscribed to the Google
    Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send
    an email to rubyonrails-ta...@googlegroups.com.
    To post to this group, send email to rubyonra...@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/
    msgid/rubyonrails-talk/b7a4f0b6-0b38-44da-9317-
    1d1109a050fa%40googlegroups.com<https://groups.google.com/d/msgid/rubyonrails-talk/b7a4f0b6-0b38-44da-9317-1d1109a050fa%40googlegroups.com?utm_medium=email&utm_source=footer>
    .
    For more options, visit https://groups.google.com/d/optout.

    --
    You received this message because you are subscribed to the Google Groups
    "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send an
    email to rubyonrails-ta...@googlegroups.com <javascript:>.
    To post to this group, send email to rubyonra...@googlegroups.com<javascript:>
    .
    To view this discussion on the web visit
    https://groups.google.com/d/msgid/rubyonrails-talk/1a0bf482-341a-437f-b8fb-fca3840fac50%40googlegroups.com<https://groups.google.com/d/msgid/rubyonrails-talk/1a0bf482-341a-437f-b8fb-fca3840fac50%40googlegroups.com?utm_medium=email&utm_source=footer>
    .

    For more options, visit https://groups.google.com/d/optout.
    --
    You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
    To post to this group, send email to rubyonrails-talk@googlegroups.com.
    To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/63e88c88-a8a6-4728-ab5e-d53e1b4834ff%40googlegroups.com.
    For more options, visit https://groups.google.com/d/optout.
  • Tommaso Visconti at Apr 17, 2014 at 3:27 pm
    Check line 16 in app/controllers/static_pages_
    controller.rb, that line produces the query which causes the error.



    2014-04-17 17:20 GMT+02:00 Ead <dai2809@gmail.com>:
    I could only run the website from the development and production branches
    of the VPS server as my local machine did not have an environment that
    could run Ruby files.
    Before the reboot, the site ran perfectly from the server, so I just
    cannot start thinking how I could go about debugging this.

    On Friday, 18 April 2014 00:14:23 UTC+9, Tommaso Visconti wrote:

    are you sure the app works outside the server (e.g. in your development
    machine)?


    2014-04-17 17:12 GMT+02:00 Ead <dai...@gmail.com>:
    Thank you for the reply. Running rake db:migrate returns the message
    below:


    rake aborted!
    No Rakefile found (looking for: rakefile, Rakefile, rakefile.rb,
    Rakefile.rb)
    /home/tadashi-toyokura/.rvm/gems/ruby-2.0.0-p247/bin/ruby_noexec_wrapper:14:in
    `eval'
    /home/tadashi-toyokura/.rvm/gems/ruby-2.0.0-p247/bin/ruby_noexec_wrapper:14:in
    `<main>'
    (See full trace by running task with --trace)

    The other engineer has not done anything with the databases and I'm
    completely stuck. Some more advice would be deeply appreciated.

    Best regards,

    Ead

    On Friday, 18 April 2014 00:05:03 UTC+9, Mike Villa wrote:

    New migration? Check with the last engineer who checked in code. Might
    need to update ur database rake db:migrate. Someone who is familiar with or
    db should do that. Check with ur db admin first too

    Sent from my iPhone

    On Apr 17, 2014, at 7:45 AM, Ead wrote:

    Thank you so much for the reply. The below is the top portion of the
    production.log.
    It shows 500 Internal Server Error at the 5th line from the top. I
    don't understand the cause of the error because
    hardly anything has changed since the time before the boot. I would be
    every so grateful if you would could suggest any potential solutions.


    Connecting to database specified by database.yml
    Connecting to database specified by database.yml
    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:20 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 109ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "registers"
    does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
    ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
    pg_get_expr(d.adbin, d.adrelid), a.attnotnull,
    a.atttypid, a.atttypmod
    FROM pg_attribute a LEFT JOIN pg_attrdef d
    ON a.attrelid = d.adrelid AND a.attnum = d.adnum
    WHERE a.attrelid = '"registers"'::regclass
    AND a.attnum > 0 AND NOT a.attisdropped
    ORDER BY a.attnum
    ):
    app/controllers/static_pages_controller.rb:16:in `new'
    app/controllers/static_pages_controller.rb:16:in `register'


    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:22 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 113ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "registers"
    does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
    ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
    pg_get_expr(d.adbin, d.adrelid), a.attnotnull,
    a.atttypid, a.atttypmod
    FROM pg_attribute a LEFT JOIN pg_attrdef d
    ON a.attrelid = d.adrelid AND a.attnum = d.adnum
    WHERE a.attrelid = '"registers"'::regclass
    AND a.attnum > 0 AND NOT a.attisdropped
    ORDER BY a.attnum
    ):
    app/controllers/static_pages_controller.rb:16:in `new'
    app/controllers/static_pages_controller.rb:16:in `register'


    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:23 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 1ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "registers"
    does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
    ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
    pg_get_expr(d.adbin, d.adrelid), a.attnotnull,
    a.atttypid, a.atttypmod
    FROM pg_attribute a LEFT JOIN pg_attrdef d
    ON a.attrelid = d.adrelid AND a.attnum = d.adnum
    WHERE a.attrelid = '"registers"'::regclass
    AND a.attnum > 0 AND NOT a.attisdropped
    ORDER BY a.attnum
    ):
    app/controllers/static_pages_controller.rb:16:in `new'
    app/controllers/static_pages_controller.rb:16:in `register'

    On Thursday, 17 April 2014 23:28:45 UTC+9, Frederick Cheung wrote:


    On Thursday, April 17, 2014 3:25:38 PM UTC+1, Ead wrote:

    Hello everyone

    I am desperately in need of help because a website created by Ruby on
    Rails has gone down after remotely rebooting a VPS server.
    The site is this: http://offeriland.com/

    I could not let update reflect in the site, so I rebooted the site
    using the web host's remote VPS control system. The site now only displays
    ' We're sorry, but something went wrong.'
    I have searched across the web for a solution with no luck.
    This isn't solvable without more information. The first step would for
    you to take a look at the logfiles for the application (by default this
    will be in log/production.log in the folder where the rails app is checked
    out). This should have more information about the error. For example
    perhaps one of the services on the server didn't start up when you
    restarted the server.

    Fred
    --
    You received this message because you are subscribed to the Google
    Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send
    an email to rubyonrails-ta...@googlegroups.com.
    To post to this group, send email to rubyonra...@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/ms
    gid/rubyonrails-talk/b7a4f0b6-0b38-44da-9317-1d1109a050fa%
    40googlegroups.com<https://groups.google.com/d/msgid/rubyonrails-talk/b7a4f0b6-0b38-44da-9317-1d1109a050fa%40googlegroups.com?utm_medium=email&utm_source=footer>
    .
    For more options, visit https://groups.google.com/d/optout.

    --
    You received this message because you are subscribed to the Google
    Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send
    an email to rubyonrails-ta...@googlegroups.com.
    To post to this group, send email to rubyonra...@googlegroups.com.
    To view this discussion on the web visit https://groups.google.com/d/
    msgid/rubyonrails-talk/1a0bf482-341a-437f-b8fb-
    fca3840fac50%40googlegroups.com<https://groups.google.com/d/msgid/rubyonrails-talk/1a0bf482-341a-437f-b8fb-fca3840fac50%40googlegroups.com?utm_medium=email&utm_source=footer>
    .

    For more options, visit https://groups.google.com/d/optout.
    --
    You received this message because you are subscribed to the Google Groups
    "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send an
    email to rubyonrails-talk+unsubscribe@googlegroups.com.
    To post to this group, send email to rubyonrails-talk@googlegroups.com.
    To view this discussion on the web visit
    https://groups.google.com/d/msgid/rubyonrails-talk/63e88c88-a8a6-4728-ab5e-d53e1b4834ff%40googlegroups.com<https://groups.google.com/d/msgid/rubyonrails-talk/63e88c88-a8a6-4728-ab5e-d53e1b4834ff%40googlegroups.com?utm_medium=email&utm_source=footer>
    .

    For more options, visit https://groups.google.com/d/optout.
    --
    You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
    To post to this group, send email to rubyonrails-talk@googlegroups.com.
    To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CAK4fz2riUs15BStziWjiChM7oFkjbxqLCfJ0LynBG7NMm_x2Tg%40mail.gmail.com.
    For more options, visit https://groups.google.com/d/optout.
  • Hassan Schroeder at Apr 17, 2014 at 3:36 pm

    On Thu, Apr 17, 2014 at 7:45 AM, Ead wrote:

    hardly anything has changed since the time before the boot.
    Uh, "hardly anything"? Then you should go through each one of the
    "hardly anythings" to be sure they're not causing this.
    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "registers" does
    not exist
    Are you connecting to the correct database instance?

    Does your development instance run (and if so are you sure that it's
    identical to the current production deployment)?

    Do your tests run?

    --
    Hassan Schroeder ------------------------ hassan.schroeder@gmail.com
    http://about.me/hassanschroeder
    twitter: @hassan

    --
    You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
    To post to this group, send email to rubyonrails-talk@googlegroups.com.
    To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CACmC4yCeJkg1pvPojhA4HqKR9uthQbQCCYPqr9EXL3zBB%3DWy0A%40mail.gmail.com.
    For more options, visit https://groups.google.com/d/optout.
  • Ead at Apr 17, 2014 at 3:38 pm
    Thank you, I appreciate the suggestion. I have checked the file under
    question and here's the code up to the 16th line:

    class StaticPagesController < ApplicationController
       before_filter :hide_nav, only: [:forgots_password, :send_new_password,
    :client_forgots_password, :client_send_new_password]
       before_filter :get_contents, only: [:home, :about_timeline,
    :user_about_timeline]

       def about_timeline
         if mobile_device?
           render "static_pages/mobile/about_timeline", layout:
    "application-mobile"
         end
       end

       def user_about_timeline
         if signed_in?
           @user = current_user
           @user_info = @user.user_info
           @user_posts = @user.user_posts.includes(:user)


    The line 16 says @user_posts = @user.user_posts.includes(:user) but I
    cannot figure what is incorrect with this no matter how.
    Please help me understand what of the line could induce the error.

    Thank you,

    Ead
    On Friday, 18 April 2014 00:27:30 UTC+9, Tommaso Visconti wrote:

    Check line 16 in app/controllers/static_pages_
    controller.rb, that line produces the query which causes the error.



    2014-04-17 17:20 GMT+02:00 Ead <dai...@gmail.com <javascript:>>:
    I could only run the website from the development and production branches
    of the VPS server as my local machine did not have an environment that
    could run Ruby files.
    Before the reboot, the site ran perfectly from the server, so I just
    cannot start thinking how I could go about debugging this.

    On Friday, 18 April 2014 00:14:23 UTC+9, Tommaso Visconti wrote:

    are you sure the app works outside the server (e.g. in your development
    machine)?


    2014-04-17 17:12 GMT+02:00 Ead <dai...@gmail.com>:
    Thank you for the reply. Running rake db:migrate returns the message
    below:


    rake aborted!
    No Rakefile found (looking for: rakefile, Rakefile, rakefile.rb,
    Rakefile.rb)
    /home/tadashi-toyokura/.rvm/gems/ruby-2.0.0-p247/bin/ruby_noexec_wrapper:14:in
    `eval'
    /home/tadashi-toyokura/.rvm/gems/ruby-2.0.0-p247/bin/ruby_noexec_wrapper:14:in
    `<main>'
    (See full trace by running task with --trace)

    The other engineer has not done anything with the databases and I'm
    completely stuck. Some more advice would be deeply appreciated.

    Best regards,

    Ead

    On Friday, 18 April 2014 00:05:03 UTC+9, Mike Villa wrote:

    New migration? Check with the last engineer who checked in code. Might
    need to update ur database rake db:migrate. Someone who is familiar with or
    db should do that. Check with ur db admin first too

    Sent from my iPhone

    On Apr 17, 2014, at 7:45 AM, Ead wrote:

    Thank you so much for the reply. The below is the top portion of the
    production.log.
    It shows 500 Internal Server Error at the 5th line from the top. I
    don't understand the cause of the error because
    hardly anything has changed since the time before the boot. I would be
    every so grateful if you would could suggest any potential solutions.


    Connecting to database specified by database.yml
    Connecting to database specified by database.yml
    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:20 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 109ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation
    "registers" does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
    ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
    pg_get_expr(d.adbin, d.adrelid), a.attnotnull,
    a.atttypid, a.atttypmod
    FROM pg_attribute a LEFT JOIN pg_attrdef d
    ON a.attrelid = d.adrelid AND a.attnum = d.adnum
    WHERE a.attrelid = '"registers"'::regclass
    AND a.attnum > 0 AND NOT a.attisdropped
    ORDER BY a.attnum
    ):
    app/controllers/static_pages_controller.rb:16:in `new'
    app/controllers/static_pages_controller.rb:16:in `register'


    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:22 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 113ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation
    "registers" does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
    ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
    pg_get_expr(d.adbin, d.adrelid), a.attnotnull,
    a.atttypid, a.atttypmod
    FROM pg_attribute a LEFT JOIN pg_attrdef d
    ON a.attrelid = d.adrelid AND a.attnum = d.adnum
    WHERE a.attrelid = '"registers"'::regclass
    AND a.attnum > 0 AND NOT a.attisdropped
    ORDER BY a.attnum
    ):
    app/controllers/static_pages_controller.rb:16:in `new'
    app/controllers/static_pages_controller.rb:16:in `register'


    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:23 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 1ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation
    "registers" does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
    ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
    pg_get_expr(d.adbin, d.adrelid), a.attnotnull,
    a.atttypid, a.atttypmod
    FROM pg_attribute a LEFT JOIN pg_attrdef d
    ON a.attrelid = d.adrelid AND a.attnum = d.adnum
    WHERE a.attrelid = '"registers"'::regclass
    AND a.attnum > 0 AND NOT a.attisdropped
    ORDER BY a.attnum
    ):
    app/controllers/static_pages_controller.rb:16:in `new'
    app/controllers/static_pages_controller.rb:16:in `register'

    On Thursday, 17 April 2014 23:28:45 UTC+9, Frederick Cheung wrote:


    On Thursday, April 17, 2014 3:25:38 PM UTC+1, Ead wrote:

    Hello everyone

    I am desperately in need of help because a website created by Ruby
    on Rails has gone down after remotely rebooting a VPS server.
    The site is this: http://offeriland.com/

    I could not let update reflect in the site, so I rebooted the site
    using the web host's remote VPS control system. The site now only displays
    ' We're sorry, but something went wrong.'
    I have searched across the web for a solution with no luck.
    This isn't solvable without more information. The first step would
    for you to take a look at the logfiles for the application (by default this
    will be in log/production.log in the folder where the rails app is checked
    out). This should have more information about the error. For example
    perhaps one of the services on the server didn't start up when you
    restarted the server.

    Fred
    --
    You received this message because you are subscribed to the Google
    Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send
    an email to rubyonrails-ta...@googlegroups.com.
    To post to this group, send email to rubyonra...@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/
    msgid/rubyonrails-talk/b7a4f0b6-0b38-44da-9317-1d1109a050fa%
    40googlegroups.com<https://groups.google.com/d/msgid/rubyonrails-talk/b7a4f0b6-0b38-44da-9317-1d1109a050fa%40googlegroups.com?utm_medium=email&utm_source=footer>
    .
    For more options, visit https://groups.google.com/d/optout.

    --
    You received this message because you are subscribed to the Google
    Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send
    an email to rubyonrails-ta...@googlegroups.com.
    To post to this group, send email to rubyonra...@googlegroups.com.
    To view this discussion on the web visit https://groups.google.com/d/
    msgid/rubyonrails-talk/1a0bf482-341a-437f-b8fb-
    fca3840fac50%40googlegroups.com<https://groups.google.com/d/msgid/rubyonrails-talk/1a0bf482-341a-437f-b8fb-fca3840fac50%40googlegroups.com?utm_medium=email&utm_source=footer>
    .

    For more options, visit https://groups.google.com/d/optout.
    --
    You received this message because you are subscribed to the Google Groups
    "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send an
    email to rubyonrails-ta...@googlegroups.com <javascript:>.
    To post to this group, send email to rubyonra...@googlegroups.com<javascript:>
    .
    To view this discussion on the web visit
    https://groups.google.com/d/msgid/rubyonrails-talk/63e88c88-a8a6-4728-ab5e-d53e1b4834ff%40googlegroups.com<https://groups.google.com/d/msgid/rubyonrails-talk/63e88c88-a8a6-4728-ab5e-d53e1b4834ff%40googlegroups.com?utm_medium=email&utm_source=footer>
    .

    For more options, visit https://groups.google.com/d/optout.
    --
    You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
    To post to this group, send email to rubyonrails-talk@googlegroups.com.
    To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/8faa1df3-828d-4a01-bb33-f257f42b1dd0%40googlegroups.com.
    For more options, visit https://groups.google.com/d/optout.
  • Colin Law at Apr 17, 2014 at 3:39 pm

    On 17 April 2014 16:12, Ead wrote:
    Thank you for the reply. Running rake db:migrate returns the message below:


    rake aborted!
    No Rakefile found (looking for: rakefile, Rakefile, rakefile.rb,
    Rakefile.rb)
    Were you in the correct folder when you run that. You should be in the
    top level folder of the rails application (the folder with app,
    config, db and so on).

    Colin

    --
    You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
    To post to this group, send email to rubyonrails-talk@googlegroups.com.
    To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CAL%3D0gLs5iuGdCxqbSSJ2PjzLwoByP3KhRZjratso2VZDqVXimg%40mail.gmail.com.
    For more options, visit https://groups.google.com/d/optout.
  • Dai Nish at Apr 17, 2014 at 3:43 pm
    The only change made to the production environment was an addition of a CSS
    class to correct the layout of a breadcrumb list,
    and I'm finding no difference between static_pages_controller.rb and other
    files. The test server is http://dev.offeriland.com:81/ being hosted in the
    same VPS server
    and does not run likewise.

    I don't have a good knowledge of databases at all, so some more advice
    would be grateful.

    Best regards,

    Ead


    On 18 April 2014 00:36, Hassan Schroeder wrote:
    On Thu, Apr 17, 2014 at 7:45 AM, Ead wrote:

    hardly anything has changed since the time before the boot.
    Uh, "hardly anything"? Then you should go through each one of the
    "hardly anythings" to be sure they're not causing this.
    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation "registers" does
    not exist
    Are you connecting to the correct database instance?

    Does your development instance run (and if so are you sure that it's
    identical to the current production deployment)?

    Do your tests run?

    --
    Hassan Schroeder ------------------------ hassan.schroeder@gmail.com
    http://about.me/hassanschroeder
    twitter: @hassan

    --
    You received this message because you are subscribed to a topic in the
    Google Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this topic, visit
    https://groups.google.com/d/topic/rubyonrails-talk/dlzs7ngycmI/unsubscribe
    .
    To unsubscribe from this group and all its topics, send an email to
    rubyonrails-talk+unsubscribe@googlegroups.com.
    To post to this group, send email to rubyonrails-talk@googlegroups.com.
    To view this discussion on the web visit
    https://groups.google.com/d/msgid/rubyonrails-talk/CACmC4yCeJkg1pvPojhA4HqKR9uthQbQCCYPqr9EXL3zBB%3DWy0A%40mail.gmail.com
    .
    For more options, visit https://groups.google.com/d/optout.
    --
    You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
    To post to this group, send email to rubyonrails-talk@googlegroups.com.
    To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CA%2BqQ%2B_G36oEDSJfJ83JbE4MsJTtQX-3bHbukN4s-WwLSma65NA%40mail.gmail.com.
    For more options, visit https://groups.google.com/d/optout.
  • Hassan Schroeder at Apr 17, 2014 at 4:45 pm

    On Thu, Apr 17, 2014 at 8:43 AM, Dai Nish wrote:

    I don't have a good knowledge of databases at all, so some more advice would
    be grateful.
    First piece of advice: stop top-posting, and answer the questions
    already asked.
    Are you connecting to the correct database instance?
    Do your tests run?
    --
    Hassan Schroeder ------------------------ hassan.schroeder@gmail.com
    http://about.me/hassanschroeder
    twitter: @hassan

    --
    You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
    To post to this group, send email to rubyonrails-talk@googlegroups.com.
    To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CACmC4yDF-2w2YiDdDfq-gWHF2D2uz12_JzaY2SuucWUWijtDuQ%40mail.gmail.com.
    For more options, visit https://groups.google.com/d/optout.
  • Ead at Apr 17, 2014 at 9:58 pm
    I've tried checked the database instance with Putty by running "psql mydb"
    in its terminal, but the message below was returned where xyz-abcde is the
    ID I entered to authenticate to the Linux server:

    psql: FATAL: role "xyz-abcde" does not exist

    The other engineer told me the server runs Postgres but I'm not familiar
    with database administration and advice on how to verify what database
    instance you're connected to would be really appreciated.

    Best regards,

    Ead

    On Friday, 18 April 2014 01:45:17 UTC+9, Hassan Schroeder wrote:

    On Thu, Apr 17, 2014 at 8:43 AM, Dai Nish <dai...@gmail.com <javascript:>>
    wrote:
    I don't have a good knowledge of databases at all, so some more advice would
    be grateful.
    First piece of advice: stop top-posting, and answer the questions
    already asked.
    Are you connecting to the correct database instance?
    Do your tests run?
    --
    Hassan Schroeder ------------------------ hassan.s...@gmail.com<javascript:>
    http://about.me/hassanschroeder
    twitter: @hassan
    --
    You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
    To post to this group, send email to rubyonrails-talk@googlegroups.com.
    To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/c72e0d06-cca8-4e75-854a-a99317cbfc85%40googlegroups.com.
    For more options, visit https://groups.google.com/d/optout.
  • Ead at Apr 17, 2014 at 10:13 pm
    Thank you. I've just changed the directory to 'db', run 'rake db:migrate'
    to find no error, then run 'rake db:migrate RAILS_ENV=production' to
    reflect any possible changes to the live server,
    but the same error message 'We're sorry, but something went wrong' still
    appears..

    Regards,

    Ead

    On Friday, 18 April 2014 00:38:48 UTC+9, Colin Law wrote:
    On 17 April 2014 16:12, Ead <dai...@gmail.com <javascript:>> wrote:
    Thank you for the reply. Running rake db:migrate returns the message below:

    rake aborted!
    No Rakefile found (looking for: rakefile, Rakefile, rakefile.rb,
    Rakefile.rb)
    Were you in the correct folder when you run that. You should be in the
    top level folder of the rails application (the folder with app,
    config, db and so on).

    Colin
    --
    You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
    To post to this group, send email to rubyonrails-talk@googlegroups.com.
    To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/08ca4d41-3099-4e11-b25f-4442899ef8a1%40googlegroups.com.
    For more options, visit https://groups.google.com/d/optout.
  • Ead at Apr 17, 2014 at 11:25 pm
    Apologies, the code from static_pages_controller.rb below only shows up to
    line 15. Line 16 reads as follows:

    @ordered_industries_name_hash = @user.ordered_industries_name_hash

    I can't understand what production.log is saying about this line...
    On Friday, 18 April 2014 00:38:51 UTC+9, Ead wrote:

    Thank you, I appreciate the suggestion. I have checked the file under
    question and here's the code up to the 16th line:

    class StaticPagesController < ApplicationController
    before_filter :hide_nav, only: [:forgots_password, :send_new_password,
    :client_forgots_password, :client_send_new_password]
    before_filter :get_contents, only: [:home, :about_timeline,
    :user_about_timeline]

    def about_timeline
    if mobile_device?
    render "static_pages/mobile/about_timeline", layout:
    "application-mobile"
    end
    end

    def user_about_timeline
    if signed_in?
    @user = current_user
    @user_info = @user.user_info
    @user_posts = @user.user_posts.includes(:user)


    The line 16 says @user_posts = @user.user_posts.includes(:user) but I
    cannot figure what is incorrect with this no matter how.
    Please help me understand what of the line could induce the error.

    Thank you,

    Ead
    On Friday, 18 April 2014 00:27:30 UTC+9, Tommaso Visconti wrote:

    Check line 16 in app/controllers/static_pages_
    controller.rb, that line produces the query which causes the error.



    2014-04-17 17:20 GMT+02:00 Ead <dai...@gmail.com>:
    I could only run the website from the development and production
    branches of the VPS server as my local machine did not have an environment
    that could run Ruby files.
    Before the reboot, the site ran perfectly from the server, so I just
    cannot start thinking how I could go about debugging this.

    On Friday, 18 April 2014 00:14:23 UTC+9, Tommaso Visconti wrote:

    are you sure the app works outside the server (e.g. in your development
    machine)?


    2014-04-17 17:12 GMT+02:00 Ead <dai...@gmail.com>:
    Thank you for the reply. Running rake db:migrate returns the message
    below:


    rake aborted!
    No Rakefile found (looking for: rakefile, Rakefile, rakefile.rb,
    Rakefile.rb)
    /home/tadashi-toyokura/.rvm/gems/ruby-2.0.0-p247/bin/ruby_noexec_wrapper:14:in
    `eval'
    /home/tadashi-toyokura/.rvm/gems/ruby-2.0.0-p247/bin/ruby_noexec_wrapper:14:in
    `<main>'
    (See full trace by running task with --trace)

    The other engineer has not done anything with the databases and I'm
    completely stuck. Some more advice would be deeply appreciated.

    Best regards,

    Ead

    On Friday, 18 April 2014 00:05:03 UTC+9, Mike Villa wrote:

    New migration? Check with the last engineer who checked in code.
    Might need to update ur database rake db:migrate. Someone who is familiar
    with or db should do that. Check with ur db admin first too

    Sent from my iPhone

    On Apr 17, 2014, at 7:45 AM, Ead wrote:

    Thank you so much for the reply. The below is the top portion of the
    production.log.
    It shows 500 Internal Server Error at the 5th line from the top. I
    don't understand the cause of the error because
    hardly anything has changed since the time before the boot. I would
    be every so grateful if you would could suggest any potential solutions.


    Connecting to database specified by database.yml
    Connecting to database specified by database.yml
    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:20 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 109ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation
    "registers" does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
    ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
    pg_get_expr(d.adbin, d.adrelid), a.attnotnull,
    a.atttypid, a.atttypmod
    FROM pg_attribute a LEFT JOIN pg_attrdef d
    ON a.attrelid = d.adrelid AND a.attnum = d.adnum
    WHERE a.attrelid = '"registers"'::regclass
    AND a.attnum > 0 AND NOT a.attisdropped
    ORDER BY a.attnum
    ):
    app/controllers/static_pages_controller.rb:16:in `new'
    app/controllers/static_pages_controller.rb:16:in `register'


    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:22 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 113ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation
    "registers" does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
    ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
    pg_get_expr(d.adbin, d.adrelid), a.attnotnull,
    a.atttypid, a.atttypmod
    FROM pg_attribute a LEFT JOIN pg_attrdef d
    ON a.attrelid = d.adrelid AND a.attnum = d.adnum
    WHERE a.attrelid = '"registers"'::regclass
    AND a.attnum > 0 AND NOT a.attisdropped
    ORDER BY a.attnum
    ):
    app/controllers/static_pages_controller.rb:16:in `new'
    app/controllers/static_pages_controller.rb:16:in `register'


    Started GET "/teaser" for 153.120.196.200 at 2013-07-11 17:26:23 +0900
    Processing by StaticPagesController#register as HTML
    Completed 500 Internal Server Error in 1ms

    ActiveRecord::StatementInvalid (PG::Error: ERROR: relation
    "registers" does not exist
    LINE 5: WHERE a.attrelid = '"registers"'::regclass
    ^
    : SELECT a.attname, format_type(a.atttypid, a.atttypmod),
    pg_get_expr(d.adbin, d.adrelid), a.attnotnull,
    a.atttypid, a.atttypmod
    FROM pg_attribute a LEFT JOIN pg_attrdef d
    ON a.attrelid = d.adrelid AND a.attnum = d.adnum
    WHERE a.attrelid = '"registers"'::regclass
    AND a.attnum > 0 AND NOT a.attisdropped
    ORDER BY a.attnum
    ):
    app/controllers/static_pages_controller.rb:16:in `new'
    app/controllers/static_pages_controller.rb:16:in `register'

    On Thursday, 17 April 2014 23:28:45 UTC+9, Frederick Cheung wrote:


    On Thursday, April 17, 2014 3:25:38 PM UTC+1, Ead wrote:

    Hello everyone

    I am desperately in need of help because a website created by Ruby
    on Rails has gone down after remotely rebooting a VPS server.
    The site is this: http://offeriland.com/

    I could not let update reflect in the site, so I rebooted the site
    using the web host's remote VPS control system. The site now only displays
    ' We're sorry, but something went wrong.'
    I have searched across the web for a solution with no luck.
    This isn't solvable without more information. The first step would
    for you to take a look at the logfiles for the application (by default this
    will be in log/production.log in the folder where the rails app is checked
    out). This should have more information about the error. For example
    perhaps one of the services on the server didn't start up when you
    restarted the server.

    Fred
    --
    You received this message because you are subscribed to the Google
    Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it,
    send an email to rubyonrails-ta...@googlegroups.com.
    To post to this group, send email to rubyonra...@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/
    msgid/rubyonrails-talk/b7a4f0b6-0b38-44da-9317-1d1109a050fa%
    40googlegroups.com<https://groups.google.com/d/msgid/rubyonrails-talk/b7a4f0b6-0b38-44da-9317-1d1109a050fa%40googlegroups.com?utm_medium=email&utm_source=footer>
    .
    For more options, visit https://groups.google.com/d/optout.

    --
    You received this message because you are subscribed to the Google
    Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send
    an email to rubyonrails-ta...@googlegroups.com.
    To post to this group, send email to rubyonra...@googlegroups.com.
    To view this discussion on the web visit https://groups.google.com/d/
    msgid/rubyonrails-talk/1a0bf482-341a-437f-b8fb-
    fca3840fac50%40googlegroups.com<https://groups.google.com/d/msgid/rubyonrails-talk/1a0bf482-341a-437f-b8fb-fca3840fac50%40googlegroups.com?utm_medium=email&utm_source=footer>
    .

    For more options, visit https://groups.google.com/d/optout.
    --
    You received this message because you are subscribed to the Google
    Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send
    an email to rubyonrails-ta...@googlegroups.com.
    To post to this group, send email to rubyonra...@googlegroups.com.
    To view this discussion on the web visit
    https://groups.google.com/d/msgid/rubyonrails-talk/63e88c88-a8a6-4728-ab5e-d53e1b4834ff%40googlegroups.com<https://groups.google.com/d/msgid/rubyonrails-talk/63e88c88-a8a6-4728-ab5e-d53e1b4834ff%40googlegroups.com?utm_medium=email&utm_source=footer>
    .

    For more options, visit https://groups.google.com/d/optout.
    --
    You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
    To post to this group, send email to rubyonrails-talk@googlegroups.com.
    To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/01caf910-858f-42ea-9455-e238f51d1347%40googlegroups.com.
    For more options, visit https://groups.google.com/d/optout.
  • Ead at Apr 18, 2014 at 2:04 am
    It turns out that the server reboot had terminated Unicorn which failed to
    restart. Deleting unicorn.pid while making sure that this was not included
    in the processes restored the site.

    Best regards,

    Ead
    On Thursday, 17 April 2014 23:25:38 UTC+9, Ead wrote:

    Hello everyone

    I am desperately in need of help because a website created by Ruby on
    Rails has gone down after remotely rebooting a VPS server.
    The site is this: http://offeriland.com/

    I could not let update reflect in the site, so I rebooted the site using
    the web host's remote VPS control system. The site now only displays ' We're
    sorry, but something went wrong.'
    I have searched across the web for a solution with no luck.

    Please someone do help me.

    Best regards,

    Ead
    --
    You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
    To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
    To post to this group, send email to rubyonrails-talk@googlegroups.com.
    To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/2ce18e90-fe74-4ac9-b7fc-43485fb22d3f%40googlegroups.com.
    For more options, visit https://groups.google.com/d/optout.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouprubyonrails-talk @
categoriesrubyonrails
postedApr 17, '14 at 2:26p
activeApr 18, '14 at 2:04a
posts17
users6
websiterubyonrails.org
irc#RubyOnRails

People

Translate

site design / logo © 2022 Grokbase