Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
  • Register
Welcome to the Q&A for Question2Answer.

If you have questions about the platform, click here to ask and please use English.

If you just want to try Q2A, please use the demo, which also grants admin access.

Apr 29: Q2A 1.5.2

Error when upgrading database to latest version

0 votes

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'

asked Nov 6, 2011 in Q2A Core by Bobby
You are upgrading from which version to 1.4.3?

Please log in or register to answer this question.