Difference between revisions of "Issue:Minoredits=exclude broken"
From FollowTheScore
| (3 intermediate revisions by 2 users not shown) | |||
| Line 4: | Line 4: | ||
|Version = 1.8.1 | |Version = 1.8.1 | ||
|Description = minoredits=exclude broken | |Description = minoredits=exclude broken | ||
| − | |Status = | + | |Status = closed |
}} | }} | ||
| Line 49: | Line 49: | ||
The error is found and will be corrected in the next version. | The error is found and will be corrected in the next version. | ||
For the moment it may help if you add "addauthor=true" to your statement. [[User:Gero|Gero]] 12:29, 11 June 2009 (UTC) | For the moment it may help if you add "addauthor=true" to your statement. [[User:Gero|Gero]] 12:29, 11 June 2009 (UTC) | ||
| + | |||
| + | :Thank you for this information. "addauthor=true" works for me as a workaround. --[[User:Wfischer|Wfischer]] 08:16, 12 June 2009 (UTC) | ||
| + | |||
| + | ::With 1.8.3 it works for me. Thanks a lot! --[[User:Wfischer|Wfischer]] 07:08, 15 June 2009 (UTC) | ||
| + | |||
| + | I experienced the same problem (using DPL 1.8.9) and it is still persisting, no matter if I add "addauthor=true" or not. My code is | ||
| + | <pre> | ||
| + | <dpl> | ||
| + | category = Lehrer | ||
| + | namespace = main | ||
| + | ordermethod = lastedit | ||
| + | minoredits = exclude | ||
| + | order = descending | ||
| + | count = 1 | ||
| + | format = ,\n[[%TITLE%]] | ||
| + | </dpl> | ||
| + | </pre> | ||
| + | |||
| + | But the result ignores the most recent non-minor-edit and shows an earlier edit instead. Is there another bug about to be fixed? --[[User:Robb|Robb]] 01:36, 24 October 2010 (UTC) | ||
Latest revision as of 16:09, 24 October 2010
| Description: | minoredits=exclude broken |
| Extension / Version: | DPL / 1.8.1 |
| Type / Status: | Bug / closed |
Problem
It seems that with 1.8.1 (I suppose with 1.8.0, too) the function minoredits=exclude is broken. When I execute the following DPL statement with DPL 1.7.4 in our wiki http://www.thomas-krenn.com/de/wiki/ it works:
<DPL> debug=3 namespace= columns=1 ordermethod=lastedit minoredits=exclude order=descending count=5 shownamespace=yes nottitlematch=Hauptseite|Produkt-News:% addeditdate=true userdateformat=(d.m.Y) format=,\n* [[%PAGE%|%TITLE%]] %DATE%,, </DPL>
Because of debug=3 I get the following SQL statement with DPL 1.7.4:
DPL debug -- Query=
SELECT DISTINCT `page`.page_namespace as page_namespace,`page`.page_title as page_title, rev_user, rev_user_text, rev_timestamp FROM `revision` AS rev, `page` WHERE 1=1 AND `page`.page_namespace IN ('0') AND NOT (`page`.page_title LIKE 'Hauptseite' OR `page`.page_title LIKE 'Produkt-News:%') AND rev_minor_edit=0 AND `page`.page_is_redirect=0 AND `page`.page_id=rev.rev_page AND rev.rev_timestamp=( SELECT MAX(rev_aux.rev_timestamp) FROM `revision` AS rev_aux WHERE rev_aux.rev_page=rev.rev_page ) ORDER BY rev_timestamp DESC LIMIT 0, 5
With DPL 1.8.1 I get:
The DPL extension (version 1.8.1) produced a SQL statement which lead to a Database error.
The reason may be an internal error of DPL or an error which you made,
especially when using DPL options like titleregexp.
Query text is:
SELECT DISTINCT `page`.page_namespace as page_namespace,`page`.page_title as page_title,`page`.page_id as page_id, `page`.page_touched as page_touched FROM `page` WHERE 1=1 AND `page`.page_namespace IN ('0') AND NOT (`page`.page_title LIKE 'Hauptseite' OR `page`.page_title LIKE 'Produkt-News:%') AND rev_minor_edit=0 AND `page`.page_is_redirect=0 ORDER BY page_touched DESC LIMIT 0, 5
Error message is:
Unknown column 'rev_minor_edit' in 'where clause' (localhost)
--Wfischer 09:43, 10 June 2009 (UTC)
Reply
The error is found and will be corrected in the next version. For the moment it may help if you add "addauthor=true" to your statement. Gero 12:29, 11 June 2009 (UTC)
- Thank you for this information. "addauthor=true" works for me as a workaround. --Wfischer 08:16, 12 June 2009 (UTC)
- With 1.8.3 it works for me. Thanks a lot! --Wfischer 07:08, 15 June 2009 (UTC)
I experienced the same problem (using DPL 1.8.9) and it is still persisting, no matter if I add "addauthor=true" or not. My code is
<dpl> category = Lehrer namespace = main ordermethod = lastedit minoredits = exclude order = descending count = 1 format = ,\n[[%TITLE%]] </dpl>
But the result ignores the most recent non-minor-edit and shows an earlier edit instead. Is there another bug about to be fixed? --Robb 01:36, 24 October 2010 (UTC)
