User admin panel broken due to timestamp out of range

support
1

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.

2

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

3

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
4

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

5

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

6

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

7

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

1 Like
8

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)

9

I found this thread and it fixed it. Thanks for your help guys.

2 Likes