+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: Merge System Support (https://community.mybb.com/forum-180.html)
+--- Thread: 1054 - Unknown column 'passwordconvert' in 'field list' (/thread-198079.html)
1054 - Unknown column 'passwordconvert' in 'field list' - fortrek - 2016-08-20
Hi,
I'm experiencing an error at MyBB forums. I didn't makes any changes, just tested the "Merge" software, but don't applied nothing from this system.
The error are:
SQL Error:
1054 - Unknown column 'passwordconvert' in 'field list'
Query:
SELECT username,password,salt,loginkey,coppauser,usergroup,passwordconvert,passwordconverttype,passwordconvertsalt,uid FROM mybbmwajugip_users WHERE username='' OR email='' LIMIT 1Anyone know how to solve this problem? I recently configured an Forum with myBB and don't want lost my configuration.
Regards.
Hi,
I disabled the Conversion Login Plugin and the problem was solved, for who don't know handle with it go to "/inc/init.php" and add this code to login first time:
define('NO_PLUGINS', "yes");
Or just delete "/inc/plugins/login*.php".
RE: 1054 - Unknown column 'passwordconvert' in 'field list' - Jones H - 2016-08-20
Hi, it seems that you run only some parts of the merge system. Usually that plugin is automatically activated after those fields have been added. Normally they're used to allow logging in with the same password used on the old software. Also the provided solutions aren't the proper ones:
- Adding the define statement disables the whole plugin system so none of your plugins will run which is troublesome if you decide to use MyBB in the future.
- Simply deleting the file may result in future issues as the plugins to load are stored in the database so the system may throw an error as it tries to load a plugin which doesn't exist anymore
The proper solution would be to disable the plugin in the acp (configuration -> plugins) before deleting that file.