user_pass not found...Help?

I am trying to reset the password because it's not working for some reason. So I created a bcrypt hash using a tool I found. I use this code below in the phpmyadmin sql area but it gives me an unknown column user_pass and their is no longer a password column in xenforo:

UPDATE xf_user
SET user_pass = 'mylonghashpasswordhere'
WHERE username = 'Gunstra';

I get this error returned:

MySQL said:

#1054 - Unknown column 'user_pass' in 'SET'

 

XenVn SEO Check - Xenforo Optimization Guide

E

Public Menu Color

[xenvn]

@gunstra
It's not that simple.

https://xenforo.com/community/threads/user-password-help.199889/

 

[gunstra]

@gunstra
It's not that simple.

***

MySQL said:

#1054 - Unknown column 'xf_user_authenticate' in 'SET'

 

[samers]

MySQL said:

#1054 - Unknown column 'xf_user_authenticate' in 'SET'

It's not having in xf 2.3

 

[xenvn]

 

[gunstra]

It's there but the sql command says it's not:

 

[xenvn]

I'm designing a password reset tool. Please wait.

 

[xenvn]

@gunstra
https://xenvn.com/threads/user-password-reset-tool-for-xenforo-2.5541/

 

[samers]

In this case, the password cannot be reset with the script because the system is stuck with an error. You must fix it with the shell first.

 

[gunstra]

In this case, the password cannot be reset with the script because the system is stuck with an error. You must fix it with the shell first.

Commands to run in cli?