Steve Herschbach

Thanks guys, will set it up. Consider this also a vote for a simple ban button next to the flag as spammer button on the member page.

I suspect I'll feel stupid when I learn the answer to this, but I have looked and am not seeing it. My mods via the member profile can flag them as a spammer. As I understand it, this bans the person, removes their content, and adds them to an IC spammer list. Heavy stuff. However there is no simple ban button which I would think would be right there next to the flag as spammer button. That only seems accessible to me as Admin via the Admin area, a place I do not want my mods getting into. How do I give the Mods the basic ban capability, which can be reversed, content deletion is an option, and not flag people as spammers? Without giving them full ability to change basic forum functions? Thanks.

And Jim, I am now a fan of your open support system for that exact reason!! 👍🏼

Yeah that's what I think also. Just trying hard here to do my due diligence to eliminate all possibilites with making assumptions about things I only am half knowledgeable in. Thanks Jim. But since I have you on the horn and to clarify and beat it to death - there is no way a php script can inject something into a database table to cause it to crash?

06/14/2024 12:49 AM template_error IPS\Db\Exception (144) SELECT `app`, `type`, `type_id`, `member_id`, `rep_rating`, `reaction` FROM `core_reputation_index` ... The log entry was triggered by a guest (Guest) 9 hours ago The URL of page the error occurred on was deleted IPS\Db\Exception::144 SELECT `app`, `type`, `type_id`, `member_id`, `rep_rating`, `reaction` FROM `core_reputation_index` LEFT JOIN `core_reactions` ON reaction=reaction_id WHERE ( reaction_enabled=1 AND app='forums' AND type='pid' AND ( type_id IN(146373,146362,146327,146298,146292,146288,146271,146253,146208,146151,146135,146130,146121,146058,146054,146051,145963,145924,145905,145812,145779,145776,145758,145742,145489) ) ) Table './XXXXX_dpforum/core_reputation_index' is marked as crashed and last (automatic?) repair failed

I am having these two tables repeatedly crash, with days or weeks between occurences. Usually they are repairable but in a couple cases were so corrupt they could not be repaired, I needed to use a backup. I have my provider looking hard at it and they are saying the mysql server was up when this last happened. What I need to know is if there is anything, anything at all in the Invision software that could cause either of these tables to crash? The search index causes few problems and is easily rebuilt. The reputations_index going bad though immediately generates errors across the forum, so it is a big problem right away. I am running 4.7.17 IC with PHP Version 8.1.28 and mySQL Version 8.0.36 Let's say Invision says it can't be the software and the provider (Pair Networks) says it's not them. Typical in these situations at times, we get caught in the middle with no solution. If I shut off Reputations in the settings, will this index be cut out of the loop entirely? I really hate to do that but if I can't get any resolution to this it is my last ditch fallback solution.

I added a new Full Member group (ID 14) some time ago and restricted what new members can do, automatically advancing them to the Full Member group once certain goals are hit. Mainly a way to slow down spammer by limiting their options on joining. I am trying to track down why my forum stalls for up to 15 and up 30 seconds on random events. Had Invision look into one obvious error. Doubled my self-hosted memory. Still getting these odd pauses, so I'm looking for configuration errors. It seems like my troubles started when I added this new member group. I just saw that it is not in the conf_global file which has: $INFO['banned_group'] = '5'; $INFO['admin_group'] = '4'; $INFO['guest_group'] = '2'; $INFO['member_group'] = '3'; $INFO['auth_group'] = '1'; I assume this is normal as is the Moderator group not being here, but just checking everything that I can think of. Better to ask than assume. Thanks.

I have inquired with Pair. They are not fly by night but anyone can make mistakes. Check your email - I am looking for a quote on moving my setup intact to Invision, and the monthly cost to run it based on what you folks have seen of my size. 640MB database, 40GB of server space (mostly images and pdf plus forum files), 1200GB of monthly bandwidth generated by 9000 page views a day.

Spoke too soon, core_reactions_index just crashed, corrupt, took forum down, which is how this all started a month ago. Back then I cleared and rebuilt the index losing all the "likes" history, but it just perpetuated the problem, digging me a deeper hole. This time I have loaded a backup of the database from 24 hours ago, back up and running. But with the crashed version gone, will it be possible to figure out why it crashed? Frustrating.

Ok, did not die on the operating table so thumbs up there. And thanks to efforts by Jim and Daniel the error has been eliminated. My pages based website and forum is running error free and faster than it has in a long time. So thank you gentlemen, I continue to be a happy Invision customer. And I promise to be more patient with new (two year old) support system should I ever need it again. 🙂

Thank you Jim. Sorry if I am grumpy but dealing with this and imminent hernia surgery - well, I may not be in my best form at the moment. I have no plugins running. Minimal customiztion to theme. Latest PHP and mySQL. The same error is occurring every ten minutes or so, apparently because the page can't access the posts that are in reality still there. It is also slowing access in general. This happens with default theme running. [[Template forums/front/topics/topic is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]] I have granted admin rights and put the info in my client area. To be clear, I can appreciate the benefits of outsourcing support to the group wisdom here. But it can lead to a too many cooks situation instead of the intimate back and forth with one support specialist I was getting a decade ago. I would gladly, gladly pay more for some kind of premium support option. I am low maintenance but when I need help I really need it. Thanks again, and to anyone watching, Invision has been really good to me over the years. I'm just an old grumpy guy today - time catches up with us all. I will try and check back in as best I can later today but am seriously hoping it's something as simple as a corrupted template that I do not know how to isolate and reinstall.

As I said in my first message I have no plugins at all, tried the default theme, nothing worked. That’s why I am here. I’ve done all the things I was supposed to do and then came here for help. I have given the admin access in ACP. Not my first rodeo and repeatedly getting told my concerns and feedback as a paying customer are off base is getting a little old. I miss the old submit a ticket for support deal, sorry. But all I really want is help from an expert to get in and fix a problem I can’t fix.

I see there is a yearly subscription offer for the full suite versus the twice a year payment I am making for a couple modules. I do not need the extra modules at all, in fact had several and dropped them as extraneous to my main forum activity. I would be more than will to pay the small extra amount yearly however if it got me back a more direct line to support. The only reason I went with Invision subscription 13 years ago over open source alternatives was the promise of regular updates and more importantly, the ability to get support help when I have needed it. I have needed that support a handful of times over the last 13 years, worth every penny. So the cost is not the issue for me. As an older user though nothing I actually have done has ever changed. Invision changed their methods while I plugged along just paying twice a year, not really realizing it meant I could only get support via this forum. When it rains it pours of course. I am headed into surgery for a hernia in a couple hours and will be indisposed the rest of the day after that. So I am really hoping I hear something from Invision in the next couple hours. It is why I posted last night, so it would be here first thing in the morning. If I should be using a different means to get support, should upgrade my subscription, need to just pay extra to get help, whatever. I just need help, please. Thanks.

Yeah I did that before I was directed here by doing just that. It says my plan does not include email support but I’m not seeing what plan includes that. I used to be able to open a support request but no longer. No worries, I was not expecting Sunday support. But I am really hoping to get somebody that can figure this out eventually. Thanks.

I miss the old direct support days. Looks like I need somebody to get in and take a look at this. I loaded a backup, have removed all plugins, and as noted tried default template. still getting the error. Thanks.