MyBB Community Forums

I was in the Admin Panel and decided to create a view or two and the first run gave me a SQL Error 1054 - Unknown column 'custom_profile_fields' in 'field list'

See attached

That error tells you that you don't have that field. Check if you have the forum id 4.

Also provide us a list of plugins(that might be affecting the profile field.)

(2014-08-20, 01:22 AM)Ace700 Wrote: [ -> ]That error tells you that you don't have that field. Check if you have the forum id 4.

Also provide us a list of plugins(that might be affecting the profile field.)

---

Well, I've replied to this post with a quote and that didn't work, got only the quote the reply disappeared.

Then I edited my reply twice and neither time would it take. Looks to me like there might be an Editor problem with 1.8 or operator error!

Regardless, here is my reply again....

Pretty new at this, not exactlyu sure what you mean by "forum id 4"


Plugins:
Announcement 2.4
Advanced Sidebox 2.1
Remember us? 1.4
Welcome PM/Email 1.1

---

Additional database info attached

The SQL Error means the column custom_profile_fields doesn't exist. What you can do is go to your hosting panel and open PHPMyAdmin. Then run this query:

ALTER TABLE mbb_adminviews ADD custom_profile_fields text NOT NULL;

Bingo! Perfectly executed. Thank you very much!