Thread:Extension talk:ConfirmAccount/A database query error/reply (6)

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