Topic on Extension talk:ConfirmAccount

A database query error

8
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"