MyBB Community Forums - I am getting this error.

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:1364 - Field 'socialsites' doesn't have a default valueQuery:INSERT INTO mybb_users (username,password,salt,loginkey,email,postnum,threadnum,avatar,avatartype,usergroup,additionalgroups,displaygroup,usertitle,regdate,lastactive,lastvisit,website,icq,skype,google,birthday,signature,allownotices,hideemail,subscriptionmethod,receivepms,receivefrombuddy,pmnotice,pmnotify,showimages,showvideos,showsigs,showavatars,showquickreply,showredirect,tpp,ppp,invisible,style,timezone,dstcorrection,threadmode,daysprune,dateformat,timeformat,regip,language,showcodebuttons,sourceeditor,buddyrequestspm,buddyrequestsauto,away,awaydate,returndate,awayreason,notepad,referrer,referrals,buddylist,ignorelist,pmfolders,warningpoints,moderateposts,moderationtime,suspendposting,suspensiontime,coppauser,classicpostbit,usernotes,ougc_awards) VALUES ('Xavier A.','51d543aeb378a838b5fa39dc4dca9bb9','FqfJYETd','DqAVc60xc72KmOFWdFovWhE4c7j6wo7qs1FsM309RlWVXbtB18','(email, removed for safety reasons)',0,0,'','',5,'',0,'',1618297406,1618297406,1618297406,'',0,'','','','',1,1,0,1,0,1,0,1,1,1,1,1,1,0,0,0,0,'-4',2,'',0,'','',X'4439f3ca','',1,0,1,0,0,0,0,'','',0,0,'','','0**$%%$1**$%%$2**$%%$3**$%%$4**',0,0,0,0,0,0,0,'','')

so mybb_user has no tables inside of it how do I fix this issue?

use phpmyadmin (or any system to access your database) and add a default value to field socialsite: alter mybb_users alter socialsites set default ''
Or/and edit the plugin to add a default value in field creation

(2021-04-13, 07:09 AM)StrikersGamingTV Wrote: [ -> ]MyBB has experienced an internal SQL error and cannot continue.

SQL Error:1364 - Field 'socialsites' doesn't have a default valueQuery:INSERT INTO mybb_users (username,password,salt,loginkey,email,postnum,threadnum,avatar,avatartype,usergroup,additionalgroups,displaygroup,usertitle,regdate,lastactive,lastvisit,website,icq,skype,google,birthday,signature,allownotices,hideemail,subscriptionmethod,receivepms,receivefrombuddy,pmnotice,pmnotify,showimages,showvideos,showsigs,showavatars,showquickreply,showredirect,tpp,ppp,invisible,style,timezone,dstcorrection,threadmode,daysprune,dateformat,timeformat,regip,language,showcodebuttons,sourceeditor,buddyrequestspm,buddyrequestsauto,away,awaydate,returndate,awayreason,notepad,referrer,referrals,buddylist,ignorelist,pmfolders,warningpoints,moderateposts,moderationtime,suspendposting,suspensiontime,coppauser,classicpostbit,usernotes,ougc_awards) VALUES ('Xavier A.','51d543aeb378a838b5fa39dc4dca9bb9','FqfJYETd','DqAVc60xc72KmOFWdFovWhE4c7j6wo7qs1FsM309RlWVXbtB18','(email, removed for safety reasons)',0,0,'','',5,'',0,'',1618297406,1618297406,1618297406,'',0,'','','','',1,1,0,1,0,1,0,1,1,1,1,1,1,0,0,0,0,'-4',2,'',0,'','',X'4439f3ca','',1,0,1,0,0,0,0,'','',0,0,'','','0**$%%$1**$%%$2**$%%$3**$%%$4**',0,0,0,0,0,0,0,'','')

so mybb_user has no tables inside of it how do I fix this issue?

if you are using phpmyadmin go to mybb_users table..
click in structure tab.
find socialsites and click in edit.
check type... if type is int or something like put in default value 0, if not put '' in default value and save changes.

update problem is solved but now I have a more annoying issue, "Sorry, your host does not have the ability to extract .zip archives."
how do I fix that on plugin uploader, i tried installing curl

(2021-04-13, 08:38 AM)StrikersGamingTV Wrote: [ -> ]update problem is solved but now I have a more annoying issue, "Sorry, your host does not have the ability to extract .zip archives."
how do I fix that on plugin uploader, i tried installing curl

if you are using debian base linux use command below

apt update && apt install -y zip

if using redhat base linux use command below

yum install zip

(2021-04-13, 08:51 AM)martec Wrote: [ -> ]
(2021-04-13, 08:38 AM)StrikersGamingTV Wrote: [ -> ]update problem is solved but now I have a more annoying issue, "Sorry, your host does not have the ability to extract .zip archives."
how do I fix that on plugin uploader, i tried installing curl

if you are using debian base linux use command below

apt update && apt install -y zip

if using redhat base linux use command below

yum install zip

now what do I just restart server and see if it works?
I am on ubunto btw

(2021-04-13, 08:55 AM)StrikersGamingTV Wrote: [ -> ]
(2021-04-13, 08:51 AM)martec Wrote: [ -> ]
(2021-04-13, 08:38 AM)StrikersGamingTV Wrote: [ -> ]update problem is solved but now I have a more annoying issue, "Sorry, your host does not have the ability to extract .zip archives."
how do I fix that on plugin uploader, i tried installing curl

if you are using debian base linux use command below

apt update && apt install -y zip

if using redhat base linux use command below

yum install zip
now what do I just restart server and see if it works?
I am on ubunto btw

if using ubuntu is debian base command will work...
yes you can restart your server to check it.

(2021-04-13, 08:58 AM)martec Wrote: [ -> ]
(2021-04-13, 08:55 AM)StrikersGamingTV Wrote: [ -> ]
(2021-04-13, 08:51 AM)martec Wrote: [ -> ]
(2021-04-13, 08:38 AM)StrikersGamingTV Wrote: [ -> ]update problem is solved but now I have a more annoying issue, "Sorry, your host does not have the ability to extract .zip archives."
how do I fix that on plugin uploader, i tried installing curl

if you are using debian base linux use command below

apt update && apt install -y zip

if using redhat base linux use command below

yum install zip
now what do I just restart server and see if it works?
I am on ubunto btw

if using ubuntu is debian base command will work...
yes you can restart your server to check it.

same problem and now installing my plugins back I am getting more problems

so try this https://stackoverflow.com/a/37018618

(2021-04-13, 09:01 AM)martec Wrote: [ -> ]so try this https://stackoverflow.com/a/37018618

that worked but I keep getting this orange on plugins like Advanced sidebar
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups TEXT,themes TEXT,settings TEXT,wrap_content INT(1),dateline INT(10)) ENGI' at line 1Query:CREATE TABLE mybb_asb_sideboxes (id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,display_order INT(10) NOT NULL,box_type VARCHAR(25) NOT NULL,title TEXT,title_link VARCHAR(128) NOT NULL,position INT(2),scripts TEXT,groups TEXT,themes TEXT,settings TEXT,wrap_content INT(1),dateline INT(10)) ENGINE=myisam CHARACTER SET utf8 COLLATE utf8_general_ci;

all of the following plugins do not work for me

- Advanced Sidebox
- My Advertisements
- MyProfile
- Page Manager
- Plugin Uploader
- Servers Board
- Top Stat

unfortunately it will not log to error,log so I cannot assess what is up all i get is the internal fatal error thing

Tags also screws up my main page so that too.