Extension talk:ConfirmAccount/2014

How to separate Login and create Account options in Mediawiki 1.20.2 when ConfirmAccount is enabled?

How to separate Login and create Account options in Mediawiki 1.20.2 when ConfirmAccount extension is enable? Please give any patch or code soon. User:Nitishkumartn 13:00, 11 May 2014 (UTC)

there is a patch that puts login and request account in the bar now 2.220.137.250 17:52, 13 June 2014 (UTC)

How to separate Login and create Account options in Mediawiki 1.20.2 when ConfirmAccount is enabled?

How to separate Login and create Account options in Mediawiki 1.20.2 when ConfirmAccount extension is enable? Please give any patch or code soon. User:Nitishkumartn 13:00, 11 May 2014 (UTC)

I don't understand the question, so maybe others don't either. Nemo 14:27, 11 May 2014 (UTC)

I think what he means is extension:ConfirmAccount is using the old way of loging into the wiki. And what he's asking is how can he get the new look for login and create account. 86.173.55.194 14:43, 11 May 2014 (UTC)

See $WgUseCombinedLoginLink Mlpearc (open channel) 23:22, 11 May 2014 (UTC)

hi that does not work. because it extension:confirmaccount has the something in its core that it is forcing to use that and plus extension:confirmaccount needs updating to update some settings to use the new login it would be easer and better. 90.219.90.180 15:44, 16 May 2014 (UTC)

there is now a new update to confirmaccount that fixes that issue. 2.220.137.250 17:52, 13 June 2014 (UTC)

Create account / login

Hi please update login and create account buttons because the layout and look of them was changed in 1.20 when the separated them into create account and then login so please update the looks and the create account could be redirect to special request account. I am running Mediawiki 1.24 Wmf 4 86.173.55.194 13:01, 11 May 2014 (UTC)

Create Account without email-Adress

Hello, is it possible that a user can request an account without an email adress and specify a password by himself? User:Finswimmer 13:03, 11 May 2014 (UTC)

Could not open lock file for...

• Most probably a problem of user restrictions.
• Enable debugging and look at error message
• Most probably, the image folder needs to allow a lockdir folder 2A00:1398:200:200:EC01:4DC:90FF:F1B1 13:06, 11 May 2014 (UTC)

BUG: Link to mediawiki.org help pages is internal but should be external

Tracked in Phabricator
Task T67454

In file i18n/confirmaccount/en.json to link used in the Welcome message links internally but should be an external wiki link:

Now: [[{{MediaWiki:Helppage}}|help pages]]

Should be: [{{MediaWiki:Helppage}} help pages]

Thanks Wmat (talk) 13:17, 18 May 2014 (UTC)

Pending gerrit:134063 Shirayuki (talk) 08:51, 19 May 2014 (UTC)

Done with gerrit:134063 Shirayuki (talk) 01:53, 19 June 2014 (UTC)

A database query error

I often come accross such an error with some extensions: "A database query error has occurred. This may indicate a bug in the software." Any suggestions? Xixo (talk) 17:35, 19 May 2014 (UTC)

this often involves the error 1146. For example:'mydatabase_name.mw_user_relationship' doesn't exist Xixo (talk) 17:44, 19 May 2014 (UTC)

Hi what version of Mediawiki are you running. 90.202.209.59 16:59, 22 May 2014 (UTC)

you need to create the tables 2.220.137.250 17:51, 13 June 2014 (UTC)

After installing I get this error when Confirm account requests - I recently upgraded from 1.12 to 1.23

What is the cause and how do I fix? (Happens when I go to Accept (create account)) 71.235.79.149 14:32, 29 June 2014 (UTC)

Run update.php Nemo 09:07, 30 June 2014 (UTC)

I have and everything completes with no errors

I did ad the confirm account extension and had to modify index so there weere no errors based on forum advice

here is what I changed it too - am i missing anything that would cuase the error - i hget this when i go I go to Accept (create account))

please advise

patch-account_credentials.sql

-- (c) Aaron Schulz, 2007

