Difference between revisions of "DPL talk:Manual - DPL Bug Reporting and Feature Requests"
Line 26: | Line 26: | ||
so the user will see a list of articles, every article with it's contents. | so the user will see a list of articles, every article with it's contents. | ||
+ | |||
+ | ==Problems with SQL errors== | ||
+ | Hi all, I use mediawiki 1.13.1. I have got egual error as [[User:Dmb|Dmb]]. I'm using | ||
+ | <pre> | ||
+ | {{#dpl: | ||
+ | |category={{{category}}} | ||
+ | |resultsheader=%PAGES% | ||
+ | |noresultsheader=0 | ||
+ | |mode=userformat | ||
+ | }} | ||
+ | </pre> | ||
+ | into [http://gbrowse.org/wiki/index.php/Template:Counts gbrowse.org] it is works. when I create egual template into [http://genomics.cribi.unipd.it/wiki/index.php/Template:PeopleList other wiki] it is not works and I have got this error: | ||
+ | |||
+ | <pre>The DPL extension (version 1.7.4) produced a SQL statement which lead to a Database error. | ||
+ | The reason may be an internal error of DPL or an error which you made, | ||
+ | especially when using DPL options like titleregexp. | ||
+ | Query text is: | ||
+ | SELECT DISTINCT `page`.page_namespace as page_namespace,`page`.page_title as page_title, REPLACE(REPLACE(CONCAT( IF(`page`.page_namespace=0, , CONCAT(CASE `page`.page_namespace WHEN 1 THEN 'Talk' WHEN 2 THEN 'User' WHEN 3 THEN 'User_talk' WHEN 4 THEN 'CRIBI_Genomics' WHEN 5 THEN 'CRIBI_Genomics_talk' WHEN 6 THEN 'Image' WHEN 7 THEN 'Image_talk' WHEN 8 THEN 'MediaWiki' WHEN 9 THEN 'MediaWiki_talk' WHEN 10 THEN 'Template' WHEN 11 THEN 'Template_talk' WHEN 12 THEN 'Help' WHEN 13 THEN 'Help_talk' WHEN 14 THEN 'Category' WHEN 15 THEN 'Category_talk' END, ':')), `page`.page_title), '_', ' '),'♣','⣣') as sortkey FROM `page` INNER JOIN `categorylinks` AS cl0 ON `page`.page_id=cl0.cl_from AND (cl0.cl_to='Grape_Genome_Team') WHERE 1=1 AND `page`.page_is_redirect=0 ORDER BY sortkey ASC LIMIT 0, 500 | ||
+ | |||
+ | Error message is: | ||
+ | Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_bin,IMPLICIT) for operation 'concat' (localhost) </pre> | ||
+ | |||
+ | If I log into mysql shell, this query is works.. so I don't understand where it is the problem.. | ||
+ | |||
+ | Thanks! -- [[User:Bilardi|Bilardi]] Sun Jan 18 12:13:23 UTC 2009 |
Revision as of 14:14, 18 January 2009
What does TOC "pragma" mean?
I am trying to display the TOC of articles based on the article names, without luck. TOC won't show in the included chapter.
All I need is a dynamic TOC and a couple of pics contained in the article.
Reply
MW creates its TOCs based on the actual content of an article. So the TOC of a page containing DPL results will only show a TOC of the transcluded content (provided you care for the "== ... ==" syntax in the DPL output).
22:51, 16 January 2009 (UTC)
I'd like to make a list of articles with their Table Of Contents under them. Like:
Articles in the country category
- Uganda
- TOC
- (like population,
economy etc)
- Bengal
- TOC
- (like population
- economy etc)
so the user will see a list of articles, every article with it's contents.
Problems with SQL errors
Hi all, I use mediawiki 1.13.1. I have got egual error as Dmb. I'm using
{{#dpl: |category={{{category}}} |resultsheader=%PAGES% |noresultsheader=0 |mode=userformat }}
into gbrowse.org it is works. when I create egual template into other wiki it is not works and I have got this error:
The DPL extension (version 1.7.4) produced a SQL statement which lead to a Database error. The reason may be an internal error of DPL or an error which you made, especially when using DPL options like titleregexp. Query text is: SELECT DISTINCT `page`.page_namespace as page_namespace,`page`.page_title as page_title, REPLACE(REPLACE(CONCAT( IF(`page`.page_namespace=0, , CONCAT(CASE `page`.page_namespace WHEN 1 THEN 'Talk' WHEN 2 THEN 'User' WHEN 3 THEN 'User_talk' WHEN 4 THEN 'CRIBI_Genomics' WHEN 5 THEN 'CRIBI_Genomics_talk' WHEN 6 THEN 'Image' WHEN 7 THEN 'Image_talk' WHEN 8 THEN 'MediaWiki' WHEN 9 THEN 'MediaWiki_talk' WHEN 10 THEN 'Template' WHEN 11 THEN 'Template_talk' WHEN 12 THEN 'Help' WHEN 13 THEN 'Help_talk' WHEN 14 THEN 'Category' WHEN 15 THEN 'Category_talk' END, ':')), `page`.page_title), '_', ' '),'♣','⣣') as sortkey FROM `page` INNER JOIN `categorylinks` AS cl0 ON `page`.page_id=cl0.cl_from AND (cl0.cl_to='Grape_Genome_Team') WHERE 1=1 AND `page`.page_is_redirect=0 ORDER BY sortkey ASC LIMIT 0, 500 Error message is: Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_bin,IMPLICIT) for operation 'concat' (localhost)
If I log into mysql shell, this query is works.. so I don't understand where it is the problem..
Thanks! -- Bilardi Sun Jan 18 12:13:23 UTC 2009