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
