Mark H

You're welcome, we're glad the problem is sorted out. 🙂
 

That screenshot appears to show a Theme which is customized.
As my colleague noted, disable all third party applications and plugins and switch to an unmodified theme then try again.
What is the result?

I would advise on getting yourself on a managed hosting environment if you are having problems with configuration there.

If I've understood what you mean, there isn't a way to do that natively. But it's something a 3rd-party app should be able to do. You may wish to check our Marketplace, or post in the Marketplace-> Requests section of the community.

OK, the last member to register and be approved is the one showing on the front end. What you see there is correct.
All registrants after that person are either flagged as needing admin approval, or they haven't replied to their validation email yet.
Please visit your ACP -> Members page and note the listing. 

Thank you, I am investigating now. Please do not login to the admin panel or make any changes to the install.
I'll update this topic when done.

A followup note: Be sure you remove that line from constants.php when you are all finished, if you added it as above.

Do you have access to phpMyAdmin?
If so, use it to view the database and in the list of tables, check the "Overhead" column.
The value there should be zero most times. (MySQL should recover that overhead automatically, but it sometimes doesn't.)
If the "Overhead"value for your table is 13 GB, that's something your Host needs to address.
You can run an "Optimize" on that table to get back the space temporarily, but long-term is something your Host needs to fix in MySQL so it recovers it automatically on a timely basis.

Those 5 items must be fixed by your Host, in either the server-wide php.ini file, or in an account-specific php.ini file as an override in your server account. They may need to recompile PHP to add some missing Extensions.
Once that has been done, reload that page and check to see if the red items are now green.

Yes, publishing is done by a system task that runs periodically. (It's either 5 or 10 minutes.)

You're running PHP 7.2 currently so that is correct as it is generating a PHP error. You would need to update to PHP 7.4 or 8.0 or 8.1

Hi Mark, I fully agree!
 
I replied with the following 
So they replied with
I am in the process of ripping them a new one and taking back root access. I will be moving the server as soon as the site is back up.
 

The missing items shown in that screenshot are almost all default PHP Extensions.
While your host may be technically correct that PHP is "active and working", that does not mean it is working at a level needed to run our software.
If they continue to insist that the problem is not with them, I would look for a new host.
All of those items must be in place, and only your Host can do that.

Glad we could be of assistance 🙂 . 

Don't say it.
 
 
Don't say it.
 
 
 
Don't say it.
 
 
 
Don't say it.
 
 
 
Don't say it.
 

A patch isn't needed, the issue was fairly specific to your community and maybe a handful of others. The issue has been fixed for you. We'll work further on the underlying cause to prevent it occurring in future.

It appears your site has at least one update or patch pending. Please visit your ACP -> Support page and check for a box with an orange alert about an update, then process it.
Does the same problem happen?
If it does, please then disable all 3rd-party items (apps, plugins, and themes), then trigger an email notification.
Does the same behavior then happen?

(NE) Language - user counts 1.0.0.xml

Ahead of some but sounds like you're heading in a good path here. Only suggestion I would make is to keep on top of updates, the smaller jumps you have to make the easier the upgrade usually is 🙂 .

I think a more important item to check first is what the error is saying; the email error logs table is growing rapidly.
At 13 GB, that may indicate you have repeated email send failures.
Have you checked the content of one of the log entries? ACP -> Support page -> "System Log" and "Error Log" buttons. Also check ACP -> Email Settings -> Email Error Logs button, in upper right.
As to your second question, pruning is done by a system task, it's not instant.

I think a more important item to check first is what the error is saying; the email error logs table is growing rapidly.
At 13 GB, that may indicate you have repeated email send failures.
Have you checked the content of one of the log entries? ACP -> Support page -> "System Log" and "Error Log" buttons. Also check ACP -> Email Settings -> Email Error Logs button, in upper right.
As to your second question, pruning is done by a system task, it's not instant.

No problem. I noticed you have had a few topics around lately, and wondered if you have seen our guides. Of course still let us know if you have any issues, but thought I would point them out in case you hadnt seen them
https://invisioncommunity.com/4guides/welcome/about-invision-community-r7/
 

Q&A is a good feature, yes. Make sure to create questions whose answer(s) are specific to your community.
Don't use math equations or "What color is the Sun" type questions, as it's often humans doing the registration itself, then turning the account over to a bot to post spam, and they know the answers already. There are apparently also sites that keep lists of answers for common questions, so be sure to change your questions regularly for maximum benefit. 🙂
 

It would be better to make a complete backup of it first, especially the database. For just in case.

Hi Steve!
Don't worry, coincidentally Approval Queue UI updates are currently in the works and hopefully will be included in one of the next 4.7 releases! Among other enhancements, exposing the reason content is held for approval is on the list so stay tuned.
Thanks!