Issue:AddContribution missing prefix regression
From FollowTheScore
| Description: | An old bug has returned |
| Extension / Version: | DPL / 1.8.9 |
| Type / Status: | Bug / open |
Problem
The bug Issue:AddContribution missing prefix has returned in DPL 1.8.9.
{{#dpl:
|namespace={{NAMESPACE}}
|titlematch={{PAGENAME}}
|skipthispage=no
|addcontribution=true
}}
On our system this produces:
The DPL extension (version 1.8.9) 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 `vpw_page`.page_namespace as page_namespace,`vpw_page`.page_title as page_title,`vpw_page`.page_id as page_id, SUM( ABS( rc.rc_new_len - rc.rc_old_len ) ) AS contribution, rc.rc_user_text as contributor FROM `vpw_recentchanges` AS rc, `vpw_page` WHERE 1=1 AND page.page_id=rc.rc_cur_id AND `vpw_page`.page_namespace IN ('202') AND (`vpw_page`.page_title LIKE 'Lasteditor') AND `vpw_page`.page_is_redirect=0 GROUP BY rc.rc_cur_id ORDER BY page_title ASC LIMIT 0, 500
Error message is:
Unknown column 'page.page_id' in 'where clause' (localhost)
However, on http://followthescore.org which is running 1.9.0, the bug doesn't seem to happen. Has it been fixed in 1.9.0?
