MyBB has experienced an internal SQL error and cannot continue.[/color]
SQL Error:1364 - Field 'closed' doesn't have a default value Query: INSERT INTO mybb_threads (`fid`,`subject`,`prefix`,`icon`,`uid`,`username`,`dateline`,`lastpost`,`lastposter`,`views`,`replies`,`visible`,`notes`) VALUES ('152','test','0','0','1','SoggyCow','1448298650','1448298650','SoggyCow','0','0','1','')
I get this error when I try to post on my forum.
I recently migrated my forum files and database to a new host.
What could be the problem?
Also, im using Mybb 1.6 something
Try to copy this table again, and check that all default values are the same. Actually you'd better do it with all tables. Seems you missed some options when moving.
You can also try to set default value for "closed field" in mybb_threads.
1. Check if they are all the same as what?
2. When i imported the database, there were no options but to select which schema to drop the backup in.
3. I don't understand what you mean by set default value for "closed fields".
I just dropped the schema, and made a new one, imported the latest backup and still, I get this error.
its been 10 days i still cant figure this out
please note that
MyBB 1.6 series is no longer supported.
anyway, you can try below SQL query for
mybb_threads table
ALTER TABLE `mybb_threads` CHANGE `closed` `closed` VARCHAR(30) NOT NULL DEFAULT '';