Difference between revisions of "Test addcategories"

From FollowTheScore
Jump to: navigation, search
(show articles and their categories, grouped by categories)
(show articles and their categories, grouped by categories)
Line 16: Line 16:
  
 
=== show articles and their categories, grouped by categories ===
 
=== show articles and their categories, grouped by categories ===
 +
 +
The following report has a bug which depends on the version of MySQl you use.
  
 
Note: Again, we restrict the search to articles containing "ma" somewhere in the name
 
Note: Again, we restrict the search to articles containing "ma" somewhere in the name
Line 29: Line 31:
 
</nowiki></pre>
 
</nowiki></pre>
  
For some strange reason the result is too large: the identical SQL statement works correctly on MySQL 5.0
+
For some strange reason in MySQL 4.x (running on this server) the result is too large: the identical SQL statement works correctly on MySQL 5.0
  
 
<dpl>
 
<dpl>

Revision as of 13:31, 15 February 2007

show articles and their categories

Note: We search all articles containing "m" somewhere in the name to avoid a huge result list.

<dpl>
  addcategories=true
  titlematch=%m%
</dpl>

show articles and their categories, grouped by categories

The following report has a bug which depends on the version of MySQl you use.

Note: Again, we restrict the search to articles containing "ma" somewhere in the name

<dpl>
  namespace=
  headingmode=H4
  ordermethod=category,sortkey
  addcategories=true
  titlematch=%ma%
</dpl>

For some strange reason in MySQL 4.x (running on this server) the result is too large: the identical SQL statement works correctly on MySQL 5.0

Extension:DynamicPageList (DPL), version 3.2.1: Warning: Skipping bad option 'H4' for parameter 'headingmode'.