Then I upgraded it and forgot to make same permissions changes. A year later I looked at the site and it was totally infested by spammers.
I cleaned up quite a few pages, but there are some obscure ones that I may have missed.
Is there some SQL command or some such to find the spammed pages?
This all depends on what was added. The easiest starting point would probably be the number of external links on a page, substracting the ones linking to algebra.com
example query: select page_namespace, page_title, count(el_from) from page right join externallinks on page_id=el_from where el_index not like 'http://com.algebra.%' group by el_from order by count(el_from) desc;
Might be interesting to scan for bloated link pages, too :)
--valhallasw