AlexJ

Charles started saying something about "downloads"...  would someone else like to say just a few words more? 😄 

It changed my email flow.. LESS EMAILS in my mailbox! :D

Thank you for bringing this issue to our attention! I can confirm this should be further reviewed and I have logged an internal bug report for our development team to investigate and address as necessary, in a future maintenance release.
 

This issue has been resolved in our recently released 4.7.9 version. Please upgrade if you are seeing this issue, and let us know if you see any further issues.

I took a position at Help Scout as a JS engineer 🙂 

End of an era ❤️

IPB does not have a default way of mass deleting IP bans.  Manually editing the database is not supported and it is highly recommended not to touch directly unless you know exactly what you're doing and understand the potential repercussions.  If you ignore this advice, I would HIGHLY recommend taking a backup just to be safe before hand.  You make any changes at your own risk.  I will not be held liable for anything that does not work as expected or if a suggested solution blows up your site.  Copyright 2023 Randy Calvert.  All rights reserved.  (Is that enough of a disclaimer!?)
Look in the core_banfilters table.  You'll find all of the ban records there.
 

Huge thanks to @Daniel F for risking his iPhone by installing the latest iOS beta to get this feature working for us!

6 hours of downtime is simply unacceptable. I'm a huge fan of Invision, love the amazing software they develop and maintain for us. But when I pay 150/month for a hosted service, I expect more. In 20 years of being self hosted on inexpensive shared hosting services, I've never had more than a few minutes of downtime at a time. 
The fact that Invision relies on AWS and that the issue may lie with AWS is irrelevant to us, the customers. As a professional, if I can't deliver a service to my customer because Invision is down, I can't charge my customers. If my forum is down, I can't earn revenue from ads. I can't just tell the customers (or the ad network) "it's not my fault, the software cloud service I'm using was down" and continue to charge them the same amount. I have no choice but to take responsibility and suffer the loss in revenue and reputation. 
Invision should  take responsibility here, offer $ compensation to paying customers, and deal with whatever service providers they use on their own term. As Invision customers, that's not our problem. 

I have to agree. Every image page refreshed. I almost would have rathered a built in slider like the main page block and if you click on the image, then it takes you to the image page. So you get internal links to image pages.
I have a banner ad above and its not positioned well for this and doesn't play nice.

My idea for a ChatGPT integration:
autoregister new users let them create content that fits my forum topic auto moderate my forum If you get this done I will asap switch to a cloud plan.

 

I've added this as a member group setting now, so all your member groups can have different icons and icon colors, as opposed to just a different pin color.
You say "many bugs". Was it just those two? With bug 2 I assume you mean it still shows in the popup even when disabled? Saving the form a second time after disabling it would have "fixed" that. Fixed this in the next version.

I've been using Debian for the last 10+ years on all of my production servers and have never had any OS or distribution related issues.
Ubuntu is a different story, but that's Ubuntu, not Debian.

