Page MenuHomePhabricator

Special:ListUsers: Language::sprintfDate: The timestamp should have 14 characters
Open, Stalled, LowPublic

Description

This Special page works fine but when you want to look up only a certain group, except Active users or Bots list. You will get a [3c5b2754] YEAR-MONTH-DAY 24-HOUR-TIME Fatal exception of type MWException

This only occurs when looking only for administrators and bureaucrat.

Special:ListUsers&group=sysop
Special:ListUsers&group=bureaucrat


Version: 1.24rc
Severity: major
OS: Windows 7
Platform: PC

Details

Reference
bz54348

Related Objects

Event Timeline

bzimport raised the priority of this task from to Low.Nov 22 2014, 2:02 AM
bzimport set Reference to bz54348.
bzimport added a subscriber: Unknown Object (MLST).

Is this on a private wiki? See http://www.mediawiki.org/wiki/Manual:How_to_debug for how to get a stacktrace for that exception.

Okay. I have found the issue from the idea Andre gave me. Here is the line I got: /wiki/languages/Language.php on line 942

(In reply to comment #4)

What version of MediaWiki?

Mediawiki 1.21.2

(In reply to comment #3)

Okay. I have found the issue from the idea Andre gave me. Here is the line I
got: /wiki/languages/Language.php on line 942

Please include the full error message (It should have a message, plus about 9 lines of backtrace)

zdroid9770: Please include the full error message (It should have a message, plus about 9 lines of backtrace)

Unfortunately closing this report as no further information has been provided.

zdroid9770: Please feel free to reopen this report if you can provide the information asked for and if this still happens. Thanks!

I'm sorry for the late, ''late'' reply but here I am. Currently, it is still active as of Mediawiki 1.23.1. I have also got a full error message.

[ecd45e0e] /wiki/Special:ListUsers Exception from line 1139 of /home/host/public_html/wiki/languages/Language.php: Language::sprintfDate: The timestamp should have 14 characters

Backtrace:

#0 /home/host/public_html/wiki/languages/Language.php(2190): Language->sprintfDate(string, boolean)
#1 /home/host/public_html/wiki/languages/Language.php(2213): Language->internalUserTimeAndDate(string, string, User, array)
#2 /home/host/public_html/wiki/includes/specials/SpecialListusers.php(206): Language->userDate(string, User)
#3 /home/host/public_html/wiki/includes/Pager.php(445): UsersPager->formatRow(stdClass)
#4 /home/host/public_html/wiki/includes/specials/SpecialListusers.php(384): IndexPager->getBody()
#5 /home/host/public_html/wiki/includes/specialpage/SpecialPage.php(379): SpecialListUsers->execute(NULL)
#6 /home/host/public_html/wiki/includes/specialpage/SpecialPageFactory.php(503): SpecialPage->run(NULL)
#7 /home/host/public_html/wiki/includes/Wiki.php(285): SpecialPageFactory::executePath(Title, RequestContext)
#8 /home/host/public_html/wiki/includes/Wiki.php(588): MediaWiki->performRequest()
#9 /home/host/public_html/wiki/includes/Wiki.php(447): MediaWiki->main()
#10 /home/host/public_html/wiki/index.php(46): MediaWiki->run()
#11 {main}

If you need any more information, I won't hesitate to help out. :) This as become a real big irritation on my side.

zdroid9770: could you please run this query on your database and see if it returns any row?

select user_name, user_registration from user
where length(user_registration) <> 14 or user_registration is null;

If it returns rows, look at the user names, and think about how those accounts were created. Maybe by an extension?

And here is the message I got from MySQL. :)

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0017 sec)

Just to be clear - there are only 4 users registered on the wiki. No more for right now.

I'm using 1.24alpha and very interesting.

On guest mode (not login), the special page works just fine. When logging in to an account, it creates the Internal Error.

Just had a bit of a look at this. Nothing obvious going on here - even putting some fake user creation dates and time offsets in the DB didn't cause problems for me on master.

Have you tried the usual debugging steps on the latest version of MediaWiki (disabling all extensions, commenting out unusual configurations in LocalSettings, making sure all your files are up to date)? And you're saying it happens when you're logged in with any account (not just your own)?

Maybe the problem is with the Manual:Date formatting feature, although it seems to be dependent on the user language, since those options don't appear to me.

This comment was removed by Zdroid9770.
Aklapper changed the task status from Open to Stalled.Feb 15 2022, 9:05 PM
Aklapper added a project: TestMe.

@Zdroid9770: Is this still a problem in a supported MediaWiki version? If it is, which version? Thanks!