Extension talk:ConfirmAccount

Jump to: navigation, search

About this board

Error 500 on Special:ConfirmAccounts Only

5 (talkcontribs)

This is the only page with the error. (talkcontribs)

This is the error: PHP Fatal error: Call to undefined method ConfirmAccountsPage::getLinkRenderer() in /home/user/public_html/wiki/extensions/ConfirmAccount/frontend/specialpages/actions/ConfirmAccount_body.php on line 211

Spas.Z.Spasov (talkcontribs)

Did you apply php $IP/maintenance/update.php?

Jlkzer (talkcontribs)

yes i run update.php but Special:ConfirmAccounts still show error 500 page

MikeDarling (talkcontribs)

What version of MediaWiki did this happen on? I get an Error 500 on the ConfirmAccounts page as well. I'm using MW 1.27.1.

Reply to "Error 500 on Special:ConfirmAccounts Only"
CalNation (talkcontribs)

Everytime I fill and click the request account button the page loads for a while before it goes blank. Log:

2017-10-18 01:40:16 fbc2b63702c5 wikidb: [71e6cc371daeb32c40983f62] /Special:RequestAccount   Wikimedia\Rdbms\DBQueryError from line 1075 of /var/www/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? 

 Query: INSERT  INTO `account_requests` (acr_id,acr_name,acr_email,acr_real_name,acr_registration,acr_bio,acr_notes,acr_urls,acr_type,acr_areas,acr_filename,acr_storage_key,acr_comment,acr_ip,acr_xff,acr_agent,acr_deleted,acr_email_token,acr_email_token_expires) VALUES (NULL,'Wawa','wawa@gmail.com','','20171018013815','','na','','0','',NULL,'wikidb:acctrequest:ip:','','','','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36','0','cdf2692dd4d49a49037dae473e6b92d3','20171117013815')

 Function: UserAccountRequest::insertOn

 Error: 1205 Lock wait timeout exceeded; try restarting transaction (percona)

 #0 /var/www/includes/libs/rdbms/database/Database.php(933): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

 #1 /var/www/includes/libs/rdbms/database/Database.php(1515): Wikimedia\Rdbms\Database->query(string, string)

 #2 /var/www/extensions/ConfirmAccount/backend/UserAccountRequest.php(358): Wikimedia\Rdbms\Database->insert(string, array, string)

 #3 /var/www/extensions/ConfirmAccount/business/AccountRequestSubmission.php(245): UserAccountRequest->insertOn()

 #4 /var/www/extensions/ConfirmAccount/frontend/specialpages/actions/RequestAccount_body.php(344): AccountRequestSubmission->submit(RequestContext)

 #5 /var/www/extensions/ConfirmAccount/frontend/specialpages/actions/RequestAccount_body.php(84): RequestAccountPage->doSubmit()

 #6 /var/www/includes/specialpage/SpecialPage.php(522): RequestAccountPage->execute(NULL)

 #7 /var/www/includes/specialpage/SpecialPageFactory.php(578): SpecialPage->run(NULL)

 #8 /var/www/includes/MediaWiki.php(287): SpecialPageFactory::executePath(Title, RequestContext)

 #9 /var/www/includes/MediaWiki.php(862): MediaWiki->performRequest()

 #10 /var/www/includes/MediaWiki.php(523): MediaWiki->main()

 #11 /var/www/index.php(43): MediaWiki->run()

 #12 {main}

Database schema updater was run more than once with no difference in results.

Reply to "Works with MW1.29?"

Avoiding initial email address confirmation

Tansaku (talkcontribs)

I've got ConfirmAccount working on a mediawiki instance (1.28.1) and I notice that there's an email address confirmation step that takes place *before* the account is approved. I'm wondering if that can be removed?

I think the email might easily be missed by the user trying to create their account, and there is an email to the address when the admin confirms the account that seems to serve the same purpose, i.e. they are being informed of their account approval and being asked to reset their password.

