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
81.14.47.251 (talkcontribs)

Hi! everyone,

I am using 1.23. My mediawiki files are under /wiki and I have symbolic links from my many wiki sites. All my sites are run under SQLight.

Until now, I was unable to use the ConfirmAccount extension I had loaded. Look at this site I saw that reloading another 1.23 version might help. I reloaded it today from the site. I get the request page and can fill the form.

However I get:

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

  • Query:
    SELECT COUNT(*) FROM account_requests WHERE acr_deleted = '0' AND (acr_held IS NULL) AND (acr_email_authenticated IS NOT NULL) LIMIT 1
  • Function: ConfirmAccount::getOpenEmailConfirmedCount
  • Error: 1 no such table: account_request

I would be glad someone explains me what I do wrong.

Best regards

Jefsey

Reply to "What did I do wrong?"
87.158.75.126 (talkcontribs)

Hi all,

with ConfirmAccount extension uploaded and local settings modified the web browser update script does not work :(

First step of update (verifying installed MediaWiki version) is not to be seen (blank page)

Is this a known problem or misconfiguration by myself? Any further informations necessary?

Regards,

Klaus

Reply to "Update script will not proceed"

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

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

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

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

2
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

Reply to "Error: mwstore://accountcreds-backend/accountcreds-public"
Mitchelln (talkcontribs)

Hi.

There is an issue where sometimes people misspell their email address when they enter it. Then they never receive the confirmation emails. There is no way for the admin to correct the email address either. Worse still, as the uniqueness with Mediawiki is on username, the account is created but effectively useless as the email address was mistyped. The only way round this is to delete the account when the person finally complains that they have not received any confirmation emails.

Would it be possible to either have a confirm email entry box on the request form or add the ability for admins to edit the email address in the admin screen?

Thanks!

Reply to "Confirm email input box"

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

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

Reply to "A database query error has occurred. This may indicate a bug in the software."
Xixo~mediawikiwiki (talkcontribs)

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?

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

Xixo~mediawikiwiki (talkcontribs)

this often involves the error 1146. For example:'mydatabase_name.mw_user_relationship' doesn't exist

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

90.202.209.59 (talkcontribs)

Hi what version of Mediawiki are you running.

2.220.137.250 (talkcontribs)

you need to create the tables

71.235.79.149 (talkcontribs)

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))

Nemo bis (talkcontribs)

Run update.php

71.235.79.149 (talkcontribs)

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 (talkcontribs)

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)

Reply to "A database query error"
86.173.55.194 (talkcontribs)
  • 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

This post was posted by 86.173.55.194, but signed as 2A00:1398:200:200:EC01:4DC:90FF:F1B1.

Reply to "Could not open lock file for..."
86.173.55.194 (talkcontribs)

Hello, is it possible that a user can request an account without an email adress and specify a password by himself?

This post was posted by 86.173.55.194, but signed as User:Finswimmer.

Reply to "Create Account without email-Adress"

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

6
86.173.55.194 (talkcontribs)

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.

This post was posted by 86.173.55.194, but signed as User:Nitishkumartn.

Nemo bis (talkcontribs)

I don't understand the question, so maybe others don't either.

86.173.55.194 (talkcontribs)

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.

Mlpearc (talkcontribs)

See $WgUseCombinedLoginLink

90.219.90.180 (talkcontribs)

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.

2.220.137.250 (talkcontribs)

there is now a new update to confirmaccount that fixes that issue.

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