Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+9 votes
424 views
in Q2A Core by
edited by

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.

Q2A version: 1.7.5
by
"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.
by
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

1 Answer

+1 vote
by

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.

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