Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
0 votes
377 views
in Q2A Core by

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'

by
You are upgrading from which version to 1.4.3?

Please log in or register to answer this question.

...