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
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.
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)"
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://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! :-)