Beta 3 install error: Update Database

Question

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

Answer 1

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.

Comments

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..

---

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.

---

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

---

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!

---

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

---

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