August 13, 2023: Just testing some shit

[fluffy]

I'm just testing some shit on the forum to try to cut down on white-screen errors, and figured that making a DRC thread would be a good way to go about doing that, since there hasn't been one of these in a while anyway.

So what's up with everyone?

Personally I've been having a lot of problems with chronic pain and depression and haven't been able to get much done, although I'm enjoying cooking and watching TV and stuff. My most recent binge has been rewatching all of Venture Bros before seeing the recent movie. I'm almost done with the whole series. I'd forgotten just how internally referentially-dense the last couple of seasons had become. Also noticing how nearly every single episode has the Wilhelm Scream in it somewhere, which I assume was done as a similar sort of thing as the waving snail in Adventure Time or the hidden squirrel thing that appeared in every episode of the original She-Ra.

[fluffy]

Anyway now I'm posting a reply to the thread to see if the white screen errors are still happening.

[fluffy]

It wasn't a server load issue (although I did fix a thing that was causing it to go way higher, by banning an extremely resource-hungry bot). Keeping this here for a bit while I investigate this database issue:

Code: Select all

[Sun Aug 13 17:54:04.071859 2023] [fcgid:warn] [pid 190933:tid 133526466008832] [client 97.113.92.26:51487] mod_fcgid: stderr: PHP Fatal error:  Uncaught mysqli_sql_exception: Duplicate entry '17-12518' for key 'phpbb_topics_posted.PRIMARY' in /home/fightmaster/songfight.net/forums/phpbb/db/driver/mysqli.php:193, referer: https://songfight.net/forums/viewtopic.php?f=20&t=12518
[Sun Aug 13 17:54:04.072020 2023] [fcgid:warn] [pid 190933:tid 133526466008832] [client 97.113.92.26:51487] mod_fcgid: stderr: Stack trace:, referer: https://songfight.net/forums/viewtopic.php?f=20&t=12518
[Sun Aug 13 17:54:04.072046 2023] [fcgid:warn] [pid 190933:tid 133526466008832] [client 97.113.92.26:51487] mod_fcgid: stderr: #0 /home/fightmaster/songfight.net/forums/phpbb/db/driver/mysqli.php(193): mysqli_query(Object(mysqli), 'INSERT INTO php...'), referer: https://songfight.net/forums/viewtopic.php?f=20&t=12518
[Sun Aug 13 17:54:04.072068 2023] [fcgid:warn] [pid 190933:tid 133526466008832] [client 97.113.92.26:51487] mod_fcgid: stderr: #1 /home/fightmaster/songfight.net/forums/phpbb/db/driver/factory.php(345): phpbb\\db\\driver\\mysqli->sql_query('INSERT INTO php...', 0), referer: https://songfight.net/forums/viewtopic.php?f=20&t=12518
[Sun Aug 13 17:54:04.072113 2023] [fcgid:warn] [pid 190933:tid 133526466008832] [client 97.113.92.26:51487] mod_fcgid: stderr: #2 /home/fightmaster/songfight.net/forums/includes/functions.php(918): phpbb\\db\\driver\\factory->sql_query('INSERT INTO php...'), referer: https://songfight.net/forums/viewtopic.php?f=20&t=12518
[Sun Aug 13 17:54:04.072137 2023] [fcgid:warn] [pid 190933:tid 133526466008832] [client 97.113.92.26:51487] mod_fcgid: stderr: #3 /home/fightmaster/songfight.net/forums/includes/functions_posting.php(2274): markread('post', 20, 12518), referer: https://songfight.net/forums/viewtopic.php?f=20&t=12518
[Sun Aug 13 17:54:04.072159 2023] [fcgid:warn] [pid 190933:tid 133526466008832] [client 97.113.92.26:51487] mod_fcgid: stderr: #4 /home/fightmaster/songfight.net/forums/posting.php(1494): submit_post('reply', 'Re: August 13, ...', '', 0, Array, Array, true, true), referer: https://songfight.net/forums/viewtopic.php?f=20&t=12518
[Sun Aug 13 17:54:04.072182 2023] [fcgid:warn] [pid 190933:tid 133526466008832] [client 97.113.92.26:51487] mod_fcgid: stderr: #5 {main}, referer: https://songfight.net/forums/viewtopic.php?f=20&t=12518
[Sun Aug 13 17:54:04.072233 2023] [fcgid:warn] [pid 190933:tid 133526466008832] [client 97.113.92.26:51487] mod_fcgid: stderr:   thrown in /home/fightmaster/songfight.net/forums/phpbb/db/driver/mysqli.php on line 193, referer: https://songfight.net/forums/viewtopic.php?f=20&t=12518

[fluffy]

okay if I'm understanding correctly there's a bug in phpBB where it shits itself if someone has the audacity to post twice in the same topic. Gonna dig around in the code to see if there's an easy fix, which might include upgrading the forum which is a bit behind anyway.

[fluffy]

Okay yeah this is just more fallout from the php 8 update the server went through a while back (which is also why the site was broken for a little bit). I'll update the forum to the latest phpBB soon.