Running query: LOCK TABLES qa_users WRITE, qa_userprofile WRITE, qa_cookies WRITE, qa_categories WRITE, qa_pages WRITE, qa_posts WRITE, qa_blobs WRITE, qa_words WRITE, qa_titlewords WRITE, qa_contentwords WRITE, qa_posttags WRITE, qa_uservotes WRITE, qa_userpoints WRITE, qa_userlimits WRITE, qa_iplimits WRITE, qa_options WRITE, qa_cache WRITE ...
22 upgrade step/s remaining...
Running query: ALTER TABLE qa_users CHANGE COLUMN resetcode emailcode CHAR(8) CHARACTER SET ascii NOT NULL DEFAULT '', ADD COLUMN flags TINYINT UNSIGNED NOT NULL DEFAULT 0 ...
Warning: Cannot modify header information - headers already sent by (output started at /home/equineov/public_html/qa-include/qa-db-install.php:1020) in /home/equineov/public_html/qa-include/qa-install.php on line 60
Question2Answer was unable to perform the installation query below. Please check the user in the config file has CREATE and ALTER permissions:
ALTER TABLE qa_users CHANGE COLUMN resetcode emailcode CHAR(8) CHARACTER SET ascii NOT NULL DEFAULT '', ADD COLUMN flags TINYINT UNSIGNED NOT NULL DEFAULT 0
Error 1060: Duplicate column name 'emailcode'