Page MenuHomePhabricator

latest installment breaks "firstedit" sorts on MW 1.7.1
Closed, ResolvedPublic

Description

Author: morten

Description:
After installing DynamicPageList2 0.7.8, firstedit sorts were broken. Previous
installment of DPL was fully functional.


Version: unspecified
Severity: normal
URL: http://www.crewscut.com/index.php?title=Crewscut.com:Testomr%C3%A5de

Details

Reference
bz7867

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 9:26 PM
bzimport set Reference to bz7867.
bzimport added a subscriber: Unknown Object (MLST).

cyril.dangerville wrote:

The implementation of the firstedit (and lastedit) sorts have changed to fix bug

But I need more information from your side (since it doesn't appear to break on
mine as far as I can test). Please give a specific example (one that I could
easily reproduce, if possible) of DPL code (with firstedit sort) that fails,
using 'debug=3'; and copy-paste here the debugging message(s) generated by the
extension if any. If not, please tell whether you get a SQL error. Thanks.

morten wrote:

<DPL>
namespace=Blog
category=Artikler
ordermethod=firstedit
count=10
order=descending
mode=inline
debug=3
</DPL>

Gives this SQL error : (debug doesn't seem to make any difference)

1064: You have an error in your SQL syntax. Check the manual that corresponds to your
MySQL server version for the right syntax to use near 'SELECT MIN
(rev_aux.rev_timestamp) FROM revision AS rev_aux WH (localhost)"

See http://www.crewscut.com/index.php?title=Crewscut.com:Testomr%C3%A5de.

cyril.dangerville wrote:

Looking at your Special:Version page, I saw you have MySQL 4.0 running, which
made me realize that nested queries of the form SELECT...SELECT... like the ones
used for firstedit and lastedit sorts are not supported before MySQL 4.1. See
http://meta.wikimedia.org/wiki/DynamicPageList2#System_requirements and
http://dev.mysql.com/doc/refman/4.1/en/rewriting-subqueries.html. I think this
is the source of your problem and I'm sorry for that.
One solution would be to revert to 0.7.7 but tolerate bug 7773. A better
solution would be to upgrade to MySQL 4.1. It seems you are running Debian Sarge
and the package mysql-server-4.1 happens to be available for this distribution.
Hope it helps.

morten wrote:

Unfortunately I'm in a hosted environment, so I'll have to wait until they install
MySQL 4.1. I installed the latest installment of DPL because I wanted the new counter
functionality - but losing firstedit/lastedit may be too steep a price to pay. Seems
I can't have both worlds, at least for now.

Thanks for your help - and keep up the good work! :-)