Wiki

From Athenaeum
Jump to: navigation, search

Maintenance

  • Spam cleanup using direct database access
These instructions came from this forum post
Find the last legitimately created user and substitute that number for 20 below
DELETE FROM user WHERE user_id > 20;
DELETE FROM user_groups WHERE ug_user > 20;
DELETE FROM user_properties WHERE up_user > 20;
DELETE FROM user_newtalk WHERE user_id > 20;
DELETE FROM revision WHERE rev_user > 20;
UPDATE page SET page_latest = 0;
On the servers file system in the maintenance folder run attachLatest.php --fix
DELETE FROM page WHERE page_latest = 0;
On the filesystem run rebuildall.php
On the filesystem run purgeOldText.php