Difference between revisions of "User talk:Cerw"
(One intermediate revision by the same user not shown) | |||
Line 47: | Line 47: | ||
then i get empty result, not sure what the empty space shoudl do , i am using 5.0.32-Debian_7etch1-log | then i get empty result, not sure what the empty space shoudl do , i am using 5.0.32-Debian_7etch1-log | ||
Thanks | Thanks | ||
+ | :UPDATE - i fixed it , i found out that Categories did not have Pages, their were just plain categories, after creating Pages from them, it started to work. | ||
+ | thanks | ||
+ | ---- | ||
+ | Hi there again! | ||
+ | I have question about genereating reports, including parents etc.. I have big wiki with Tree structure pages, | ||
+ | A | ||
+ | A1 | ||
+ | A1.1.1 - text | ||
+ | |||
+ | I am not sure how the MediaWiki deals with releations, but i need to be able to print report like this: | ||
+ | [[Image:Picture 2.png]] | ||
+ | |||
+ | :Responsibilites are categories, which is the easy part, but I am not sure if I can use DPL to do the whole three, of i i have to write custom extension for this? | ||
+ | thanks | ||
+ | Author: [[User:Cerw|Cerw]] 04:51, 14 November 2007 (CET) |
Latest revision as of 04:51, 14 November 2007
Help with DPL -GUI
Hi there I install Winter and SimpleForm extension and Call extenstion but still getting this:
also I can not list Category from DPL, any ideas why?
Can you execute a normal DPL query (apart from GUI and Call extension)? What does the Special:Call page show?
- Gero 08:57, 2 November 2007 (CET)
I can run normal DPL query but can not list Categories it self. This code give me error
{{#dpl: namespace=Category | format=,\n*%TITLE%,, }} %DPL-1.5.0-WARNING: No results!
Set debug=3 to see the SQL statement which is fired by DPL against your database. Then copy/paste that statement and use a SQL tool (mysqladmin e.g.) to find out why the result set is empty. You can simplify the statement to find the problem cause.
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 'Dpldemo' WHEN 5 THEN 'Dpldemo_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' WHEN 100 THEN 'Type' WHEN 101 THEN 'Type_talk' WHEN 102 THEN 'Test' WHEN 103 THEN 'Test_talk' WHEN 104 THEN 'DPL' WHEN 105 THEN 'DPL_talk' WHEN 106 THEN 'Wgraph' WHEN 107 THEN 'Wgraph_talk' WHEN 108 THEN 'Issue' WHEN 109 THEN 'Issue_talk' END, ':')), `page`.page_title), '_', ' '),'♣','⣣') as sortkey FROM `page` WHERE 1=1 AND `page`.page_namespace IN ('14') AND `page`.page_is_redirect=0 ORDER BY sortkey ASC LIMIT 0, 500
Simplified
SELECT DISTINCT `page`.page_namespace as page_namespace, `page`.page_title as page_title FROM `page` WHERE 1=1 AND `page`.page_namespace IN ('14') AND `page`.page_is_redirect=0 ORDER BY sortkey ASC LIMIT 0, 500
Maybe you should look for a more recent version of MySQL ...
- Gero 09:43, 7 November 2007 (CET)
--- Hi there thanks for reply, I did debug and copy/paste to SQL query,
SELECT DISTINCT `wiki_page`.page_namespace as page_namespace, `wiki_page`.page_title as page_title, REPLACE(REPLACE(CONCAT( IF(`wiki_page`.page_namespace=0, , CONCAT(CASE `wiki_page`.page_namespace WHEN 1 THEN 'Talk' WHEN 2 THEN 'User' WHEN 3 THEN 'User_talk' WHEN 4 THEN 'SLSA' WHEN 5 THEN 'SLSA_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, ':')), `wiki_page`.page_title), '_', ' '),'♣','⣣') as sortkey FROM `wiki_page` WHERE 1=1 AND `wiki_page`.page_namespace IN ('14') AND `wiki_page`.page_is_redirect=0 ORDER BY sortkey ASC LIMIT 500
- 1st error is
#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 ' CONCAT(CASE `wiki_page`.page_namespace WHEN 1 THEN 'Talk' WHEN 2 THEN 'User' WH' at line 1
So i fixed that manulay adding to =0,, CONCAT... then i get empty result, not sure what the empty space shoudl do , i am using 5.0.32-Debian_7etch1-log Thanks
- UPDATE - i fixed it , i found out that Categories did not have Pages, their were just plain categories, after creating Pages from them, it started to work.
thanks
Hi there again! I have question about genereating reports, including parents etc.. I have big wiki with Tree structure pages,
A A1 A1.1.1 - text
I am not sure how the MediaWiki deals with releations, but i need to be able to print report like this:
- Responsibilites are categories, which is the easy part, but I am not sure if I can use DPL to do the whole three, of i i have to write custom extension for this?
thanks Author: Cerw 04:51, 14 November 2007 (CET)