Weird Error

Submitted by izoox on Fri, 02/26/2016 - 17:31

I am running the latest Virtualmin and Webmin as well as MySQL 5.7 but when I click to edit users I get: Unknown column 'user.password' in 'field list'

Status: 
Closed (fixed)

Comments

Submitted by andreychek on Fri, 02/26/2016 - 19:01

Howdy -- there is compatibility issue with MySQL 5.7. There is some additional info in this bug report here:

https://www.virtualmin.com/node/38397

The issue you're seeing should be corrected in the next release.

Submitted by izoox on Wed, 03/02/2016 - 10:21

Any idea when this is going out? Can I get a hotfix for this? Really need to get some email accounts added on this one.

Submitted by JamieCameron on Wed, 03/02/2016 - 10:45

It will be out in a couple of days at most

Submitted by izoox on Wed, 03/02/2016 - 12:30

Any way around this for me? These users basically cannot use their server at the moment because they upgraded their mysql version.

Submitted by JamieCameron on Wed, 03/02/2016 - 13:35

I could send you a pre-release fix - are you running the GPL or pro version, and on which linux distro?

Submitted by izoox on Wed, 03/02/2016 - 14:27

I'm on Centos and this one is a gpl.

Submitted by andreychek on Thu, 03/03/2016 - 09:59

Sorry for the delay, Jamie is out of the office this week... we'll get you a pre-release shortly though!

Submitted by JamieCameron on Thu, 03/03/2016 - 11:30

We will have a 5.01 release of Virtualmin out in a day or two that will include this fix.

Check http://www.webmin.com/vdownload.html later today if you want to get the RPM before it gets released to our repos.

Submitted by izoox on Thu, 03/03/2016 - 13:56

I upgraded virtualmin and am still getting:

SQL select user.user,user.password from user,db where db.user = user.user and (db.db = 'eticket' or db.db = 'eticket') failed : Unknown column 'user.password' in 'field list'

Submitted by JamieCameron on Thu, 03/03/2016 - 22:26

What action are you performing in Virtualmin when you get that error?

Submitted by izoox on Fri, 03/04/2016 - 10:42

I just clicked 'Edit Users' and that error comes up.

Submitted by JamieCameron on Fri, 03/04/2016 - 19:34

Try re-downloading and installing the version 5.01 RPM - that should fix the issue.

Submitted by JamieCameron on Sun, 03/06/2016 - 23:34

I missed another place where the password column was being referenced in Virtualmin.

Submitted by JamieCameron on Sun, 03/06/2016 - 23:34

Status: Active ยป Fixed