Extension talk:ConfirmAccount

Jump to: navigation, search

About this board


By clicking "Add topic", you agree to our Terms of Use and agree to irrevocably release your text under the CC BY-SA 3.0 License and GFDL

How to edit the request account page user prompts?

1
Rsoandrew (talkcontribs)

I have a very small wiki for a specific group. As part of the request account process, I require them to provide me with verifiable information proving they are in the group or otherwise has a specific interest. Also helps with spam. In a previous version of ConfirmAccount I could just edit the text RequestAccountPage.i18n.php file to change the prompts and get the user to add the information I need into the biography field.

When I upgraded to Mediawiki 1.28, I also had to reinstall ConfirmAccount. In the most recent version of ConfirmAccount, the file that I edited previously doesn't seem to exist and I can't figure out where the plain text prompt strings are stored.

Can somebody point me in the right direction?

Reply to "How to edit the request account page user prompts?"

MWException on Special:ConfirmAccounts

1
Jubi225 (talkcontribs)

Trying to confirm an account request I get stuck on an MWException (the wiki is in German but the exception appears in English too). It seems to be an error in the HTML form of real name (case?). Anyway, it doesn't matter if real name is enabled or disabled. I tried to fix that error for hours but I didn't find a solution anywhere so I hope to get help here. My code (MediaWiki as well as extensions) comes from the Wikimedia git repo (Rel 1.28).

Here is the error:

[0a0b20a113c1e8b11fa05393] /wiki/index.php?title=Spezial:Benutzerkonto_anlegen&AccountRequestId=5&wpName=Mxmstrmn&returnto=Spezial%3ABenutzerkonto_best%C3%A4tigen%2Fauthors&reason=Heureka   MWException from line 461 of /var/www/html/wiki/includes/htmlform/HTMLForm.php: Descriptor with no class for realname: Array

