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

Cannot whitelist "Special:RequestAccount"

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

Reply to "Cannot whitelist "Special:RequestAccount""

Error running updater.php with Postgres backend

2
174.71.94.45 (talkcontribs)

I'm reporting a bug here that I encountered while using ConfirmAccount with the Postgres backend. Running the updater fails with this error:

Adding column 'account_requests.acr_agent'
A database query error has occurred.
Query: ALTER TABLE account_requests ADD acr_agent /snip/mediawiki/extensions/ConfirmAccount/backend/schema/postgres/patch-acr_agent.sql
Function: DatabaseBase::query
Error: 42601 ERROR:  syntax error at or near "/"
LINE 1: ...e::query  */ TABLE account_requests ADD acr_agent /snip...
                                                             ^

Reason: the third parameter to addPgField should be the type, not a patch file. Since the patch file in this case is very simple, it can be replaced with a series of addPgField calls. Otherwise, it would have to be applied with a different function (addTable, maybe, though that's not what's really happening).

Solution: Apply this patch to extensions/ConfirmAccount/backend/schema/ConfirmAccountUpdater.hooks.php:

diff --git a/extensions/ConfirmAccount/backend/schema/ConfirmAccountUpdater.hooks.php b/extensions/ConfirmAccount/backend/schema/ConfirmAccountUpdater.hooks.php
index 54e6d31..d07dc54 100755
--- a/extensions/ConfirmAccount/backend/schema/ConfirmAccountUpdater.hooks.php
+++ b/extensions/ConfirmAccount/backend/schema/ConfirmAccountUpdater.hooks.php
@@ -34,7 +34,10 @@ class ConfirmAccountUpdaterHooks {
                        $updater->addExtensionUpdate( array( 'addPgField', 'account_requests', 'acr_areas', "TEXT" ) );
                        $updater->addExtensionUpdate( array( 'addPgField', 'account_credentials', 'acd_areas', "TEXT" ) );
                        $updater->addExtensionUpdate( array( 'addIndex', 'account_requests', 'acr_email', "$base/patch-email-index.sql", true ) );
-                       $updater->addExtensionUpdate( array( 'addPgField', 'account_requests', 'acr_agent', "$base/patch-acr_agent.sql", true ) );
+                       $updater->addExtensionUpdate( array( 'addPgField', 'account_requests', 'acr_xff', "TEXT" ) );
+                       $updater->addExtensionUpdate( array( 'addPgField', 'account_requests', 'acr_agent', "TEXT" ) );
+                       $updater->addExtensionUpdate( array( 'addPgField', 'account_credentials', 'acd_xff', "TEXT" ) );
+                       $updater->addExtensionUpdate( array( 'addPgField', 'account_credentials', 'acd_agent', "TEXT" ) );
                }
                return true;
        }
46.4.115.119 (talkcontribs)

I have a similar error.

When i want to run php update.php i get this error:

Adding column 'bs_namespacemanager_backup_page.page_content_model'

A database query error has occurred.

Query: ALTER TABLE bs_namespacemanager_backup_page ADD page_content_model /home/sysadmin/mediawiki-1.27.1/extensions/BlueSpiceExtensions/NamespaceManager/db/bs_namespacemanager_backup_page.patch.pg.sql

Function: DatabaseBase::query

Error: 42601 ERROR:  syntax error at or near "/"

LINE 1: ...mespacemanager_backup_page ADD page_content_model /home/sysa...

can anyone help me?

Reply to "Error running updater.php with Postgres backend"

Could not create directory "mwstore://accountcreds-backend/accountcreds-public/w/wi/wik".

25
Daniel K. Schneider (talkcontribs)

MediaWiki 1.25beta (696dc35) Extension: code from GIT (both master and REL_25)

