https://bugzilla.wikimedia.org/show_bug.cgi?id=31153

       Web browser: ---
             Bug #: 31153
           Summary: SMW_setup --delete fails for postgresql
           Product: MediaWiki extensions
           Version: any
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: major
          Priority: Unprioritized
         Component: Semantic MediaWiki
        AssignedTo: [email protected]
        ReportedBy: [email protected]
                CC: [email protected], [email protected]
    Classification: Unclassified


This happens:

Deleting all database content and tables generated by SMW ...

Warning: pg_query(): Query failed: ERROR:  syntax error at or near
"TABLEsmw_ids"
LINE 1: DROP /* SMWSQLStore2::drop 127.0.0.1 */ TABLEsmw_ids
                                                ^ in
/home/cffc/webapps/htdocs/w/includes/db/DatabasePostgres.php on line 237
A database query syntax error has occurred.
The last attempted database query was:
"DROP TABLEsmw_ids"
from within function "SMWSQLStore2::drop".
Database returned error "1: ERROR:  syntax error at or near
"TABLEsmw_ids"
LINE 1: DROP /* SMWSQLStore2::drop 127.0.0.1 */ TABLEsmw_ids
                                                ^"
I dropped a space in front of 'DROP TABLE' in the drop() method of
include/storage/SMW_SQLStore2.php on 1.6.1, and that fixed it.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to