Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved sql error 1364
#1
Not Solved
Hi

when I try to post a thread, I get this error. What is the problem? Thanks

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:1364 - Field 'inviteonlycheck' doesn't have a default valueQuery:INSERT INTO mybbp1_threads (fid,subject,prefix,icon,uid,username,dateline,lastpost,lastposter,lastposteruid,views,replies,visible,notes) VALUES ('6','test',0,0,'1','winty',1564780252,1564780252,'winty','1',0,0,1,'')
Reply
#2
Not Solved
Problem from "Invite Only Threads"
Create Mybb Custom Plugin/theme
Create Wordpress Custom Plugin/theme
Php,C#,C++,HTML5,Jquery,..... Programming
View portfolio
Reply
#3
Not Solved
How do I turn off invite only threads? I thought it was a plugin but i've removed them and still the same
Reply
#4
Not Solved
IF you delete plugin files manually .
You must run below queries  on phpmyadmin :

ALTER TABLE mybb_threads DROP `inviteonlycheck`
ALTER TABLE mybb_threads DROP `inviteonlyuids`
DELETE FROM mybb_settinggroups WHERE name='iot'
DELETE FROM mybb_settings WHERE name='iot_enabled'"
DELETE FROM mybb_settings WHERE name='iot_fid'"
DELETE FROM mybb_settings WHERE name='iot_usergroup'
note : change mybb_ prefix with your forums table prefix
Create Mybb Custom Plugin/theme
Create Wordpress Custom Plugin/theme
Php,C#,C++,HTML5,Jquery,..... Programming
View portfolio
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)