+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: General Support (https://community.mybb.com/forum-176.html)
+--- Thread: [Error Message] MYSQL Error Upon Registration (/thread-238427.html)
MYSQL Error Upon Registration - ASCII - 2023-06-02
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
RE: MYSQL Error Upon Registration - Taylor M - 2023-06-02
https://stackoverflow.com/a/16805951/20427569
RE: MYSQL Error Upon Registration - ASCII - 2023-06-02
(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
RE: MYSQL Error Upon Registration - Michael.Sentry - 2023-06-03
Hi, check out this comment by .m. , with a suggestion on how to fix the plugin responsible :
https://community.mybb.com/thread-223174-post-1329455.html#pid1329455