Last modified: 2013-02-05 22:31:25 UTC
I am using git REL1_20 on mediawiki and submodules. Trying to confirm membership gives me: Database error Jump to: navigation, search A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: INSERT INTO `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 ('9','Max Mustermann','m.m@mustermann.de','20130204202819','Dies ist ein Test, ob die Registrierung funktioniert.','','','123.231.123.204','','Mozilla/5.0 (Windows NT 6.1; WOW64; rv:18.0) Gecko/20100101 Firefox/18.0',NULL,'wikidb:acctrequest:ip:123.231.123.204','','20130204202705','20130205000003','1','Willkommen',NULL) from within function "AccountConfirmSubmission::acceptRequest". Database returned error "1054: Unknown column 'acd_xff' in 'field list' (localhost)". Backtrace: #0 /var/www/mediawiki/abc/includes/db/Database.php(916): DatabaseBase->reportQueryError('Unknown column ...', 1054, 'INSERT INTO `a...', 'AccountConfirmS...', false) #1 /var/www/mediawiki/abc/includes/db/Database.php(1672): DatabaseBase->query('INSERT INTO `a...', 'AccountConfirmS...') #2 /var/www/mediawiki/abc/extensions/ConfirmAccount/business/AccountConfirmSubmission.php(234): DatabaseBase->insert('account_credent...', Array, 'AccountConfirmS...') #3 /var/www/mediawiki/abc/extensions/ConfirmAccount/business/AccountConfirmSubmission.php(48): AccountConfirmSubmission->acceptRequest(Object(RequestContext)) #4 /var/www/mediawiki/abc/extensions/ConfirmAccount/frontend/specialpages/actions/ConfirmAccount_body.php(522): AccountConfirmSubmission->submit(Object(RequestContext)) #5 /var/www/mediawiki/abc/extensions/ConfirmAccount/frontend/specialpages/actions/ConfirmAccount_body.php(93): ConfirmAccountsPage->doAccountConfirmSubmit() #6 /var/www/mediawiki/abc/includes/SpecialPage.php(611): ConfirmAccountsPage->execute('authors') #7 /var/www/mediawiki/abc/includes/SpecialPageFactory.php(494): SpecialPage->run('authors') #8 /var/www/mediawiki/abc/includes/Wiki.php(290): SpecialPageFactory::executePath(Object(Title), Object(RequestContext)) #9 /var/www/mediawiki/abc/includes/Wiki.php(536): MediaWiki->performRequest() #10 /var/www/mediawiki/abc/includes/Wiki.php(446): MediaWiki->main() #11 /var/www/mediawiki/abc/index.php(59): MediaWiki->run() #12 {main} I did run update.php. Thank you for your help. Mest regerda Mario
Hi Mario, acd_xff was added in https://gerrit.wikimedia.org/r/gitweb?p=mediawiki/extensions/ConfirmAccount.git;a=commitdiff;h=f0236073bb528a3163e84d59f4c51d358d0954c7 As a workaround, could you try to manually create the column acd_xff (and maybe also acd_agent)?
Hi Andre, thank you, the workaround has helped. I created the two columns. Now it works. Is there a way to fix this by calling: php update.php ? Best regards Mario