As it stands users have to receive two email and click through on them both before and after being confirmed by an admin. I'm wondering if there's some way to remove the first email since the second one would seem to be a sufficient check ...

Coyote897 (talkcontribs)

I think this is a good suggestion/request.

Huwmanbeing (talkcontribs)

Agreed: the first email address confirmation seems unnecessary and premature — the request may not even be granted.

It seems best simply to have the user submit a request, then (if approved) get a single email telling them they're in and giving instructions on how to proceed.

Reply to "Avoiding initial email address confirmation"
Loansindi (talkcontribs)

I'm running a wiki at work, and we're using the ConfirmAccount extension. One of my coworkers made a typo in his email address when making his request. The request was rejected, but he's unable to create another account with the same username (Management has requested a particular username scheme) because that rejected request is still sitting in the queue. Is there any way to delete that request so he can re-request with the correct email address?

Reply to "Remove pending request?"

Hook to add "request account" to personal urls is not working

1 (talkcontribs)

I added the code from the "Enhancements" section to my LocalSettings.php:

$wgHooks['PersonalUrls'][] = 'onPersonalUrls';

function onPersonalUrls( array &$personal_urls, Title $title, SkinTemplate $skin ) {

// Add a link to Special:RequestAccount if a link exists for login

if ( isset( $personal_urls['login'] ) || isset( $personal_urls['anonlogin'] ) ) {

$personal_urls['createaccount'] = array(

'text' => wfMessage( 'requestaccount' )->text(),

'href' => SpecialPage::getTitleFor( 'RequestAccount' )->getFullURL()



return true;


But I still do not see a link for "Request Account" in the upper right of my pages when the user is not logged in. I also made sure that the text "Request account" was added to MediaWiki:Requestaccount. I resaved the page to be sure.

I also have $wgGroupPermissions set to false for * createaccount

Is there something I am missing here? I am trying to make a private wiki where users can request accounts.

Reply to "Hook to add "request account" to personal urls is not working"
Obayda1757 (talkcontribs)

I uploaded my developed (in local server, using XAMPP) wiki site to linux web server using cPanel.

I have done following steps: 1) Create DB with user access 2) Import DB from old DB (using SQL format) 3) Upload MediaFile using file manager. 4) configure the "localsettings.php" file as given bellow...

But having the problem of "database connetion"

My site is here: databankbd.com/dbwiki