Hello,

  • I ran into this problem: Could not create directory "mwstore://accountcreds-backend/accountcreds-public/w/wi/wik"
  • Several persons reported this in older archieved messages, but my file permission are ok (i.e I can upload an image)
  • $wgFileStore to manually specify a directory will not work (has been removed since MW 1_24

Workaround (I find this truly freaky since the version appear to be the same, according to the "version" page in the wiki):

git checkout REL1_24

- cheers ! Daniel

Lajosb (talkcontribs)

I had this exact same problem, and your trick worked for me too.

But why?...

Nemo bis (talkcontribs)

It means the lastest code of the extension is not compatible with your MediaWiki.

Lajosb (talkcontribs)

Yes, of course that's what it means, but that's really very odd. Like Daniel, I'm using WM 1.25 and the extension version for WM 1.25 (i.e. the version intended for that MW version) isn't working, while an older version (namely that for MW 1.24) is. In other words, the "right" version doesn't work, while a "wrong" version does.

(By the way, I had this problem also with the WikiForum extension. In that case too the 1.25 version had a problem that was solved by downgrading to the 1.24 version.)

Nemo bis (talkcontribs)

There is no guarantee that extensions work with any version. The branches are just a time approximation.

Bawolff (talkcontribs)

Usually that type of error is caused by a permission issue. The extension defaults to $wgUploadDirectory . "/accountcreds" as the directory to use. Make sure that php can create that directory and any subdirectories (e.g. Let the php user [usually www-data] own that directory).

Well $wgFileSotre was removed, you can still set it in LocalSettings.php. The more proper way would be to adjust $wgConfirmAccountFSRepos

Wess (talkcontribs)

Facing the same problem too, downgrading the syst. I could not understand the solution described above. As I understand it tries to save those files at the server root directory. Right now my workaround was to comment out all the file saving issues...

In addition - right now the e-mails to the admin are sent only after email address confirmation. Is there's any possibility to send them at the time of registration?

38.89.3.44 (talkcontribs)
80.252.174.242 (talkcontribs)

Any solution to this? I don't get the comment "git checkout REL1_24"

117.203.118.130 (talkcontribs)

Hello. I am facing the same problem. This discussion does not make clear about how to resolve it. Please guide in a step by step manner.

Jschrempp (talkcontribs)

I have the same problem. I just applied the 1.24.3 patch to 1.24.2. The ConfirmAccount extension was working with 1.24.2.

193.33.2.101 (talkcontribs)

Do you have $wgUploadDirectory = true; in Local Settings?

Wmat (talkcontribs)

This is still a problem with MW 1.25.1 and REL1_25 of the extension.

Ken Roy (talkcontribs)

Download and install the ConfirmAccount extensions for MW 1.24.

I had to do a similar backlevel for the CategoryTree extension where I needed the MW 1.23 version for it to work with MW 1.25.3

Eburcat (talkcontribs)

With MW 1.26 this has become a real issue for us. Can't checkout REL1_25 or REL1_24 - it crashes the whole site, and can't confirm any new accounts now...

Edit: solved it by replacing in the file ConfirmAccount.config.php, this line:

$wgFileStore['accountcreds']['directory'] : $wgUploadDirectory . "/accountcreds",

with the line:

$wgFileStore['accountcreds']['directory'] : "{$IP}/images/accountcreds",

212.122.223.98 (talkcontribs)

Thats great... thanks a lot :)

Dvlink (talkcontribs)

Thank you Eburcat!!

Paladox (talkcontribs)

Patch uploaded at https://gerrit.wikimedia.org/r/#/c/258373/ for mediawiki 1.27 alpha.

74.76.112.55 (talkcontribs)

Patch worked for me... I manually made the edits found in the above link by looking at the diff. So far so good.

Paladox (talkcontribs)

Ok. Please try the new patch I just uploaded at https://gerrit.wikimedia.org/r/#/c/258373/ please.

Frdpnl (talkcontribs)

Hi,

Absolutely new to mediawiki, so please correct any mistakes :-)

I noticed that the global $wgUploadDirectory is not set when the ConfirmAccount.config.php is loaded (which is a little weird). But, the file ConfirmAccount.php does mention a "hook after setup", where it is set. So, I just added the directory values in that hook function, as below, to remove the error.

function efLoadConfirmAccount() {
  global $wgEnableEmail;
  # This extension needs email enabled!
  # Otherwise users can't get their passwords...
  if ( !$wgEnableEmail ) {
    echo "ConfirmAccount extension requires \$wgEnableEmail set to true.\n";
    exit( 1 ) ;
  }
  # added directory settings here:
  global $wgUploadDirectory, $wgConfirmAccountFSRepos;
  $wgConfirmAccountFSRepos['accountreqs']['directory']  = $wgUploadDirectory . "/accountreqs";
  $wgConfirmAccountFSRepos['accountcreds']['directory'] = $wgUploadDirectory . "/accountcreds";
}

Probably not an ideal place, but it kind of made sense ;-)

Till Kraemer (talkcontribs)

Thank you guys for all your suggestions! I had to make the following changes to LocalSettings.php in order to make it work with MediaWiki 1.27.0:

#$wgFileStore['accountreqs']['directory'] = "{$wgUploadDirectory}/accountreqs";

