Honestly, I see basically no solutions in this thread whatsoever.
Because we all fall into the same trap. We pick our pet peeve, sometimes it's something we know something about, sometimes not so much. And we try to fix complex problems by addressing our puny little pet peeve.
So, we think the problem is about having fewer guns, or having more guns, or mental health, or freedom, or incompetence in school administration, etc. etc. etc.
The problem is that it's a complex problem, and we will never make any progress by addressing only one facet. The only real solution is a comprehensive, layered, multi-faceted approach.
As a nation, we assume that in order for an attack to take place, there has to be a weapon, and if we remove the weapons, we will remove the problem.
But the basic assumption is wrong.
A weapon is not necessary, only a person intent on carrying out an act. We should have learned this on Sept 11- they brought down the buildings with box cutters. They could have done it with Bic pens, shoelaces, or chicken bones. Since then we have spent billions of dollars trying to improve airport security by finding weapons, and virtually zero on addressing the human factor.
Until we are ready to address the human factor, we will NEVER make any progress. We will only continue to argue and spend money ineffectively, while pushing political agendas.
Ben Gurion airport in Tel Aviv is one of the most dangerous places in the world, but has not had a significant terrorist event in over 30 years. I've been there. It's astounding, and VERY evident how different their overall approach is than ours.
This is a pretty good article describing the differences in their approach:
Ben Gurion Airport security
The exact same philosophies could be applied to schools. But not if we'd rather argue about our agendas.