We don't really have a host to ask. I was just wondering what kind of error log I'd be looking at. CPanel, Apache, Xenforo (database), etc...
found out that the issue is exactly the same as mentioned here, https://xenforo.com/community/threads/upgrade-help.194097/
Will try to do the same as mentioned in the thread.