MyBB Community Forums

Full Version: How to remove a column in sql?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I had the pl9 forum icons mod installed but i disabled it and now when trying to update the forums i get this error

SQL ERROR:
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1054 - Unknown column 'forum_icon' in 'field list'


is there any way i could fix this problem myself?
Query:
SELECT loginattempts FROM mybb_users WHERE LOWER(username)='username' LIMIT 1

For more information read here:
Common Error Messages

Hope that's help you
That query is nothing to do with this error. That wiki page doesn't explain how to fix all unknown column errors, it's for a specific one. Plus that query on the wiki page is the query it's trying to run when you get that error, not the one to run to fix it.

You have a forum icon plugin and the column is missing, disable the plugin.