https://www.mediawiki.org/wiki/Special:Code/MediaWiki/113380
Revision: 113380
Author: catrope
Date: 2012-03-08 18:51:34 +0000 (Thu, 08 Mar 2012)
Log Message:
-----------
Fix SQL syntax error
Modified Paths:
--------------
trunk/extensions/ArticleFeedbackv5/sql/filter_count.sql
Modified: trunk/extensions/ArticleFeedbackv5/sql/filter_count.sql
===================================================================
--- trunk/extensions/ArticleFeedbackv5/sql/filter_count.sql 2012-03-08
18:50:09 UTC (rev 113379)
+++ trunk/extensions/ArticleFeedbackv5/sql/filter_count.sql 2012-03-08
18:51:34 UTC (rev 113380)
@@ -11,7 +11,7 @@
-- oversighted
INSERT INTO aft_article_filter_count(afc_page_id, afc_filter_name,
afc_filter_count) SELECT af_page_id, 'deleted', COUNT(*) FROM
aft_article_feedback WHERE af_bucket_id = 1 AND af_is_deleted IS TRUE GROUP BY
af_page_id;
---unoversighted
+-- unoversighted
INSERT INTO aft_article_filter_count(afc_page_id, afc_filter_name,
afc_filter_count) SELECT af_page_id, 'undeleted', COUNT(*) FROM
aft_article_feedback WHERE af_bucket_id = 1 AND af_is_deleted IS FALSE AND
af_is_undeleted IS TRUE GROUP BY af_page_id;
-- visible (all not hidden)
@@ -32,4 +32,4 @@
-- helpful and unhelpful counts
INSERT INTO aft_article_filter_count(afc_page_id, afc_filter_name,
afc_filter_count) SELECT af_page_id, 'helpful', COUNT(*) FROM
aft_article_feedback WHERE af_bucket_id = 1 AND CONVERT(af_helpful_count,
SIGNED) - CONVERT(af_unhelpful_count, SIGNED) > 0 AND af_is_hidden IS FALSE
AND af_is_deleted IS FALSE GROUP BY af_page_id;
-INSERT INTO aft_article_filter_count(afc_page_id, afc_filter_name,
afc_filter_count) SELECT af_page_id, 'unhelpful', COUNT(*) FROM
aft_article_feedback WHERE af_bucket_id = 1 AND CONVERT(af_helpful_count,
SIGNED) - CONVERT(af_unhelpful_count, SIGNED) < 0 AND af_is_hidden IS FALSE
AND af_is_deleted IS FALSE GROUP BY af_page_id;
\ No newline at end of file
+INSERT INTO aft_article_filter_count(afc_page_id, afc_filter_name,
afc_filter_count) SELECT af_page_id, 'unhelpful', COUNT(*) FROM
aft_article_feedback WHERE af_bucket_id = 1 AND CONVERT(af_helpful_count,
SIGNED) - CONVERT(af_unhelpful_count, SIGNED) < 0 AND af_is_hidden IS FALSE
AND af_is_deleted IS FALSE GROUP BY af_page_id;
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
