Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+2 votes
888 views
in Q2A Core by
Getting this error during 'update database' after hitting the button..


Warning: Cannot modify header information - headers already sent by (output started at /home/mywebsite/public_html/mywebsite.com/answers/qa-include/qa-db-install.php:478) in /home/mywebsite/public_html/mywebsite.com/answers/qa-include/qa-install.php  on line 42

1 Answer

0 votes
by
This is just a warning that prevented a fairly unimportant HTTP header being output. I'll look into this for the final release, but it shouldn't have affected the upgrade process.
by
Thanks for the quick response. After I get that error; it just gives an option to 'upgrade database' button again. And when I try to pull it up: www.mywebsite.com/answers   it is stuck at that 'upgrade database' screen..
by
OK. It is possible that something has got out of sync during the upgrade process. Do you have a way to access the database through a web-based interface, or a command-line MySQL client? If so, please post the output to these queries:

select * from qa_options where title='db_version';
describe qa_posts;
describe qa_userpoints;
describe qa_contentwords;
describe qa_users;

Given this information I should be able to get you back on track.
by
Not too strong at sql stuff; but here is what popped up from a query off phpmyadmin..

select * from qa_options where title='db_version';# Rows: 1

describe qa_posts;# Rows: 15

describe qa_userpoints;# Rows: 10

describe qa_contentwords;# Rows: 3

describe qa_users;# Rows: 13
by
Please send the actual values output by the first query in my list, not just the number of rows. It should be something with two columns - title and content. Thanks!
by
<newbie>
So I pulled up phpmyadmin, selected the database I wanted, went to SQL tab, copied and pasted the five lines you gave earlier, and hit go.

Looked around and can't find anything with two columns with title or content.. ???
</newbie>
by
Try running one query at a time, install of all five at once! (BTW it might makes sense to continue this correspondence by email - click feedback below).
...