A database query error has occurred. This may indicate a bug in the software.

  • Query: SELECT lc_value FROM `databank_bddb1l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'deps' LIMIT 1
  • Function: LCStoreDB::get
  • Error: 1146 Table 'databank_bddb1.databank_bddb1l10n_cache' doesn't exist (localhost)
Reply to "Unable to connect DataBase"

Cannot whitelist "Special:RequestAccount"

Summary by Seb35

A tip to whitelist this special page.

JP8827 (talkcontribs)

First time user of MediaWiki. Trying to create a private Wiki (anonymous users cannot read/write until they sign-up). However, when accessing the RequestAccount page, the "Login Required" screen appears. I've whitelisted the RequestAccount, not sure what else needs to be done. v 1.27.1

$wgWhitelistRead =  array ("Main Page", "Special:UserLogin", "Special:RequestAccount", "-");

$wgGroupPermissions['*']['createaccount'] = true;

$wgGroupPermissions['*']['read'] = false;

$wgGroupPermissions['*']['edit'] = false;
Edwinalmeda (talkcontribs)

Whitelisting "Special:RequestAccount" willl not be needed since you have set the permissions of $wgGroupPermissions['*']['createaccount'] to true. which means that anyone can create an account.

Try setting $wgGroupPermissions['*']['createaccount'] = false;

to make requesting an account relevant

Seb35 (talkcontribs)

Indeed, this configuration is a bit weird. Note that, by default, there is $wgGroupPermissions['*']['createaccount'] = false; executed by this extension (see phabricator:diffusion/ECAC/browse/master/ConfirmAccount.config.php executed from phabricator:diffusion/ECAC/browse/master/ConfirmAccount.php

(I re-close the discussion anyway since no answer from the original author since almost one year.)

Seb35 (talkcontribs)

This was partly in the documentation and I have just added a precision.

PHP Fatal error: Uncaught DBUnexpectedError: Database::close: Got COMMIT while atomic sections AccountRequestSubmission::submit are still open

Summary by Seb35

Forgotgen update.php.

ChrisC~mediawikiwiki (talkcontribs)

On a new MediWiki 1.28.2 install running on Debian Stretch (Apache 2.4.25-3, mod_php 7.0.19 and MariaDB 10.1.23-9) with the following Extension:ConfirmAccount configuration:

require_once "$IP/extensions/ConfirmAccount/ConfirmAccount.php";
$wgConfirmAccountRequestFormItems = array(
        'UserName'        => array( 'enabled' => true ),
        'RealName'        => array( 'enabled' => true ),
        'Biography'       => array( 'enabled' => true, 'minWords' => 10 ),
        'AreasOfInterest' => array( 'enabled' => true ),
        'CV'              => array( 'enabled' => false ),
        'Notes'           => array( 'enabled' => false ),
        'Links'           => array( 'enabled' => true ),
        'TermsOfService'  => array( 'enabled' => true ),

When you request an account an error like this is generated for the user requesting an account:

Database error

A database query error has occurred. This may indicate a bug in the software.

[ff83f4da27ff532eecb2267e] 2017-06-20 19:35:14: Fatal exception of type "DBQueryError"

And the following error is generated in the Apache error log:

[Tue Jun 20 19:35:14.269289 2017] [:error] [pid 8564] [client XX.XX.XX.XX:54177] PHP Fatal error:  Uncaught DBUnexpectedError: Database::close: Got COMMIT while atomic sections AccountRequestSubmission::submit are still open. in /home/badge/sites/default/w/includes/libs/rdbms/database/Database.php:2756\nStack trace:\n#0 /home/badge/sites/default/w/includes/libs/rdbms/database/Database.php(708): Database->commit('Database::close', 'flush')\n#1 /home/badge/sites/default/w/includes/libs/rdbms/loadbalancer/LoadBalancer.php(976): Database->close()\n#2 /home/badge/sites/default/w/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1377): LoadBalancer->{closure}(Object(DatabaseMysqli))\n#3 /home/badge/sites/default/w/includes/libs/rdbms/loadbalancer/LoadBalancer.php(977): LoadBalancer->forEachOpenConnection(Object(Closure))\n#4 /home/badge/sites/default/w/includes/libs/rdbms/loadbalancer/LoadBalancer.php(968): LoadBalancer->closeAll()\n#5 /home/badge/sites/default/w/includes/libs/rdbms/loadbalancer/LoadBalancer.php(1556): LoadBalancer->disable()\n#6 [internal function]: LoadBalancer->__destruct()\n#7 {main}\n  thrown in /home/badge/sites/default/w/includes/libs/rdbms/database/Database.php on line 2756, referer: https://badge.wiki/wiki/Special:RequestAccount

Does anyone have any suggestions how to further debug or even solve this issue?

ChrisC~mediawikiwiki (talkcontribs)

So sorry I missed the need to run the update.php script in the install instructions to generate the database tables needed after running that the plugin works without an issue.

Jakeschroeder (talkcontribs)

It seems it is not possible to write custom css for the Request Account page because no html element on this page has an ID or a class name. I am creating my own skin and I want to be able to change the width of inputs, background color, etc. but I don't want to pollute those components' styles for the entire site.

For example I want the input's background color to be gray on the Request Account page but green on any other page. So how can access just the Request Account page's html elements in my stylesheet.

Thanks so much.

Reply to "Custom CSS for Request Account Page?" (talkcontribs)

Is there a way to limit the requesting users email to a particular domain, ie just .mil, or just .edu?

Reply to "Limiting the email to a domain"