DaffyDuck

tail /var/log/nginx/chicabow.com.error.log thrown in /var/www/chicabow.com/htdocs/system/Db/Db.php on line 638" while reading response header from upstream, client: 104.28.123.87, server: chicabow.com, request: "POST /admin/?app=core&module=members&controller=members&do=add HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php80-two-fpm.sock:", host: "chicabow.com", referrer: "https://chicabow.com/admin/?app=core&module=members&controller=members" 2023/08/07 23:56:17 [error] 58345#58345: *512 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught IPS\Db\Exception: MySQL server has gone away in /var/www/chicabow.com/htdocs/system/Db/Db.php:638 Stack trace: #0 /var/www/chicabow.com/htdocs/system/Db/Db.php(972): IPS\_Db->preparedQuery() #1 /var/www/chicabow.com/htdocs/system/Session/Admin.php(112): IPS\_Db->replace() #2 [internal function]: IPS\Session\_Admin->write() #3 /var/www/chicabow.com/htdocs/system/Redis/Redis.php(202): session_write_close() #4 [internal function]: IPS\_Redis->IPS\{closure}() #5 {main} thrown in /var/www/chicabow.com/htdocs/system/Db/Db.php on line 638" while reading response header from upstream, client: 104.28.123.87, server: chicabow.com, request: "POST /admin/?app=core&module=members&controller=members&do=add HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php80-two-fpm.sock:", host: "chicabow.com", referrer: "https://chicabow.com/admin/?app=core&module=members&controller=members" This is part of the Invasion software: MySQL server has gone away in /var/www/chicabow.com/htdocs/system/Db/Db.php:638 The line it is referencing, unfortunately, is just the part of the code that generates the error message. So, not helpful.

I am self-hosted, and I'm my own hosting company. This is a virgin UBUNTU 22.04 installation on a VM running on an ESXI server. Why does everything else work just fine, JUST the member approval / confirmation portion is failing?

In fact, as an additional information, the same happens when I attempt to manually create a new user. This is on an UBUNTU server, with MYSQL and PHP 8.0 - the dashboard claims that everything is fine (ie all software versions are what it wants), yet this one glaring issue persists.

When users get their registration emails, the link goes to a page that never finishes loading and generates a MYSQL error. Likewise, when I attempt to manually approve new users, I get the 'LOADING' message at the bottom, and after approx a minute, the same 'TEMPORARY ERROR, MYSQL WENT AWAY' . so somehow, MYSQL appears to time out. So far everything else works, just not the new user registration / approval / verification. Any ideas?

Right, but does anyone know of any specific issues they have encountered?

So, what about PHP 8.2?

OK, the issue appears to have been the REDIS cache. After disabling it, and disabling all plugins and applications, switching to PHP 8.0 yielded a functional site. Finally. Gonna leave it running (after I enabled the minimal plugins and apps) to make sure it holds up, and then will finally tackle the 4.7.6 update, followed by a switch to PHP 8.1 or PHP 8.2. Hopefully this will be useful to others.

Disabled REDIS (switched to FileSystem). Switched to PHP8.0. This is the error I'm getting. 2023/01/18 06:32:26 [error] 52262#52262: *66 FastCGI sent in stderr: "PHP message: PHP Fatal error: Declaration of IPS\forums\hook638::getItemsWithPermission($where = [], $order = null, $limit = 10, $permissionKey = 'read', $includeHiddenItems = IPS\Content\Hideable::FILTER_AUTOMATIC, $queryFlags = 0, ?IPS\Member $member = null, $joinContainer = false, $joinComments = false, $joinReviews = false, $countOnly = false, $joins = null, $skipPermission = false, $joinTags = true, $joinAuthor = true, $joinLastCommenter = true, $showMovedLinks = false) must be compatible with IPS\forums\ignoretopics_hook_topicModel::getItemsWithPermission($where = [], $order = null, $limit = 10, $permissionKey = 'read', $includeHiddenItems = IPS\Content\Hideable::FILTER_AUTOMATIC, $queryFlags = 0, ?IPS\Member $member = null, $joinContainer = false, $joinComments = false, $joinReviews = false, $countOnly = false, $joins = null, $skipPermission = false, $joinTags = true, $joinAuthor = true, $joinLastCommenter = true, $showMovedLinks = false, $location = null) in /var/www/chicabow.com/htdocs/i" while reading response header from upstream, client: 108.228.233.88, server: chicabow.com, request: "GET /index.php?app=forums&module=forums&section=index&do=plugin_recentTopics&csrfKey=0085e4835beb97e2ed1f2716750706a3 HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php80-two-fpm.sock:", host: "chicabow.com", referrer: "https://chicabow.com/"

I keep getting random errors claiming errors in the theme (freshly created default theme), or broken formatting of the loaded page - reloading usually fixes the formatting. So, I was thinking that it may be a caching issue (despite me repeatedly wiping the forum caches). I used REDIS as a means to accelerate and cache both the forum and MySQL - could it be that it is REDIS (a caching system that is being used less and less) causing my issue? What is the cleanest alternate setting under the ADVANCED CONFIGURATION --> DATA STORAGE ? I'm assuming FILE SYSTEM might even be more 'plain vanilla' than 'MySQL Database'? What is everyone else using?

After PHP 8.0 update....

This is all the extensions/modules in existing PHP 7.4, so let me switch to PHP 8.0 again, and see how that fares. Thank you!

That would be IPB, since the issue is with the forum and my still failing upgrades to PHP8. I'm running 4.7.2.1 on PHP7.4, with Redis caching for mySQL, which is rock solid. The moment I update my server to PHP8.0, things get unstable, themes are broken, error messages that disappear when I reload a page, etc... Even with all plugins and all applications disabled, and switching to default theme. Reverting to PHP7.4, and everything is stable again. My first suspicion is that I might be missing some needed modules in PHP8.0 - is there a document detailing the PHP8.0 requirements?

This is all nice and good, and while I'm totally in favor of forcing such tech updates - I just ran into nightmares when updating my site's backend to PHP 8.0 (same with PHP 8.1), and had to revert back to PHP 7.4 for the time being. The PHP 8 compatibility scanner flagged ONE plugin, which I had subsequently removed, and yet my site was still badly broken, requiring me to revert back to PHP 7.4. So, the compatibility scanner, right now, doesn't appear to catch things like Themes (IPSFocus themes were broken) or other issues even within IPS 4.7.2. While we are heading into November, I hope these issues will be addressed.

Not quite sure why my currently active license does not include support requests anymore - the support request page sent me here. I'm updated my self-hosted Invision site to PHP 8.1, which showed some themes as incompatible and some other incompatibilities . so far so good. In the process of working with these, I have accidentally deleted the default Invision theme, and can't find any place to download it from. So, first of all - HELP with that please and get me some way to get that theme back, please. Next, how do I get someone to check into my site and let me know what all the issues are, and if I should just revert back to PHP 7.4? Help please.

FYI - works fine with current version of 4.5.x This does not work, by the way. -- EDIT: Never mind, it *does* work, but there are several 'anon_poster_hash', be sure to hit them all.