https://bugzilla.wikimedia.org/show_bug.cgi?id=61751
Bug ID: 61751 Summary: SemanticDrillDown generated sql queries do not work with Postgres Product: MediaWiki extensions Version: master Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: Unprioritized Component: SemanticDrilldown Assignee: yaro...@gmail.com Reporter: vlaudi...@imolinfo.it Web browser: --- Mobile Platform: --- OS: Centos 6.5 MediaWiki: 1.22.2 SemanticBundle: 20140103 (Semantic MediaWiki v.1.8.0.5 && Semantic DrillDown v1.3) PostgreSQL: 9.2.6 By using the above configuration, I faced two problems: 1) When I try to open a page that uses the SemanticDrillDown extension I get the following error: Query: SELECT COUNT(DISTINCT sdv.id) FROM semantic_drilldown_values sdv LEFT OUTER JOIN semantic_drilldown_filter_values sdfv ON sdv.id = sdfv.id WHERE ((! (sdfv.value IS NULL OR sdfv.value = '' OR (sdfv.value = '0') OR (sdfv.value = '1')))) Funzione: DatabaseBase::query Errore: 22P02 ERROR: invalid input syntax for type boolean: "" LINE 4: WHERE ((! (sdfv.value IS NULL OR sdfv.value = '' OR (sdfv.... ^ 2) The escape character used by the SD extension within the sql is not allowed in Postgres. The SD extension checks the occurrence of special characters like the quote (') before performing any sql query and it replaces the occurrence with the escaped one. For instance it replaces the quote occurrence with the slash-quote (\') sequence. When the query is performed by the SD extension, I get is the following error message: Query: CREATE TEMPORARY TABLE semantic_drilldown_filter_values AS SELECT s_id AS id, o_ids.smw_title AS value FROM "smw_di_wikipage" JOIN "smw_object_ids" p_ids ON "smw_di_wikipage".p_id = p_ids.smw_id JOIN "smw_object_ids" o_ids ON "smw_di_wikipage".o_id = o_ids.smw_id WHERE p_ids.smw_title = 'Simple\'title' Funzione: DatabaseBase::query Errore: 42601 ERROR: syntax error at or near "applicazione" LINE 6: WHERE p_ids.smw_title = 'Simple\'title' ^ -- You are receiving this mail because: You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l