Difference between revisions of "User talk:Cerw"

Revision as of 01:50, 8 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!

cerw

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