Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 10 Years, 3 Months, 1 Week ago Internal sql error
#1
Solved: 10 Years, 3 Months, 1 Week ago
This user has been denied support. This user has been denied support.
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?
#2
Solved: 10 Years, 3 Months, 1 Week ago
this might help
#3
Solved: 10 Years, 3 Months, 1 Week ago
This user has been denied support. This user has been denied support.
I stlll have the problem.

I have put fix.php in the root.

Then I start the url of my site.
#4
Solved: 10 Years, 3 Months, 1 Week ago
yoursite.com/fix.php
No longer involved in the MyBB project.
#5
Solved: 10 Years, 3 Months, 1 Week ago
Check the mybb version try upgrading to the latest and see if it fix the problem.
#6
Solved: 10 Years, 3 Months, 1 Week ago
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.
#7
Solved: 10 Years, 3 Months, 1 Week ago
This user has been denied support. This user has been denied support.
Thanks
If works fine now.


Forum Jump:


Users browsing this thread: 1 Guest(s)