Cannot load user list - Getting database error whilst doing so.

[Pupswoof117]

I couldn't find a thread with my exact error so here's what I'm running into:

When I try to load the user list on Admin dash on my site it spits an error saying:

Code Select Expand

The database value you're trying to insert does not exist: sortnot entirely sure what's going on, not entirely sure when it started as I rarely have to use the members page outside of approving members.
I did change some php files solely for following instructions on installing plugins manually but I have tried to revert based on log file instructions to no avail. Is there anything that can be done?

[Pupswoof117]

So I've gotten a tad closer to what I believe is part of the problem; I added back some of the code and got a different error.

Code Select Expand

Unknown column 'mem.is_spammer' in 'field list'
File: /var/www/pupswoof117.com/Sources/Subs-Members.php
Line: 1234
I'm hitting a wall at this, it is hosted on a Linux backend.

[Pupswoof117]

Got rid of error 2 and am back to error 1. The ironic thing is I think I know what's wrong with my smf instance, but I want to be sure before I go messing with PHP My Admin more.

[Kindred]

Mods installed?
Smf version?

[Pupswoof117]

Full list of enabled and installed mods:

Code Select Expand

Block Proxy VPN On Registration,
Label for banned members
Default_Membergroup
Tabs In Posts
SimplePortal
Avatar for banned members
ROAM - Re-Organized Admin Menu
Stop Spammer
SMF version is 2.0.19

[Pupswoof117]

Was only after Stop Spammer was enabled that the issue cropped up, not sure what point of which. I believe it's related to some member related table but I don't want to touch them again until I know for sure.

[Pupswoof117]

For quick reference; using NGiNX and MariaDB on hostside. (LEMP + Debian stack)

[Pupswoof117]

I'm genuinely curious where sort is mainly defined, because it's not in any plugin code. I looked at it. I might have to play with PMA/MariaDB with the answer.

[Pupswoof117]

I fixed it- I had to reload the original file that came stock and re-do the changes. It was the ManageMembers.php file. it works once more! Marking as solved!