MyBB Community Forums

MyBB Community Forums > 1.8 Support > General Support > HTTP 500 error on registration
Full Version: HTTP 500 error on registration
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2

mgX

2023-07-31, 07:16 PM
(2023-07-31, 07:07 PM)Laird Wrote: [ -> ]What's above "Stack trace:"? There should be an error message with details of the actual error.

2023/07/31 21:13:51 [error] 1767#1767: *4665 FastCGI sent in stderr: "PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115" while reading response header from upstream, client: 172.71.186.218, server: _, request: "GET /task.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.1-fpm.sock:", host: "raiding.to", referrer: "https://raiding.to/search.php?action=results&sid=b800a2e027326d791667aadee24c102b&sortby=lastpost&order=desc"
2023/07/31 21:13:59 [error] 1767#1767: *4672 FastCGI sent in stderr: "PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115" while reading response header from upstream, client: 162.158.18.144, server: _, request: "GET /task.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.1-fpm.sock:", host: "raiding.to", referrer: "https://raiding.to/"
2023/07/31 21:14:00 [error] 1767#1767: *4672 FastCGI sent in stderr: "PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115" while reading response header from upstream, client: 162.158.18.144, server: _, request: "GET /task.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.1-fpm.sock:", host: "raiding.to", referrer: "https://raiding.to/member.php?action=register"
2023/07/31 21:14:02 [error] 1767#1767: *4684 FastCGI sent in stderr: "PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115PHP message: PHP Warning:  Trying to access array offset on value of type null in /var/www/html/inc/functions_task.php on line 115" while reading response header from upstream, client: 162.158.18.144, server: _, request: "GET /task.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.1-fpm.sock:", host: "raiding.to", referrer: "https://raiding.to/member.php"
2023/07/31 21:14:33 [error] 1767#1767: *4679 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught mysqli_sql_exception: Field 'myachievements' doesn't have a default value in /var/www/html/inc/db_mysqli.php:335
Stack trace:
#0 /var/www/html/inc/db_mysqli.php(335): mysqli_query()
#1 /var/www/html/inc/db_mysqli.php(378): DB_MySQLi->query()
#2 /var/www/html/inc/db_mysqli.php(842): DB_MySQLi->write_query()
#3 /var/www/html/inc/datahandlers/user.php(1232): DB_MySQLi->insert_query()
#4 /var/www/html/member.php(386): UserDataHandler->insert_user()
#5 {main}
  thrown in /var/www/html/inc/db_mysqli.php on line 335" while reading response header from upstream, client: 162.158.18.113, server: _, request: "POST /member.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php8.1-fpm.sock:", host: "raiding.to", referrer: "https://raiding.to/member.php"

Laird

2023-08-01, 01:02 AM
Thanks. It looks like the error is due to the MyAchievements plugin. Do these queries solve the problem for your friend?
ALTER TABLE mybb_users CHANGE myachievements myachievements TEXT NULL;
ALTER TABLE mybb_users CHANGE myachievements_rank myachievements_rank TEXT NULL;
ALTER TABLE mybb_users CHANGE myachievements_level myachievements_level int(5) NOT NULL DEFAULT 0;

Now that I notice that your friend's site raiding.to is a black hat cracking/leaks board, I will stop providing support.
Pages: 1 2
MyBB Community Forums > 1.8 Support > General Support > HTTP 500 error on registration