Last modified: 2006-11-11 20:52:16 UTC
After installing DynamicPageList2 0.7.8, firstedit sorts were broken. Previous installment of DPL was fully functional.
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.
<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.
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.
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! :-)