MyBB Community Forums
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.