MyBB Community Forums

Full Version: MYSQL Error Upon Registration
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
My myBB Forums works perfectly on XAMPP locally, when I moved migrated to a live webhost, there were alot of errors, and I managed to fix alot of them (php version problems), and now it works except the registration system. Everytime I register a new user, this shows up after putting your user info and pressing "Register" : 




Fatal error: Uncaught mysqli_sql_exception: Field 'default_tab' doesn't have a default value in /home/test/public_html/inc/db_mysqli.php:332 Stack trace: #0 /home/test/public_html/inc/db_mysqli.php(332): mysqli_query(Object(mysqli), '\n\t\t\tINSERT\n\t\t\tI...') #1 /home/test/public_html/inc/db_mysqli.php(375): DB_MySQLi->query('\n\t\t\tINSERT\n\t\t\tI...', 0, 1) #2 /home/test/public_html/inc/db_mysqli.php(839): DB_MySQLi->write_query('\n\t\t\tINSERT\n\t\t\tI...') #3 /home/test/public_html/inc/datahandlers/user.php(1232): DB_MySQLi->insert_query('users', Array) #4 /home/test/public_html/member.php(386): UserDataHandler->insert_user() #5 {main} thrown in /home/test/public_html/inc/db_mysqli.php on line 332
(2023-06-02, 08:13 PM)Taylor M Wrote: [ -> ]https://stackoverflow.com/a/16805951/20427569

rip, my webhost didn't give me perms to make change sql_mode. anyways thank you
Hi, check out this comment by .m. , with a suggestion on how to fix the plugin responsible :
https://community.mybb.com/thread-223174...pid1329455