Last modified: 2013-07-25 07:05:41 UTC
发生数据库查询语法错误。 可能是由于软件自身的错误所引起。 最后一次数据库查询指令是： SELECT page_namespace,page_title FROM `page` WHERE page_namespace = '0' AND page_is_redirect = '0' ORDER BY c1.cl_timestamp DESC LIMIT 15 来自于函数“renderDynamicPageList”。 数据库返回错误“1054: Unknown column 'c1.cl_timestamp' in 'order clause' (localhost)”。 MediaWiki 1.20.3 (7759204) PHP 5.4.9 (fpm-fcgi) MySQL 5.5.28-debug with DynamicPageList (Wikimedia) REL1_20 https://gerrit.wikimedia.org/r/gitweb?p=mediawiki/extensions/intersection.git;a=snapshot;h=acbf96d2cae96586ff37ecba2c57f5d8e44a996f;sf=tgz
One error page example: http://wiki.moegirl.org/Help:DynamicPageList
Your database is broken... cl_timestamp was added as a field long ago. Does making an api request for list=categorymembers sorting by date work
Sorry I skimmed the error because it was not in english. Nevermind this is dpl bug What is dpl query that triggered this (what is page source)
<DynamicPageList> namespace=main ordermethod=popularity count=15 </DynamicPageList>
Ha, I find out than when I turn the $wgDisableCounters false it works fine. Once I set the $wgDisableCounters to true; it show sql error.
Hmm maybe that ordermethod is broken and just no one noticed since most wikis have counters disabled. Ill try and investigate more fully/fix the issue in the coming days
Well thank you!
Ok, so this turned out to be very embarrassing. Long ago I misspelled the word "category" in the code, which is what triggered this error. Submitted Gerrit change #56124 to fix this. (Note this won't appear in the official downloads until someone else reviews it. To fix the issue on your wiki, just change line 305 of DynamicPageList.php from $orderMethod = 'categoyadd'; // default if hitcounter disabled. to $orderMethod = 'categoryadd'; // default if hitcounter disabled. (note the "r" in category). Thank you for reporting this, and I apologize about my initial response in comment 2.
Trivial patch in Gerrit (Gerrit change #56124), still awaiting review...
Related URL: https://gerrit.wikimedia.org/r/62720 (Gerrit Change Ibc38d3a092e4cff3147f77f7cdb51ebc0ad54a0e)
Related URL: https://gerrit.wikimedia.org/r/62721 (Gerrit Change Ibc38d3a092e4cff3147f77f7cdb51ebc0ad54a0e)
zoglun: This is fixed now. If you wait about an hour and redownload DynamicPageList, the issue should go away