Seeing below error when I try to post on user profile... it happens randomly but it's consistent and can be reproduced - especially, when you try to comment on existing profile status update.  How do I figure out which application or IPS code is causing it? Thanks. 

 
;(function($,_,undefined){"use strict";ips.controller.register('core.front.statuses.status',{_commentStatusID:null,initialize:function(){this.on('click','[data-action="loadPreviousComments"], [data-action="loadNextComments"]',this.paginate);this.on('submit','[data-role="replyComment"]',this.quickReply);this.on(document,'addToStatusFeed',this.addToStatusFeed);this.setup();},setup:function(){this._commentStatusID=this.scope.attr('data-statusID');},paginate:function(e){e.preventDefault();var feed=$(e.currentTarget).closest('[data-role="statusComments"]');var paginateRow=$(e.currentTarget).closest('.cStatusUpdates_pagination');paginateRow.html(ips.templates.render('core.statuses.loadingComments'));ips.getAjax()($(e.currentTarget).attr('href')).done(function(response){paginateRow.replaceWith(response);feed.find('meta').remove().end();$(document).trigger('contentChange',[feed]);}).fail(function(response){paginateRow.replaceWith('');ips.ui.alert.show({type:'alert',icon:'warn',message:_.isUndefined(response.responseJSON)?ips.getString('errorLoadingContent'):response.responseJSON,});});},quickReply:function(e){var form=this.scope.find('[data-role="replyComment"] form');if(form.attr('data-noAjax')){return;} e.preventDefault();e.stopPropagation();var self=this;var feed=$(e.currentTarget).closest('[data-role="statusComments"]');var replyArea=this.scope.find('[data-role="replyComment"]');var submit=this.scope.find('[type="submit"]');var page=feed.attr('data-currentPage');if(!page){page=1;} var currentText=submit.text();submit.prop('disabled',true).text(ips.getString('saving'));ips.getAjax()(form.attr('action'),{data:form.serialize()+'&submitting=1&currentPage='+page,type:'post'}).done(function(response){self.trigger('addToStatusFeed',{content:response.content,statusID:self._commentStatusID});}).fail(function(){form.attr('data-noAjax','true');form.submit();}).always(function(){submit.prop('disabled',false).text(currentText);});},addToStatusFeed:function(e,data){if(!data.content||data.statusID!=this._commentStatusID){return;} var content=$('<div/>').append(data.content);this.scope.find('[data-role="statusComments"]').append(content);ips.utils.anim.go('fadeInDown',content);ips.ui.editor.getObj(this.scope.find('[data-role="replyComment"] [data-ipsEditor]')).reset();$(document).trigger('contentChange',[this.scope]);}});}(jQuery,_));; ;(function($,_,undefined){"use strict";ips.controller.register('core.front.statuses.statusFeed',{initialize:function(){this.on('submit','[data-role="newStatus"] form',this.submitNewStatus);this.setup();},setup:function(){},submitNewStatus:function(e){e.preventDefault();e.stopPropagation();var self=this;var feed=this.scope.find('[data-role="activityStream"]');var replyArea=this.scope.find('[data-role="replyComment"]');var form=this.scope.find('[data-role="newStatus"] form');var submit=this.scope.find('[data-action="submitComment"]');var textarea=form.find('textarea');var currentText=submit.text();if(!textarea.val()){ips.ui.alert.show({type:'alert',message:ips.getString('validation_required'),icon:'warn'});return;} submit.prop('disabled',true).text(ips.getString('saving'));ips.getAjax()(form.attr('action'),{data:form.serialize(),type:'post',bypassRedirect:true}).done(function(response){var content=$('<div/>').append(response);var comment=content.find('.ipsComment,.ipsStreamItem').first();feed.prepend(comment);ips.utils.anim.go('fadeInDown',comment);$('textarea[name="'+textarea.attr('name')+'"]').closest('[data-ipsEditor]').data('_editor').reset();$(document).trigger('contentChange',[comment]);}).fail(function(xhr){self.scope.find('#elStatusSubmit').parent().html(xhr.responseText);$(document).trigger('contentChange',[self.scope.find('#elStatusSubmit').parent()]);}).always(function(){submit.prop('disabled',false).text(currentText);});}});}(jQuery,_));;  

I don't know the performance barriers to SQL databases but my thought was more a separation of concerns. Would it be better to have separate DB file for say all marketplace apps? vs modifying core files? I am sure I have database detritus of columns from old stuff that just keeps hanging around. 

To be honest, I kind of wish this thread wasn't here with debate starting etc. I basically just wanted a support ticket with IPS. I thought this is how it worked now days.

4.4.9 is just slightly over 3 years old.
  
Previous was 7.2 now 8.1
  
Nope was running a version of Maria DB that is only a year old. Still using the same Maria DB
  
Spent $$$$ (a lot) working with top IPB developers to optimize every single bit of code for both PHP 8 and IPS 4.7.7 (one by one), It very expensive and took months, I am confident I am working with the best people in this regard. 
  
I am 100% confident that I applied the settings correctly.  I did preciously what everyone else is doing. The problem is that users who don't know how to clear their browser cache end up being locked out of the site. I believe others don't notice because only .001% complain. Since I have millions of visitors, I get hit with lots of feedback.
  
I have been a system administrator and developer since the early 2000's. But I also work with other very skilled system administrators and developers. You should know I am not a hobbyist. We are operating a registered corporation and have been in business many years.
  
I agree, there is no point passing blame around. My thread here is not intended for that. The goal is for solutions only. I want you to know that you have been very generous and kind with your assistance to both me and many others around this community. I really appreciate that Randy. Thank you for being so amazing.

