Clover13

Nothing changed in settings. Been running the latest version of InvisionCommunity 4.7.4 for awhile now. The one change today was moving servers by my host, but I wouldn't think that would influence it as it was a full backup and restore on the new server. Also quite a few pictures were posted in the same topic post (by OP) and some thumbnailed while others didn't. Here's an example of one that thumbnailed but didn't have that 216px width set <img class="ipsImage ipsImage_thumbnailed" data-fileid="157995" data-ratio="66.70" width="1000" alt="xxxxxxxxx" data-src="xxxxxxxxx" src="xxxxxxxxx" style="height: auto;" data-loaded="true">

Hi Ryan, that is what I am referring to as well. Below is a screenshot of my settings, however, the thumbnail is being displayed as 216px width?

Not sure where there is a setting that drives this, as I thought the post settings state a maximum image dimension and anything larger gets resized to it. Somehow it seems some are being resized in a topic while others aren't (same topic post, same poster). The only place I see thumbnails mentioned is in Gallery settings and these aren't in or from Gallery but rather direct uploads to the forum topic. Example de-ided with xxxxxxxxx <img class="ipsImage ipsImage_thumbnailed" data-fileid="157996" data-ratio="66.67" style="width:216px;height:auto;" width="1000" alt="xxxxxxxxx" data-src="xxxxxxxxx" src="xxxxxxxxx" data-loaded="true">

Support checks were all clean. And MariaDB was setup to use INNODB for the InvisionCommunity tables. Wonder if it's our heavy usage of Activity Streams that contributes to that particular table sizing if they are related?

@Sonya* and @HDiddy did you settle in on your OpenSearch installation/provider? Wondering how the pricing worked out. I noted Bonsai goes from $20/month then up to $700/month, that's quite a jump.

An optimize on the table knocked it down to 1.1GB

If it helps:

Overhead for all tables just shows a "-"

Addendum, core_search_index is around 5GB+, which isn't particularly large but it does account for more than half of the DB storage and seems to be growing at an incredibly fast pace while activity grows at a much slower pace. This was particularly noticeable from the last few upgrades where the size of this table has nearly doubled to tripled in the last 9 months to a year. The next largest tables are: forum_posts at 741MB core_reputation index at 448MB core_follow at 99MB

It appears core_search_index is the culprit. What would cause it to be more than half of the DB size?

Seems my database size has increased significantly and not aligning with traffic increases. Any suggestions on where to review to troubleshoot?

Ok thanks Marc. Seems to be ok now!

Apologies, it's checkbox and Yes/No that aren't working

Radio does work

I see the profile fields in the profile, but I can't customize a Group Promote rule with them. Yes/No Select

Not sure where this setting is, I'll keep looking but if anyone knows, please post it here 🙂

Getting hit hard with spam and none of these new accounts have spam check logs. It is enabled. Any idea what's happening?

For now I just commented out the streamOverview on both sites so the customizations are consistent.

OK, I guess I'm trying to figure out why one site shows the streamBlurb and another doesn't and what is causing that. Any idea there?

What is the $form reference in the following code for streamWrapper? I have one site showing the streamOverview blurb and another that isn't but unclear what setting is influencing this? <div class='ipsFlex-flex:11 sm:ipsMargin_bottom:half'> <h1 class='ipsType_pageTitle'> <span data-role='streamTitle'>{$stream->_title}</span> </h1> {{if $form}} <p class='ipsType_reset ipsType_normal' data-role='streamOverview'> <span data-role='streamBlurb'>{$stream->blurb()}</span> </p> {{endif}} </div>

You would still see it however even if you couldn't react to it yourself no? Do you see the reactions available to select? Hmm apparently that was it, I had thought you could always see the options you just couldn't cast one. Thanks Jim, sorry to waste your time on that one!

OK sure, that works.

Yes, it is enabled at the Member Group level (Administrators) and for my account. This is a new site I just started up, so would it be better to discuss over PM?

The reaction blurb HTML/CSS always shows this whether it's enabled or disabled in ACP: <div class="ipsReact_blurb ipsHide" data-role="reactionBlurb"> </div> Note this isn't the case where it's whited out, or only displays onHover. It's always hidden with that HTML/CSS output.

I figured it out, thanks Randy, your links helped spark where to look. It came down to the S3 permission sets for those objects (certain images files) were not set to public read. Also the favicon.ico did not move over in the S3 Storage Location usage, however it was referenced by it (i.e. tried to pull from CDN/S3 but was still local on my server). Not sure if that is a bug, but I just moved it over manually to S3 and set the public read access on the object.