Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.

Problem with upgrade

+2 votes
65 views
asked Sep 21 in Q2A Core by Janko

I am trying to upgrade form 1.7.0 to last version 1.8.0 and I get the following error:

[Thu Sep 20 15:32:05 2018] [error] [client 46.123.254.197] PHP Question2Answer MySQL query error 1054: Unknown column 'passhash' in 'field list' - Query: SELECT qa_users.userid, passsalt, HEX(passcheck) AS passcheck, passhash, email, level, emailcode, handle, UNIX_TIMESTAMP(created) AS created, sessioncode, sessionsource, flags, UNIX_TIMESTAMP(loggedin) AS loggedin, loginip, UNIX_TIMESTAMP(written) AS written, writeip, BINARY avatarblobid AS avatarblobid, avatarwidth, avatarheight, points, wallposts FROM qa_users LEFT JOIN qa_userpoints ON qa_userpoints.userid=qa_users.userid WHERE qa_users.userid='1'

Any ideas what is wrong?

Q2A version: 1.7.0
commented Sep 21 by pupi1985
You have not upgraded the database. What was the output of the upgrade queries?
commented Sep 22 by jankoslavic
How do I upgrade the database? The instructions say that I should go to the admin page... but I can't, I get "Internal Server Error"..
commented Sep 22 by pupi1985
Following the instructions SHOULD work. Try upgrading one version at a time and see if that works. Follow this order: 1.7.1, 1.7.2, 1.7.3, 1.7.4, 1.7.5, 1.8.0. Also remove any custom plugin you've added
commented Sep 22 by jankoslavic
Thanks for the advice; However, I already tried with 1.7.1 but the same issue... I do not have any custom plugins
commented Sep 25 by pupi1985
It is hard to tell what issue you're facing with that information. I've tried upgrading from 1.7.0 to 1.7.1 and I can confirm I didn't face any issues

Please log in or register to answer this question.

...