(

[default] => 

[readonly] => 1

[validation-callback] => Closure Object

(

[static] => Array

(

[accReq] => UserAccountRequest Object

(

[id:protected] => 5

[name:protected] => Mxmstrmn

[realName:protected] =>

...

)

...

Backtrace:

#0 /var/www/html/wiki/includes/htmlform/HTMLForm.php(481): HTMLForm::getClassFromDescriptor(string, array)

#1 /var/www/html/wiki/includes/htmlform/VFormHTMLForm.php(48): HTMLForm::loadInputFromParameters(string, array, VFormHTMLForm)

#2 /var/www/html/wiki/includes/htmlform/HTMLForm.php(336): VFormHTMLForm::loadInputFromParameters(string, array, VFormHTMLForm)

#3 /var/www/html/wiki/includes/libs/ObjectFactory.php(147): HTMLForm->__construct(array, RequestContext)

#4 /var/www/html/wiki/includes/htmlform/HTMLForm.php(281): ObjectFactory::constructClassInstance(string, array)

#5 /var/www/html/wiki/includes/specialpage/LoginSignupSpecialPage.php(663): HTMLForm::factory(string, array, RequestContext)

#6 /var/www/html/wiki/includes/specialpage/AuthManagerSpecialPage.php(402): LoginSignupSpecialPage->getAuthForm(array, string)

#7 /var/www/html/wiki/includes/specialpage/LoginSignupSpecialPage.php(305): AuthManagerSpecialPage->trySubmit()

#8 /var/www/html/wiki/includes/specialpage/SpecialPage.php(522): LoginSignupSpecialPage->execute(NULL)

#9 /var/www/html/wiki/includes/specialpage/SpecialPageFactory.php(576): SpecialPage->run(NULL)

#10 /var/www/html/wiki/includes/MediaWiki.php(283): SpecialPageFactory::executePath(Title, RequestContext)

#11 /var/www/html/wiki/includes/MediaWiki.php(851): MediaWiki->performRequest()

#12 /var/www/html/wiki/includes/MediaWiki.php(512): MediaWiki->main()

#13 /var/www/html/wiki/index.php(43): MediaWiki->run()

#14 {main}
Reply to "MWException on Special:ConfirmAccounts"

Error 500 on Special:ConfirmAccounts Only

3
68.53.246.183 (talkcontribs)

This is the only page with the error.

68.53.246.183 (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?

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

Is it possible to allow Real Name, but not make it compulsory?

Tinss (talkcontribs)

As far as I know, RealName is not required.

Reply to "Make "Real name" allowed, but optional?"

Internal error caused by broken apcu_set() calls

4
Summary by Spas.Z.Spasov
Spas.Z.Spasov (talkcontribs)

Hello Community,

I'm trying to setup ConfirmAccount with MediaWiki 1.28.0 on a Ubuntu Server 16.04 VPS. It looks like that ConfirmAccount works but with one exception. After clicking on Request account button Internal Error like next appears:

[WEXHLU98QLwAAARB@rcAAAAE] /index.php/Special:RequestAccount Error from line 75 of /var/www/mediawiki/includes/libs/objectcache/APCUBagOStuff.php: Call to undefined function apcu_set()

Backtrace:

#0 /var/www/mediawiki/extensions/ConfirmAccount/business/AccountRequestSubmission.php(271): APCUBagOStuff->incr(string)
#1 /var/www/mediawiki/includes/deferred/MWCallableUpdate.php(28): AccountRequestSubmission->{closure}()
#2 /var/www/mediawiki/includes/deferred/DeferredUpdates.php(263): MWCallableUpdate->doUpdate()
#3 /var/www/mediawiki/includes/deferred/DeferredUpdates.php(225): DeferredUpdates::runUpdate(MWCallableUpdate, LBFactorySimple, integer)
#4 /var/www/mediawiki/includes/deferred/DeferredUpdates.php(133): DeferredUpdates::execute(array, string, integer)
#5 /var/www/mediawiki/includes/MediaWiki.php(891): DeferredUpdates::doUpdates(string)
#6 /var/www/mediawiki/includes/MediaWiki.php(720): MediaWiki->restInPeace(string)
#7 /var/www/mediawiki/includes/MediaWiki.php(739): MediaWiki->{closure}()
#8 /var/www/mediawiki/includes/MediaWiki.php(543): MediaWiki->doPostOutputShutdown(string)
#9 /var/www/mediawiki/index.php(43): MediaWiki->run()
#10 {main}

Despite of this error the process is started and the new account can be confirmed. (I've used it previously on my home server with MW 1.27.1 and Ubuntu 16.04 - there it works fine).

Could someone help me to deal with this issue, please?

Spas.Z.Spasov (talkcontribs)

I've found that if I comment public function incr() and public function decr() in $IP/includes/libs/objectcache/APCBagOStuff.php and in $IP/includes/libs/objectcache/APCUBagOStuff.php this internal error message disappears. But this is not a true solution.

Aaron Schulz (talkcontribs)

I made https://gerrit.wikimedia.org/r/325516

Spas.Z.Spasov (talkcontribs)

This was really fast, I saw it early in the morning. Thank you, Aaron Schulz!

188.32.111.14 (talkcontribs)

$wgGroupPermissions['sysop']['createaccount'] = false; --> $wgGroupPermissions['*']['createaccount'] = false;

Seb35 (talkcontribs)

I don’t know what was the exact meaning of this and/or if the extension page was modified since, but it is written "Sysops can still create accounts directly. To disable this, add to LocalSettings.php: $wgGroupPermissions['sysop']['createaccount'] = false;" and it is correct: the extension disables the account creation (to replace it by an account request) and sysops can also create accounts.

Cannot whitelist "Special:RequestAccount"

2
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;

Seb35 (talkcontribs)

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

Fatal error: Call to undefined method ConfirmAccountsPage

4
Summary by Seb35

Extension version didn’t match MediaWiki version

93.108.232.91 (talkcontribs)

When trying to access the confirm account page, I'm getting this error: "Fatal error: Call to undefined method ConfirmAccountsPage::getLinkRenderer() in /var/www/mediawiki-1.27.1/extensions/ConfirmAccount/frontend/specialpages/actions/ConfirmAccount_body.php on line 211"

Mediawiki -1.27.1

PHP - 5.6

SO - CentOS 7.2

Apreciate any help provided.

Regards,

Jorge

93.108.232.91 (talkcontribs)

(line 211) $linkRenderer = $this->getLinkRenderer();

93.108.232.91 (talkcontribs)

With the latest version of the extension this problem is fixed!

Seb35 (talkcontribs)

If others experience this issue, it is a version mismatch between MediaWiki and the extension. For this specific issue MediaWiki 1.28 must be used (from what I deduce). More generally you should prefer the extension version corresponding to your MediaWiki version: with the ExtensionDistributor select the corresponding MW version, and with Git select the corresponding REL1_XX branch.

Error: mwstore://accountcreds-backend/accountcreds-public

2
Summary by Seb35

The user found the issue. Possibly linked also to Topic:Sf6zgc7plebtit4v.

Micgrote (talkcontribs)

Hi,

using MediaWiki 1.25.1 with ConfirmAccount-REL1_25-3d2b423 I have a problem with conforming new users enncountering the message above.

As we use a managed server I have no access to git. So the workaround to run "git checkout REL1_24" does not work.

The user and group for the directory images are are ok, the permissions are set to 755

Are there any other ideas?

Regards

Michael

Micgrote (talkcontribs)

Hello,

the solution is very easy: I installed ConfirmAccount-REL1_24-880bac5 and everything is fine.

Please ignore my request ;-)

Michael

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

23
OlivierCompagne (talkcontribs)

I installed ConfirmAccount, all went well. I updated the database via the web.

I tested the account request, and I rejected my test account, and it worked. Today someone requested an account; I wanted to accept it, but when I submit, it gives me that error message: "A database query error has occurred. This may indicate a bug in the software." See screenshot of the error page: http://screencast.com/t/lPU4IyEXjX

Can anyone help? I don't know what to do to fix this issue. Thanks!

FYI my environment info: MediaWiki 1.23.2 PHP 5.3.28 (cgi-fcgi) MySQL 5.1.67-rel14.3-log

128.250.26.189 (talkcontribs)

I have the same exact version and issue

Donkey Kong Genius (talkcontribs)

I have this error as well. As far as I can see everything about the confirm account extension seems to work. If I confirm an account to approve it, then I get the same error on the wiki page. Any one understanding this issue and willing to help?

91.61.79.41 (talkcontribs)

Same for me. I have this error for a few days. I deleted all my tables in the db and all files on my space so I have a complete clean installation. But I still can't install mediawiki.

No my error changes from the one above to: Function: DatabaseBase::sourceFile( /home/webpages/lima-city/wod-berlin/html/maintenance/tables.sql ) Error: 1146 Table 'db_287222_1.user' doesn't exist (mysql.lima-city.de)

So what am I supposed to do now?!

CookipediaChef~mediawikiwiki (talkcontribs)

I have the same problem on a new installation, though I have copied tables from another database. I'm now wondering if that's where the problem lies?

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

  • MW 1.24.0
  • PHP 5.3.3 (apache2handler)
  • mySQL 5.1.73
  • Confirm account – (75bdde7) 20:50, 12 November 2014

This post was posted by CookipediaChef~mediawikiwiki, but signed as CookipediaChef.

Nemo bis (talkcontribs)

Copied tables? And did you run update.php then?

88.106.73.51 (talkcontribs)

I have exactly same problem after upgrade to MW 1.24. Reinstalled confirmaccount, and run update.php but it's not helping

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

Query: INSERT INTO `y5m_account_credentials` (acd_user_id,acd_real_name,acd_email,acd_email_authenticated,acd_bio,acd_notes,acd_urls,acd_ip,acd_xff,acd_agent,acd_filename,acd_storage_key,acd_areas,acd_registration,acd_accepted,acd_user,acd_comment,acd_id) VALUES ('682','Ričardas','ryckaxxl60@gmail.com','20141202143609',,,,'78.62.161.58',,'Mozilla/5.0 (Windodws NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.125 Safari/537.36',NULL,'soft_escwiki-y5m_:acctrequest:ip:78.62.161.58',,'20141201022523','20141204123207','2',,NULL) Function: AccountConfirmSubmission::acceptRequest Error: 1054 Unknown column 'acd_xff' in 'field list' (localhost)

188.226.181.10 (talkcontribs)

Same: SELECT COUNT(*) FROM `account_requests` WHERE acr_type = '0' AND acr_deleted = '0' AND (acr_held IS NULL) LIMIT 1 1146 Table 'wiki.account_requests' doesn't exist (localhost)

Tymek1988 (talkcontribs)

So there is no way to fix it?

Aaron Schulz (talkcontribs)

ALTER TABLE /*_*/account_credentials ADD COLUMN acd_xff VARCHAR(255) NULL default ;

Grantbow (talkcontribs)

This did not fix my mediawiki 1.22.6 install.

159.50.16.166 (talkcontribs)

Same Problem. Read somewhere we can try to create these fields manually. Could someone give us the field definition ? (Type, attribute, Null, Default...) Thanks !

98.201.4.33 (talkcontribs)

I not only have that issue, but I'd get the same message when I clicked the Recent Changes link, until I commented out the extension.

75.175.9.66 (talkcontribs)

After upgrading from MW 1.19 to MW 1.23 and ConfirmAccount r115623 to REL1_23, I had to add the acd_xff and acd_agent fields, and I had to add them to account_requests, not account_credentials.

tl;dr: Run these in mysql, substituting your wiki's database name for wikidb:

USE wikidb;
ALTER TABLE mw_account_requests ADD acr_agent VARCHAR(255) NULL default '';''
ALTER TABLE mw_account_requests ADD acr_xff VARCHAR(255) NULL default '';''

There may be a better way to fix it. The underlying problem is that new fields added to ConfirmAccount across LTS version upgrades are not automatically added to the wiki database. Ideally, the extension would attempt to add necessary fields if they don't exist.

--

The error and backtrace:

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

Query:
INSERT INTO `mw_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,'Z','x@y.z','aowiefawe','20150712184313','Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum.','','','0','',NULL,'wikidb-mw_:acctrequest:ip:--.--.--.--','','--.--.--.--','','Mozilla/5.0 (X11; CrOS x86_64 6946.70.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/43.0.2357.132 Safari/537.36','0','--','20150811184313')''
Function: UserAccountRequest::insertOn
Error: 1054 Unknown column 'acr_xff' in 'field list' (localhost)
Backtrace:

#0 /var/www/wiki/includes/db/Database.php(1123): DatabaseBase->reportQueryError('Unknown column ...', 1054, 'INSERT  INTO `m...', 'UserAccountRequ...', false)
#1 /var/www/wiki/includes/db/Database.php(1920): DatabaseBase->query('INSERT  INTO `m...', 'UserAccountRequ...')
#2 /var/www/wiki/extensions/ConfirmAccount/backend/UserAccountRequest.php(358): DatabaseBase->insert('account_request...', Array, 'UserAccountRequ...')
#3 /var/www/wiki/extensions/ConfirmAccount/business/AccountRequestSubmission.php(243): UserAccountRequest->insertOn()
#4 /var/www/wiki/extensions/ConfirmAccount/frontend/specialpages/actions/RequestAccount_body.php(315): AccountRequestSubmission->submit(Object(RequestContext))
#5 /var/www/wiki/extensions/ConfirmAccount/frontend/specialpages/actions/RequestAccount_body.php(80): RequestAccountPage->doSubmit()
#6 /var/www/wiki/includes/specialpage/SpecialPage.php(379): RequestAccountPage->execute(NULL)
#7 /var/www/wiki/includes/specialpage/SpecialPageFactory.php(503): SpecialPage->run(NULL)
#8 /var/www/wiki/includes/Wiki.php(285): SpecialPageFactory::executePath(Object(Title), Object(RequestContext))
#9 /var/www/wiki/includes/Wiki.php(588): MediaWiki->performRequest()
#10 /var/www/wiki/includes/Wiki.php(447): MediaWiki->main()
#11 /var/www/wiki/index.php(46): MediaWiki->run()
#12 {main}

You can generate this message by adding these to the end of your wiki's LocalSettings.php file:

$wgShowSQLErrors = true;
$wgDebugDumpSql = true;
$wgShowDBErrorBacktrace = true;

--

Console I/O to fix it:

➜  ~  sudo mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1506962
Server version: 5.5.31-0ubuntu0.12.04.1 (Ubuntu)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use wikidb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> ALTER TABLE mw_account_requests ADD acr_agent VARCHAR(255) NULL default '';''
Query OK, 1 row affected (0.10 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> ALTER TABLE mw_account_requests ADD acr_xff VARCHAR(255) NULL default '';''
Query OK, 1 row affected (0.23 sec)
Records: 1  Duplicates: 0  Warnings: 0
75.175.9.66 (talkcontribs)

(To confirm, I did run update.php before any of the above steps. The update.php pass ''is not'' adding this extension's required fields after an upgrade.)

Mojorhino (talkcontribs)

I had this same error. I noticed it right after blocking several of what I thought were fictitious users.

After further review I figured out what was causing the error. Someone at my work created an account without updating any pages so I blocked them thinking they were also a fictitious user. Well, when I blocked them I also blocked their IP address & since we have a static IP at my work that caused me to unintentionally block myself which was ultimately causing in the error message. After unblocking the user with the same IP as mine my problems went away.

Paladox (talkcontribs)

Patch https://gerrit.wikimedia.org/r/#/c/237711 should fix this problem.

Tymek1988 (talkcontribs)

Still have this problem and can't find any good solution

88.24.37.65 (talkcontribs)

Hi sirs, i have this problem and it's happening without touch anything in my site, just updating pages i have a lot of work and then this happends :(

Sorry i'm very frustrated about that and don't know how to proceed, please help.

@Paladox could you help me ?

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

  • Query: COMMIT
  • Function: LoadBalancer::commitAll
  • Error: 2006 MySQL server has gone away (localhost)

Backtrace:

#0 /home/adminluk/public_html/includes/db/Database.php(1059): DatabaseBase->reportQueryError('MySQL server ha...', 2006, 'COMMIT', 'LoadBalancer::c...', false) #1 /home/adminluk/public_html/includes/db/Database.php(3594): DatabaseBase->query('COMMIT', 'LoadBalancer::c...') #2 /home/adminluk/public_html/includes/db/Database.php(3577): DatabaseBase->doCommit('LoadBalancer::c...') #3 /home/adminluk/public_html/includes/db/LoadBalancer.php(1008): DatabaseBase->commit('LoadBalancer::c...', 'flush') #4 [internal function]: LoadBalancer->commitAll() #5 /home/adminluk/public_html/includes/db/LBFactory.php(176): call_user_func_array(Array, Array) #6 [internal function]: LBFactory->{closure}(Object(LoadBalancer), 'commitAll', Array) #7 /home/adminluk/public_html/includes/db/LBFactory.php(330): call_user_func_array(Object(Closure), Array) #8 /home/adminluk/public_html/includes/db/LBFactory.php(177): LBFactorySimple->forEachLB(Object(Closure), Array) #9 /home/adminluk/public_html/includes/db/LBFactory.php(186): LBFactory->forEachLBCallMethod('commitAll') #10 /home/adminluk/public_html/includes/jobqueue/JobRunner.php(129): LBFactory->commitAll() #11 /home/adminluk/public_html/includes/MediaWiki.php(788): JobRunner->run(Array) #12 /home/adminluk/public_html/includes/MediaWiki.php(746): MediaWiki->triggerJobs() #13 /home/adminluk/public_html/includes/MediaWiki.php(558): MediaWiki->restInPeace('normal') #14 /home/adminluk/public_html/includes/MediaWiki.php(577): MediaWiki->{closure}() #15 /home/adminluk/public_html/includes/MediaWiki.php(520): MediaWiki->doPostOutputShutdown('normal') #16 /home/adminluk/public_html/index.php(41): MediaWiki->run() #17 {main}
Paladox (talkcontribs)

Hi are you using the ConfirmAccount extension, if so please try patch https://gerrit.wikimedia.org/r/#/c/237711

If not could you try Project:Support desk please where you may get more support since I'm not really sure why it is failing for you.

Also try updating to mw 1.27 please.

88.24.37.65 (talkcontribs)

Dear @Paladox it was so crazy !!! my site www.wikinnabis.com is working right now. i will describe whats i do to fix it, but very annoyed with this.

1- I don't use this ConfirmAccount extension, i disable the registering feature.

2- I will update to 1.27 right now because now i have a backup working.

3 - "The MAGIC" I'm hosted at Godaddy, Godaddy have installatron to manage servers installs services (instances) like bitnami image service downloads, so you can install, clone, etc

Godaddy tell me that i was hacked in the past and this files are corrupt. Not true ! I When this happends, i restore the entire site to 5 months ago because don't have operative working copy, so imagine to heard this shit. So thinking that the problem is on the DDBB i duplicate the wiki instance to www.site.com/test/ and magically seems that ddbb is now working again. I made a lot of work on marketing this week, the results are awesome but with this servers down make me bad name. Is there any possibility to know exactly something pointing to the true problem ? Because i cannot be looking my domain every hour and then try to fix is something happend, i want just something stable if i don't touch it, hope that i'm asking too much :)

Paladox (talkcontribs)

Hi, you may want to try installing mediawiki your self instead of using the installation managers.

It is easy to do it your self

All you have to do

Is go here Download click download 1.27.

Extract it to your website where ever your website dir is

then you go to your website

for example example.com/mw-config/

then configure your mw.

205.237.78.11 (talkcontribs)

Using version 1.26 I had the same issue and simply ran an update from ssh. Navigate to maintenance folder and run "php Update.php". Fixed my database error.

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