$wgConfirmAccountFSRepos['accountreqs']['directory']  = "{$IP}/images/accountcreds";

#$wgFileStore['accountcreds']['directory'] = "{$wgUploadDirectory}/accountcreds";

$wgConfirmAccountFSRepos['accountcreds']['directory'] = "{$IP}/images/accountcreds";
94.197.121.127 (talkcontribs)

This will hopefully be fixed in https://gerrit.wikimedia.org/r/#/c/258373/

2A00:23C4:AD02:100:A86F:6D2D:8728:6C06 (talkcontribs)

Patch has been merged in master branch.

We have https://gerrit.wikimedia.org/r/#/c/307227/ for REL1_27 branch.

could somebody test this https://gerrit.wikimedia.org/r/#/c/307227/1 on mw 1.27 please?

Paladox (talkcontribs)

https://gerrit.wikimedia.org/r/#/c/307227/ has been merged for mediawiki 1.27 now.

Reply to "Could not create directory "mwstore://accountcreds-backend/accountcreds-public/w/wi/wik"."
Summary by Ivanhercaz

I get access via ssh and run update script and everything solved.

Ivanhercaz (talkcontribs)

Hi, I have installed ConfirmAccount in my wiki but I am having problems with that. When I go to check if it works fine, I fill all the fields and then I click in "Request account" but it shows me, in a new page, that message:

Error of the database

There was an error in the query to the database. This may indicate a bug in the software.

― Original message (in Spanish):

Error de la base de datos

Se ha producido un error en la consulta a la base de datos. Esto puede indicar un fallo en el software.

I think that it could happens because I don't run the update script. I haven't got access with SSH at this moment, but I tried to use the update script with the web-browser, so I enter in /mw-config/, but I have doubts because it shows me the screen with the last message after the installation. I tried to update the tables of the database restarting installation: I change the name of my local-settings.php, restart the installation with the same database and then I use the same local-settings.php again; but it didn't work.

Any advice to fix that error? Thanks in advance.

Regards, Ivanhercaz (talk) 16:47, 30 August 2016 (UTC)

P.D. I don't know if this talk space is the correct place to post that doubt, if not, please, tell me where I can ask about it (Phabricator?).

95.26.143.96 (talkcontribs)

Will the extension be for MW 1.27.0?

Aaron Schulz (talkcontribs)

Support has just been merged today into REL1_27 and master branches.

Daniel K. Schneider (talkcontribs)

Firstly huge thanx to Aaron for maintaining this crucial extension. In smaller Wikis we just don't have the manpower to fight spam on an hourly basis !

I managed to install this on three different wikis running 1.27.1, but it was a bit difficult since I made several mistakes. It really is crucial to do everything right. For example:

  • If you take this extension from GIT, it is important to set the version for both ConfirmAccount and ConfirmEdit
git checkout REL1_27
  • You then must update using the updater script.

An example configuration that does work:

# NEW ReCaptcha (NoCaptcha)

require_once "$IP/extensions/ConfirmEdit/ConfirmEdit.php";
wfLoadExtensions( array( 'ConfirmEdit', 'ConfirmEdit/ReCaptchaNoCaptcha' ) );
$wgCaptchaClass = 'ReCaptchaNoCaptcha';
$wgReCaptchaSiteKey = '....';
$wgReCaptchaSecretKey = '....';

/*
# OLD ReCaptcha VERSION
require_once( "$IP/extensions/ConfirmEdit/ConfirmEdit.php" );
require_once( "$IP/extensions/ConfirmEdit/ReCaptcha.php" );
$wgCaptchaClass = 'ReCaptcha';
$wgReCaptchaPublicKey = '....';
$wgReCaptchaPrivateKey = '...';
*/

# Confirm Account

// wfLoadExtension( 'ConfirmAccount' );
require_once("$IP/extensions/ConfirmAccount/ConfirmAccount.php");
// $wgAllowAccountRequestFiles = false;
$wgConfirmAccountContact = "daniel.schneider....";
$wgConfirmAccountRequestFormItems['Biography']['minWords'] = 10 ;

# our users must be registered, once they are in they they still must fill in captchas.
$wgCaptchaTriggers['edit']          = true;
$wgCaptchaTriggers['addurl']        = false;
$wgCaptchaTriggers['create']        = true;
$wgCaptchaTriggers['createaccount'] = true;

# Skip recaptcha for confirmed authors (they will inherit normal user rights)
$wgGroupPermissions['authors']['skipcaptcha'] = true;
Reply to "Will the extension be for MW 1.27.0?"

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

