I went to edit a user today and I was presented with the following error: :frowning: Error while trying to load Something went wrong. Go Back Try Again I am unsure what the problem is, and did not make any major changes to discourse itself. New users work fine, just existing users. Any help would be appreciated.

Can you do it again with the browser’s developer tools network tab open and tell us what the erroring request(s) are?

GET http://example.com/admin/users/bryan.json?_=1436587808570 500 (Internal Server Error)Y.cors.e.crossDomain.send @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:2280J.extend.ajax @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:1874n @ _application-fa2de301309586b795c15c1b1f12731d.js:103_ @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:22270h @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:23328Discourse.Ajax.Em.Mixin.create.ajax @ _application-fa2de301309586b795c15c1b1f12731d.js:117r.reopenClass.find @ _admin-ba1f14c90da9460534ded85b6a9913c4.js:4889Discourse.User.extend.loadDetails @ _admin-ba1f14c90da9460534ded85b6a9913c4.js:4824e.default.Discourse.Route.extend.afterModel @ _admin-ba1f14c90da9460534ded85b6a9913c4.js:7053r @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:3365d @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:21743n.runSharedModelHook @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:19007n.runAfterModelHook @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:19007(anonymous function) @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:21270b @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:22255y @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:22040g @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:22194(anonymous function) @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:6693r.invoke @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:3364r.flush @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:3364n.flush @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:3364s.end @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:3364s.run @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:3364s.join @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:3364l.join @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:3365e.default.l.default.extend._bubbleEvent @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:13406(anonymous function) @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:13360J.event.dispatch @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:1874g.handle @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:1874 [object Object]Discourse.Route.extend.actions.error @ _application-fa2de301309586b795c15c1b1f12731d.js:79527C @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:4797l @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:21369i.trigger @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:20841(anonymous function) @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:20587b @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:22255y @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:22040g @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:22194p @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:22087(anonymous function) @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:6693r.invoke @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:3364r.flush @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:3364n.flush @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:3364s.end @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:3364s.run @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:3364l @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:3365a.error @ _application-fa2de301309586b795c15c1b1f12731d.js:83c @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:1874h.fireWith @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:1874r @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:1874(anonymous function) @ _vendor-68a043ffb30ca8b0ef68bf301d9c2efb.js:2267

Okay, so it’s a 500. What shows up in /logs ?

It seems that /logs doesn’t load. It is just sitting at a white page.

I still have no idea what is wrong. I rebuilt the app and restarted the server with no success.

I got the logs working. This is what happens every time it tries to load a user admin page. (!) PG::DatetimeFieldOverflow: ERROR: timestamp out of range: “2735892-07-09 17:17:08.646893 BC” LINE 1: …“user_histories”.“action” = 15 AND (created_at >= '2735892-0… ^ : SELECT 1 AS one FROM “user_histories” WHERE “user_histories”.“target_user_id” = 1 AND “user_histories”.“action” = 15 AND (created_at >= ‘2735892-07-09 17:17:08.646893 BC’) AND “user_histories”.“previous_value” = ‘2’ AND “user_histories”.“new_value” = ‘3’ LIMIT 1 (!!) ActiveRecord::StatementInvalid (PG::DatetimeFieldOverflow: ERROR: timestamp out of range: “2735892-07-09 17:17:08.646893 BC” LINE 1: …“user_histories”.“action” = 15 AND (created_at >= '2735892-0… ^ : SELECT 1 AS one FROM “user_histories” WHERE “user_histories”.“target_user_id” = 1 AND “user_histories”.“action” = 15 AND (created_at >= ‘2735892-07-09 17:17:08.646893 BC’) AND “user_histories”.“previous_value” = ‘2’ AND “user_histories”.“new_value” = ‘3’ LIMIT 1)

I found this thread and it fixed it. Thanks for your help guys. [image] Error While Trying to load, New and Admin accounts Support So whenever I try and access a users account from the ‘Users’ Tab on the admin panel I get this error. Error When trying to load, go back or retry It only happens on non ‘Normal User’ Accounts. aka, Admin Accounts, Mod accounts and new accounts. Though it should show there profile, there badges and allow me to change other settings. Any suggestions could be helpful ^.^ I tried upgrading my RAM I have 16 GB now instead of 1 and it still happens. @codinghorror Just saw that you frequent here …

User admin panel broken due to timestamp out of range

Product Support

codinghorror (Jeff Atwood) July 11, 2015, 9:36pm 7

There is another report of this so something might be up User admin panel fails to load after making a change - #4 by codinghorror

Topic		Replies	Views
Error While Trying to load, New and Admin accounts Product Support	14	3318	July 20, 2015
User admin panel fails to load after making a change Product Support	5	1675	July 13, 2015
The Git Hang and the Admin/Mod user Accs Oops Error Page Error Self-hosting login , bug	28	733	October 5, 2026
Lost all categories and admin access Product Support	10	505	June 21, 2024
Top Referred Topics shows "query taking too long" Product Support	9	682	July 27, 2020

User admin panel broken due to timestamp out of range

Related topics