2011-09-29, 07:31 PM
Today I saw this when trying to update a custom view. (MyBB 1.6.4)
Quote:MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1054 - Unknown column 'custom_profile_fields' in 'field list'
Query:
UPDATE mybb_adminviews SETtitle='Awaiting Activation',type='user',visibility='2',fields='a:6:{i:0;s:8:\"username\";i:1;s:10:\"lastactive\";i:2;s:5:\"email\";i:3;s:7:\"regdate\";i:4;s:5:\"regip\";i:5;s:6:\"lastip\";}',conditions='a:15:{s:8:\"username\";s:0:\"\";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:\"\";}',custom_profile_fields='a:4:{s:4:\"fid3\";a:1:{s:4:\"fid3\";s:3:\"N/A\";}s:5:\"fid13\";s:0:\"\";s:4:\"fid1\";s:0:\"\";s:4:\"fid2\";s:0:\"\";}',sortby='lastactive',sortorder='asc',perpage='100',view_type='table' WHERE vid='2'