22
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.

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

ConfirmAccount not compatible with ConfirmEdit right now?

6
183.83.51.83 (talkcontribs)

I'm new to MediaWiki so maybe I'm missing something obvious - I just installed 1.26.2 with latest plugins for ConfirmEdit and ConfirmAccount and the "Request Account" page for ConfirmAccount started failing as soon as I setup ConfirmEdit with RecaptchaNoCaptcha following exact instructions for both extensions. This was the error message I got the on clicking "Request Account":

Catchable fatal error: Argument 1 passed to ReCaptchaNoCaptcha::getForm() must be an instance of OutputPage, none given, called in /home/<mydomain>/public_html/wiki/extensions/ConfirmAccount/frontend/specialpages/actions/RequestAccount_body.php on line 231 and defined in /home/<mydomain>/public_html/wiki/extensions/ConfirmEdit/ReCaptchaNoCaptcha/ReCaptchaNoCaptcha.class.php on line 8

I managed to fix it by changing this line in RequestAccount_body.php

$form .= $captcha->getForm();

to

$form .= $captcha->getForm($this->getOutput());

This works, but I have absolutely no idea what I'm doing here frankly - I just made the parameters match by checking both files. Is this a known bug?

My thanks to all contributors for creating such a great piece of software in mediawiki and all these great extensions too!

58.233.10.17 (talkcontribs)

I have the same problem, and your quick fix seems to work for me. Thanks a lot for the suggestion. I hope that this problem is resolved sooner or later because I'm quite dependent on this extension.

87.123.33.215 (talkcontribs)

Please open a bugreport to get the fix integrated into the extension!

84.221.237.67 (talkcontribs)

Same error and same working solution.

Hope it will be fixed someday :-)

206.108.127.16 (talkcontribs)

I'm seeing a similar error:

```

PHP Catchable fatal error:  Argument 1 passed to SimpleCaptcha::getForm() must be an instance of OutputPage, none given, called in /<PATH TO WIKI>/wiki/extensions/ConfirmAccount/frontend/specialpages/actions/RequestAccount_body.php on line 231 and defined in /<PATH TO WIKI>/wiki/extensions/ConfirmEdit/SimpleCaptcha/Captcha.php on line 42

```

I'll probably try the fix posted above, and probably file a bug report if I can't find an existing one to link to.

Kghbln (talkcontribs)

Indeed filing an issue and even providing the solution will be marvellous. Go for it!

Reply to "ConfirmAccount not compatible with ConfirmEdit right now?"
Kghbln (talkcontribs)

Due to the new AuthManager there seem to be worries with this extension. Two related issue reports so far:

  1. task T137843 <-- (task T110451)
  2. task T137723 - done
Reply to "Issues with MW 1.27+"

Error sending mail: Unknown error in PHP's mail() function.

1
114.39.254.121 (talkcontribs)

For qnap users the following solution

tested on

Model:TS-459 Pro+

firmware version:4.2.1

Enable GOOGLE email[edit]

Check Installation PEAR type

# [/] pear

response ==>

Commands:

build                  Build an Extension From C Source

bundle                 Unpacks a Pecl Package

channel-add            Add a Channel

...........

If -sh: pear: command not found perform the following

# [/] ipkg update

# [/] ipkg install php-pear

modify qnap php.ini file ( Applications/Web server/php.ini maintenance)

include_path = ".:/etc/config/php:/opt/share/pear"

add in localsettings.php

$wgSMTP = array(

'host' => 'ssl://smtp.gmail.com',

'IDHost' => 'qbox4u.com', ( or whatever side you have )

'port' => 465,

'username' => 'qbox4u@gmail.com', ( or whatever email you have )

'password' => 'xxxxxxxxxxxxxxxxx',

'auth' => true

);

Read also ==> http://pear.php.net/manual/en/installation.checking.php

# [/] pear install Mail-1.3.0

# [/] pear install Net_SMTP

whenever you get now an bunch of errors,

check/modify your google settings https://www.google.com/settings/security/lesssecureapps

set Access for less secure apps==> Turn on

Kind regards

qbox4u.com

qbox.ddns.net

Reply to "Error sending mail: Unknown error in PHP's mail() function."

API for creating new account with ConfirmAccount extesnion

1
58.68.14.34 (talkcontribs)

Is there an API for creating a new account using this extension?

Reply to "API for creating new account with ConfirmAccount extesnion"