While I am upset that the upgrade has caused (and is still causing me) a lot more stress than ideally I would have wanted, I have nothing but gratitude for the software, the entire IPB team and this community. I feel very blessed to have a business that runs on IPS software

After days of experiments and hours of head scratching, I can only conclude that 4.7.7 is more resource intensive than 4.4.9

I suppose I wrongly assumed that it would be more efficient and not less. However, in retrospect, I guess since it is more complex, and doing many more things, it makes sense.
Before upgrading I believe it's important to make sure one has sufficient additional resources available. I was not prepared to go from average load of 8 to average of 25.. shocking!!!  Now my site is really struggling.  There really isn't anything broken per se, thus my next option is to perform emergency migration to a more powerful server.

Again, thank you all for your input. I greatly appreciate it. 🙂

It's not really a fair comparison. The reason people use our site goes away without 3rd party resources. (it's basically like having a car without wheels)

With that said, I tried it and the load did go down, but still higher than on 4.4

All of my 3rd party resources were inspected (and or improved) by a really incredible developer prior to upgrade.
At this time, as aforementioned I don't see any errors in the logs.

The main consumer of cpu is mysql so I started checking slow query logs and monitoring process list
The main things are all long running default IPS stuff that aren't anything to do with 3rd party plugins. (such as the example I gave above that was running for over 10 seconds)
I also followed directions on setting up cloudflare for guest caching. I think it might have helped a little but wasn't a golden ticket.

Thank you for your response 🙂

No worries, i shared info, will delete PM to be on safe side 🙂 Tks! 

Sorry, I have already removed that feature and uploaded a new version. Not necessary anymore. 
Thank you.

@Adriano Faria after the testing again, the issue still occurs. On my dev site it doesn't, and the only different between the live and dev site that I use database prefix. The issue occurs only on a database has prefix tables. Also, from what I noticed that @AlexJ has prefix for his database tables "ipb_" and me I have "ibf_".
As I mentioned above on my dev site where is no prefix the issue never occurs. 

This still allows the purchase but holds the account for admin approval, right? That's not what I want. I don't want guests to purchase at all.

So IPS now has @Ehren who is best known for what he does. I have like 3-5 themes from him. So now, when we can see dark version in IPS and new changes on default theme like you did for Gallery 🙂 

@Adriano Faria sorry mate the error me and Alex mentioned still occur. 
 
UPDATE `ibf_forums_posts` `forums_posts` SET `banFromTopic`=0,` ' WHERE pid=9649 IPS\Db\Exception: Unknown column 'banFromTopic' in 'field list' (1054) #0 /forums/system/Db/Db.php(1159): IPS\_Db->preparedQuery('/*forums::nsane...', Array) #1 /forums/system/Patterns/ActiveRecord.php(520): IPS\_Db->update('`ibf_forums_pos...', '`banFromTopic`=...', 'WHERE pid=?') #2 /forums/applications/forums/sources/Topic/Post.php(353): IPS\Patterns\_ActiveRecord->save() #3 /forums/system/Content/Item.php(1260): IPS\forums\Topic\_Post->save() #4 /forums/applications/forums/sources/Topic/Topic.php(667): IPS\Content\_Item->processAfterEdit(Array) #5 /forums/applications/forums/modules/front/forums/topic.php(678): IPS\forums\_Topic->processAfterEdit(Array) #6 /forums/system/Dispatcher/Controller.php(107): IPS\forums\modules\front\forums\_topic->edit() #7 /forums/system/Content/Controller.php(50): IPS\Dispatcher\_Controller->execute() #8 /forums/applications/forums/modules/front/forums/topic.php(39): IPS\Content\_Controller->execute() #9 /forums/system/Dispatcher/Dispatcher.php(153): IPS\forums\modules\front\forums\_topic->execute() #10 /forums/index.php(13): IPS\_Dispatcher->run() #11 {main} BACKTRACE
#0 /forums/init.php(1037): IPS\_Log::log('UPDATE `ibf_for...', 'uncaught_except...') #1 [internal function]: IPS\IPS::exceptionHandler(Object(IPS\Db\Exception)) #2 {main}  
On ?do=edits