Internal sql error - Printable Version +- MyBB Community Forums (https://community.mybb.com) +-- Forum: Community Archive (https://community.mybb.com/forum-106.html) +--- Forum: Archived Forums (https://community.mybb.com/forum-143.html) +---- Forum: Archived Development and Support (https://community.mybb.com/forum-155.html) +----- Forum: MyBB 1.6 (https://community.mybb.com/forum-138.html) +------ Forum: 1.6 General Support (https://community.mybb.com/forum-127.html) +------ Thread: Internal sql error (/thread-102933.html)

Internal sql error - erica - 2011-09-01 I get this message when I ask for a display of people ""waiting for activation"". ------------- MyBB has experienced an internal SQL error and cannot continue. SQL Error: 1054 - Unknown column 'custom_profile_fields' in 'field list' Query: INSERT INTO mybb_adminviews (uid,title,type,visibility,fields,conditions,custom_profile_fields,sortby,sortorder,perpage,view_type) VALUES ('7','Waiting','user','1','a:1:{i:0;s:8:\"username\";}','a:15:{s:8:\"username\";s:7:\"Waiting\";s:5:\"email\";s:0:\"\";s:9:\"usergroup\";a:1:{i:0;s:1:\"5\";}s:7:\"website\";s:0:\"\";s:3:\"icq\";s:0:\"\";s:3:\"aim\";s:0:\"\";s:5:\"yahoo\";s:0:\"\";s:3:\"msn\";s:0:\"\";s:9:\"signature\";s:0:\"\";s:9:\"usertitle\";s:0:\"\";s:11:\"postnum_dir\";s:12:\"greater_than\";s:7:\"postnum\";s:0:\"\";s:5:\"regip\";s:0:\"\";s:6:\"lastip\";s:0:\"\";s:6:\"postip\";s:0:\"\";}','a:4:{s:5:\"fid16\";s:0:\"\";s:5:\"fid18\";s:0:\"\";s:5:\"fid17\";s:0:\"\";s:5:\"fid19\";s:0:\"\";}','username','asc','20','table') -- How do I solve this problem? RE: Internal sql error - ranjani - 2011-09-01 this might help RE: Internal sql error - erica - 2011-09-01 I stlll have the problem. I have put fix.php in the root. Then I start the url of my site. RE: Internal sql error - Nathan Malcolm - 2011-09-01 yoursite.com/fix.php RE: Internal sql error - vodka - 2011-09-02 Check the mybb version try upgrading to the latest and see if it fix the problem. RE: Internal sql error - Siege - 2011-09-02 The column doesn't exist. If it's a plugin, reinstall it. If not, try creating the column manually and then letting MyBB write to it. RE: Internal sql error - erica - 2011-09-02 Thanks If works fine now.