We'd like to run a clean up script from /scripts/clean_up_users.php to take out some old users data. Please run the script and paste the output here. If QA passes, we're considering cronning this yearly.
[root@mrapp-stage02 support-stage.mozilla.com]# php scripts/clean_up_users.php Getting list of users to remove... PHP Fatal error: Call to undefined function bcsub() in /data/www/support-stage.mozilla.com/scripts/clean_up_users.php on line 34 Fatal error: Call to undefined function bcsub() in /data/www/support-stage.mozilla.com/scripts/clean_up_users.php on line 34
Assignee: server-ops → justdave
Created attachment 429558 [details] [diff] [review] replace bcsub with round This replaces bcsub() with round(), which is more common. My bad, sorry.
Attachment #429558 - Flags: review?(laura)
r63490 justdave: after SVN picks up the changes, please try again. Thanks!
Just so people know I'm working on it... it didn't immediately crash this time, but it apparently takes a Really Long Time to run. It's been going for a while, I'll paste it in here once it finishes.
and, it finished not long after I finally posted that. [root@mrapp-stage02 support-stage.mozilla.com]# php scripts/clean_up_users.php Getting list of users to remove... done in 1.56 seconds. Ignoring users from tiki_actionlog... done in 0.71 seconds. Ignoring users from tiki_user_postings... done in 0.47 seconds. Ignoring users from tiki_comments... done in 2.28 seconds. Deleting from users_usergroups... done in 184.44 seconds. Deleting from tiki_user_preferences... done in 978.94 seconds. Deleting from users_users... done in 303.32 seconds. Deleted 105569 users and a total of 3455232 rows. Script executed in 1471.72 seconds.
Status: NEW → RESOLVED
Last Resolved: 8 years ago
Resolution: --- → FIXED
Product: mozilla.org → mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.