Upgrading Q2A Database stuck after updating to V1.8

Question

Comments

I bet this was not the first time you've tried to upgrade to 1.8.2, right?

---

Not 1.8.2, v.1.8 yes.

---

Is there any way I could fix it?

Answer 1

Installation has failed at some point. Then you tried installing and now it is failing earlier because your database is in an inconsistent state. Knowing the original error would be useful to see in which step the original installation failed. As you don't remember that for sure, you'll have to go step by step.

1. Locate this line and comment it adding two slashes ( // ) at the beginning of the line

Retry the installation and report back (copy/paste the red text as a comment) here.

Comments

Database query error 1005
Can't create table 'admin_forums.#sql-7215_17ee0d' (errno: 121)

ALTER TABLE qa_messages ADD CONSTRAINT qa_messages_ibfk_1 FOREIGN KEY (fromuserid) REFERENCES qa_users(userid) ON DELETE SET NULL

---

https://i.postimg.cc/903mM9Zx/1.png

---

My bad. I linked you to the wrong line. Remove that comment. Check the link again and retry. Don't comment the next one. Unless you also get an error in the next one. Then report back :)

---

It went through, I just had to comment the next one as well, coz I got the same error for that one too.

---

Database successfully updated:

After->
https://i.postimg.cc/DZJSzspD/1.png

---

Excellent! Nothing better than starting a new year with the latest Q2A version installed :)