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