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
       Web browser: ---
   Mobile Platform: ---

OS: Centos 6.5
MediaWiki: 1.22.2
SemanticBundle: 20140103 (Semantic MediaWiki v. && Semantic DrillDown
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:   

    SELECT COUNT(DISTINCT FROM semantic_drilldown_values sdv LEFT OUTER
JOIN semantic_drilldown_filter_values sdfv ON = WHERE ((!
(sdfv.value IS NULL OR sdfv.value = '' OR (sdfv.value = '0') OR (sdfv.value =
    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:

    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

Reply via email to