Database error whilst trying to upgrade Q2A, from version 1.7.5 to 1.8

Question

Is there any way to solve this database error output?
When I try to update Q2A from version  1.7.5  to  1.8  onwards this happens:

I've had this problem for years.

Comments

"This" being ... what exactly? Please do not post links to external resources, particularly not url-shortener links. Include all relevant information about your problem in your question here.

---

The link is a picture of what happens.

it's not a shortened link or a virus

https://imgur.com/a/eFv5EzV

When I update q2a, it asks me to upgrade the database, and this error happens

Answer 1

You don't need to update to 1.8.0 first. You can directly attempt to install 1.8.6.

Follow these steps:

 1. Edit this line and comment it, which means add 2 dashes at the beginning like so:

// qa_db_upgrade_query('ALTER TABLE ^userv...

 2. Retry installation

 3. If you get a similar error but referencing the following line, comment the next line

 4. Retry installation

 5. If you get a similar error but referencing the following line, comment the next line

 6. Start a timer. Retry installation. Stop the timer immediately after the (successful or failed) execution of this line

 7. Let me know if this fixed the issue and how much time the timer showed (I believe a long running query was the cause of the issue). You can remove the comments if things worked out well.

Comments

Thanks. I'll do it and I'll be back to tell you if it worked.