Last modified: 2006-11-11 20:52:16 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T9867, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 7867 - latest installment breaks "firstedit" sorts on MW 1.7.1
latest installment breaks "firstedit" sorts on MW 1.7.1
Status: RESOLVED FIXED
Product: MediaWiki extensions
Classification: Unclassified
DynamicPageList2 (Other open bugs)
unspecified
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
http://www.crewscut.com/index.php?tit...
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-11-11 00:59 UTC by Morten Blaabjerg
Modified: 2006-11-11 20:52 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Morten Blaabjerg 2006-11-11 00:59:26 UTC
After installing DynamicPageList2 0.7.8, firstedit sorts were broken. Previous 
installment of DPL was fully functional.
Comment 1 Cyril Dangerville 2006-11-11 01:27:54 UTC
The implementation of the firstedit (and lastedit) sorts have changed to fix bug
7773. 
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. 
Comment 2 Morten Blaabjerg 2006-11-11 08:58:03 UTC
<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. 
Comment 3 Cyril Dangerville 2006-11-11 17:17:55 UTC
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.
Comment 4 Morten Blaabjerg 2006-11-11 20:44:48 UTC
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! :-)

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links