CREATE TABLE IF NOT EXISTS /*_*/account_credentials (

-- Revision ID #

acd_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,

-- Foreign key to user.user_id

acd_user_id INT UNSIGNED NOT NULL,

-- Optional 'real name' to be displayed in credit listings

acd_real_name VARCHAR(255) BINARY NOT NULL DEFAULT ,

-- Note: email should be restricted, not public info.

-- Same with passwords.

acd_email tinytext NOT NULL,

-- Initially NULL; when a user's e-mail address has been

-- validated by returning with a mailed token, this is

-- set to the current timestamp.

acd_email_authenticated varbinary(14) DEFAULT NULL,

-- A little about this user

acd_bio mediumblob NOT NULL,

-- Private info for reviewers to look at when considering request

acd_notes mediumblob NOT NULL,

-- Links to recognize/identify this user, CSV, may not be public

acd_urls mediumblob NOT NULL,

-- IP address

acd_ip VARCHAR(255) NULL DEFAULT ,

-- Name of attached file (.pdf,.doc,.txt etc...)

acd_filename VARCHAR(255) NULL,

acd_storage_key VARCHAR(64) NULL,

-- Areas of interest

acd_areas mediumblob NOT NULL,

-- Timestamp of account registration.

acd_registration varbinary(14) NOT NULL,

-- Timestamp of acceptance

acd_accepted varbinary(14),

-- The user who accepted it

acd_user INT UNSIGNED NOT NULL DEFAULT 0,

-- Reason given in email

acd_comment VARCHAR(255) NOT NULL DEFAULT

) /*$wgDBTableOptions*/;

CREATE UNIQUE INDEX /*i*/acd_user_id ON /*_*/account_credentials (acd_user_id,acd_id); 71.235.79.149 20:48, 30 June 2014 (UTC)

here is teh roor i get when I submit on Confirm account ans yes I have run update

