Views stuck at 1 post upgrade (Help)

Question

Version: 1.8.0

Problems: 

After updating the Q2A 1.8.0 files replacing the 1.7.5 ones, 

1) view counts are stuck at "1"

2) Upgrade database ends up with the following error

Fixes tried:

Rolling back to 1.7.5 & > below versions does fix the View count error, but it brings up another problems like -

1) Logging in problems - It simply doesnt let you log in (I have another old account which somehow logs in just fine)

2) SMTP Emails stop working - (Fatal error) 

One way or the other I'm facing issues. Any help will be much appreciated. 

Comments

Please, don't duplicate content. If you need urgent assistance you can get a paid service from http://docs.question2answer.org/services