From 6c23ab5b6f534e088a1be88582f57cdbfa00cbc3 Mon Sep 17 00:00:00 2001 From: Brion Vibber Date: Fri, 5 Dec 2003 05:07:40 +0000 Subject: [PATCH] Script to rebuild the article count --- maintenance/recount.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 maintenance/recount.sql diff --git a/maintenance/recount.sql b/maintenance/recount.sql new file mode 100644 index 0000000000..93e1024b4f --- /dev/null +++ b/maintenance/recount.sql @@ -0,0 +1,8 @@ +-- +-- Recalculate the article count +-- + +SELECT @foo:=COUNT(*) FROM cur + WHERE cur_namespace=0 AND cur_is_redirect=0 AND cur_text like '%[[%'; +UPDATE site_stats SET ss_good_articles=@foo; + -- 2.20.1