INSERT INTO `wikiaccount_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 ('12771','Martha','inversur1310@gmail.com','20140629135152','test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test test',,,'71.235.79.149',,'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.153 Safari/537.36',NULL,'rifidiwiki-wiki:acctrequest:ip:71.235.79.149',,'20140629134455','20140630211654','3099',,NULL)

Function: AccountConfirmSubmission::acceptRequest

Error: 1054 Unknown column 'acd_xff' in 'field list' (rifidiwiki.db.7891152.hostedresource.com) 71.235.79.149 21:18, 30 June 2014 (UTC)

error in defineResourceModules when running update.php

Hi, when I include the ConfirmAccount extension in my LocalSettings.php and then run update.php, I get the following error:

PHP Catchable fatal error: Argument 1 passed to ConfirmAccountUISetup::defineResourceModules() must be an array, null given, called in /var/lib/mediawiki/extensions/ConfirmAccount/ConfirmAccount.php on line 42 and defined in /var/lib/mediawiki/extensions/ConfirmAccount/frontend/ConfirmAccountUI.setup.php on line 45

Any ideas? Thanks. Foobarbecue (talk) 20:21, 28 May 2014 (UTC)

Nevermind, this happened because I was using a very old version of mediawiki (1.15). Foobarbecue (talk) 16:35, 29 May 2014 (UTC)

Please upgrade to version 1.23 if you have php 5.3 or if you have php 5.2 then mediawiki 1.19 2.220.137.250 17:50, 13 June 2014 (UTC)

error on running "update.php" via web-updater

when i try to reach my web-updater on "mywiki.com/w/mw.config/ i get this error message: "Fatal error: Class 'ConfirmAccountUISetup' not found in /home/webpages/lima-city/creativeofficewiki/html/extensions/ConfirmAccount/ConfirmAccount.php on line 42" - I need to update in order to make the extension ConfirmAccount runable.

thx for help Wdfgea (talk) 21:04, 25 June 2014 (UTC)

extracted files in wrong dir?

I'm running MW 1.23.

After downloading and extracting the ConfirmAccount for version 1.23, I find the following 5 files directly in extension dir:

ConfirmAccount_body.php

patch-account_credentials.sql

patch-drop-acr_deleted_reg-index.sql

RequestAccount_body.php

UserCredentials_body.php

(verified with WIN + CentOS)

With ConfirmAccount enabled in LocalSettings.php I can't access SpecialPages page (HTTP Error 500). When I move the 5 files to extensions\ConfirmAccount\frontend\specialpages\action the SpecialPages pages shows up correctly.

Is it a bug in the structure or what am I doing wrong? WMX (talk) 09:04, 27 June 2014 (UTC)

After verifying a second time the files were extracted correct in Centos!

copied the extracted dir structure zu extensions folder.

works now. WMX (talk) 09:21, 27 June 2014 (UTC)

Error with confirmaccont

Hello,

I'm getting the following error trying to run the extension:

PHP Catchable fatal error: Argument 3 passed to ConfirmAccountUIHooks::setRequestLoginLinks() must be an instance of SkinTemplate, none given in /var/www/kennyburgess-wiki/extensions/ConfirmAccount/frontend/ConfirmAccountUI.hooks.php on line 28

Any ideas? 67.176.53.30 22:15, 11 July 2014 (UTC)

Same here. 216.197.205.21 04:03, 10 September 2014 (UTC)

For future reference: I fixed the error by making VERY SURE I installed the correct version of ConfirmAccount for my wiki! I was installing one 2 minor numbers too new. 216.197.205.21 04:29, 10 September 2014 (UTC)

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

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 OlivierCompagne (talk) 22:19, 4 September 2014 (UTC)

I have the same exact version and issue 128.250.26.189 07:32, 1 October 2014 (UTC)

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? Donkey Kong Genius (talk) 10:21, 5 October 2014 (UTC)

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?! 91.61.79.41 19:35, 20 October 2014 (UTC)

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 CookipediaChef (talk) 11:48, 3 December 2014 (UTC)

Copied tables? And did you run update.php then? Nemo 21:39, 3 December 2014 (UTC)

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) 88.106.73.51 12:35, 4 December 2014 (UTC)

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)

188.226.181.10 14:26, 25 December 2014 (UTC)

how you fix it?even i got the same error Shanumithun (talk) 06:23, 29 January 2019 (UTC)

So there is no way to fix it? Tymek1988 (talk) 10:25, 16 December 2014 (UTC)

ALTER TABLE /*_*/account_credentials ADD COLUMN acd_xff VARCHAR(255) NULL default ; Aaron (talk) 00:17, 25 December 2014 (UTC)

This did not fix my mediawiki 1.22.6 install. Grantbow (talk) 14:53, 3 April 2015 (UTC)

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

Thanks ! tiix 13:11, 13 April 2015 (UTC)

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. 98.201.4.33 06:18, 9 May 2015 (UTC)

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 (talk) 19:18, 12 July 2015 (UTC)

(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.) 75.175.9.66 (talk) 19:22, 12 July 2015 (UTC)

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. Mojorhino (talk) 12:37, 25 March 2015 (UTC)

Patch https://gerrit.wikimedia.org/r/#/c/237711 should fix this problem. Paladox (talk) 13:41, 12 September 2015 (UTC)

Still have this problem and can't find any good solution SANtosito (talk) 23:22, 3 July 2016 (UTC)

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} 88.24.37.65 (talk) 10:03, 9 July 2016 (UTC)

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. Paladox (talk) 11:41, 9 July 2016 (UTC)

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 :) 88.24.37.65 (talk) 11:58, 9 July 2016 (UTC)

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. Paladox (talk) 12:27, 9 July 2016 (UTC)

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. 205.237.78.11 (talk) 16:19, 7 November 2016 (UTC)

Disabling the ConfirmAccount-extension solved the problem for me. Wimw (talk) 19:57, 1 April 2017 (UTC)

I am also getting these errors and my mediawiki version is 1.22

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

• Query: SELECT page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len,page_content_model FROM `page` WHERE page_namespace = '0' AND page_title = 'Main_Page' LIMIT 1
• Function: WikiPage::pageData
• Error: 1054 Unknown column 'page_counter' in 'field list' (localhost)

Backtrace:

#0 /var/www/html/core_old/includes/db/Database.php(1039): DatabaseBase->reportQueryError('Unknown column ...', 1054, 'SELECT page_id...', 'WikiPage::pageD...', false)

#1 /var/www/html/core_old/includes/db/Database.php(1496): DatabaseBase->query('SELECT page_id...', 'WikiPage::pageD...')

#2 /var/www/html/core_old/includes/db/Database.php(1585): DatabaseBase->select('page', Array, Array, 'WikiPage::pageD...', Array, Array)

#3 /var/www/html/core_old/includes/WikiPage.php(303): DatabaseBase->selectRow('page', Array, Array, 'WikiPage::pageD...', Array)

#4 /var/www/html/core_old/includes/WikiPage.php(322): WikiPage->pageData(Object(DatabaseMysqli), Array, Array)

#5 /var/www/html/core_old/includes/WikiPage.php(361): WikiPage->pageDataFromTitle(Object(DatabaseMysqli), Object(Title))

#6 /var/www/html/core_old/includes/WikiPage.php(444): WikiPage->loadPageData()

#7 /var/www/html/core_old/includes/WikiPage.php(497): WikiPage->exists()

#8 /var/www/html/core_old/includes/WikiPage.php(212): WikiPage->getContentModel()

#9 /var/www/html/core_old/includes/WikiPage.php(198): WikiPage->getContentHandler()

#10 /var/www/html/core_old/includes/Action.php(92): WikiPage->getActionOverrides()

#11 /var/www/html/core_old/includes/Action.php(145): Action::factory('view', Object(WikiPage), Object(RequestContext))

#12 /var/www/html/core_old/includes/Wiki.php(151): Action::getActionName(Object(RequestContext))

#13 /var/www/html/core_old/includes/Wiki.php(531): MediaWiki->getAction()

#14 /var/www/html/core_old/includes/Wiki.php(467): MediaWiki->main()

#15 /var/www/html/core_old/index.php(49): MediaWiki->run()

#16 {main}

Thanks in advance Gopa Vasanth (talk) 10:22, 26 January 2018 (UTC)

SOLVED

I was trying to fix it from time to time over the few years, but today it worked. Applying patch https://gerrit.wikimedia.org/r/#/c/mediawiki/extensions/ConfirmAccount/+/237711/ as @Paladox suggested and deleting ADD acr_xff VARCHAR(255) NULL default '', and ADD acr_agent VARCHAR(255) NULL default ''; from patch-acr_agent.sql solved whole problem and extension works perfectly SANtosito (talk) 19:08, 19 October 2018 (UTC)

$wgGroupPermissions error

In section Configuration. Note: Sysops can still create accounts directly. To disable this, add to LocalSettings.php:

$wgGroupPermissions['sysop']['createaccount'] = false; 

This causes an error message on 1.23.2 "Notice: DB transaction callbacks still pending (from User::invalidateCache)."

Instead $wgGroupPermissions['*']['createaccount'] = false; Still allowing only sysops to create accounts works fine. Rob Kam (talk) 11:46, 12 September 2014 (UTC)

I can confirm my account

Fatal error: Call to undefined method ConfirmAccount::getAdminsToNotify() in /home/soft/public_html/escforumwiki/extensions/ConfirmAccount/frontend/specialpages/actions/RequestAccount_body.php on line 364

What I am doing now? :( 191.119.165.41 03:49, 17 September 2014 (UTC)

How do I set language strings with the latest version?

Hi.

I've just upgraded to MW 1.23.3 and the latest version of ConfirmAccount (rev. 34ddc24). I ran update.php.

With an older version, the language strings could be set via Special:AllMessages by searching for "request". Now if I do that nothing is returned. So how do I set the language strings now?

Thanks Mitchelln (talk) 10:18, 23 September 2014 (UTC)

Reminder for anyone reading: system messages are translated on translatewiki.net.

If Special:AllMessages is not working, you have a bug. However, you can always look up the message keys in the extension's json files or on translatewiki.net and visit/edit them directly, for instance MediaWiki:requestaccount-page (of course on your wiki, not here). Can you link your wiki? Nemo 17:34, 23 September 2014 (UTC)

HI.

Thanks for the reply. It looks like it is definitely a bug then. On two wiki's I've upgraded MW to 1.23.3 and ConfirmAccount to rev 34ddc24 the localisation strings no longer appear in Special:AllMessages

I can edit them direct via MediaWiki:requestaccount-page, for example. Thanks for the info :)

Unfortunately the wikis are internal, so I cannot provide a link to them. Mitchelln (talk) 10:52, 25 September 2014 (UTC)

How delete a rejected user with a confirmed email?

Hello all!

I used some test users with real email addresses to check extension to work properly (and it works :-). Now all email addresses are in recently rejected cue: is it possibile to remove them? Can i remove them manually or there is an automatic scheduled process (if yes how long does it takes)?

Thank you in advance for any reply. Midimarcus (talk) 18:31, 23 September 2014 (UTC)

I anyone found a solution yet. I would also like to know how to please 196.214.70.187 04:44, 3 October 2014 (UTC)

Why do you want to remove them? Nemo 12:38, 3 October 2014 (UTC)

Same question: I would like to test a few times after a recent upgrade, and I have already used up 3 email addresses. How can I purge the email address history and rejected username history? Thanks! 74.76.112.55 00:49, 16 October 2014 (UTC)

1.23.6 Upgrade error

Everything Food & Drink
MediaWiki	1.23.5
PHP	5.3.28 (cgi-fcgi)
MySQL	5.5.37-35.1
Lua	5.1.5

Catchable fatal error: Argument 3 passed to ConfirmAccountUIHooks::setRequestLoginLinks() must be an instance of SkinTemplate, none given in /public_html/w/extensions/ConfirmAccount/frontend/ConfirmAccountUI.hooks.php on line 27

Just tried the 1.23 version and am getting same error. Mlpearc (open channel) 08:47, 3 November 2014 (UTC)

How to deny access to login-type-signup page or redirect to requestAccount page?

I added to LocalSettings.php code from Enhancements (https://www.mediawiki.org/wiki/Extension:ConfirmAccount).
So I don't have direct link to register page. But if I go to login -> I can see a button which is link to http://localhost/mediawiki/index.php?title=Special:Login&type=signup -> and on this page anonymous user can register himself, what I don't want. Does anyone have any idea, how to always redirect from this site to site with RequestAccount?

I have:
MediaWiki 1.23.0
PHP 5.3.28 (cgi-fcgi)
MySQL 5.5.40
Confirm User Accounts – (Version d7bd12d) Monic abc (talk) 13:50, 22 December 2014 (UTC)

By "site", do you mean "page"? Nemo 08:25, 23 December 2014 (UTC)

Yeah, sorry for my English. :P Monic abc (talk) 09:06, 23 December 2014 (UTC)

Well, some extensions do things like:

specials/SpecialTranslationStash.php
31-             if ( !$this->hasPermissionToUse() ) {
32-                     if ( $this->getUser()->isLoggedIn() ) {
33:                             $out->redirect(
34-                                     Title::newFromText( $wgTranslateSecondaryPermissionUrl )->getLocalUrl()
35-                             );

You could probably code your conditions and execute them via an appropriate hook.

However I'm not convinced this is really what you need: if "anonymous user can register himself" for real, you didn't configure your MediaWiki correctly. Pleae read the documentation again and check that you did as it says:

• put the configuration in the correct order in your LocalSettings.php,
• don't add $wgGroupPermissions['*']['createaccount'] = true; or similar. Nemo 12:09, 25 December 2014 (UTC)

Thanks for reply. ;)

1. Configuration in correct order? Which lines of code are important and their order can change something?

2. I only have these lines with word createaccount:

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

$wgGroupPermissions['sysop']['createaccount'] = false; Monic abc (talk) 12:51, 9 January 2015 (UTC)