User admin panel broken due to timestamp out of range

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.

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

1 Like

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.

2 Likes