Page MenuHomePhabricator

SMW_setup --delete fails for postgresql
Closed, ResolvedPublic

Description

Author: jwm

Description:
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.


Version: unspecified
Severity: major
OS: Windows ME
Platform: PC

Details

Reference
bz31153

Event Timeline

bzimport raised the priority of this task from to Needs Triage.
bzimport set Reference to bz31153.
bzimport added a subscriber: Unknown Object (MLST).
bzimport created this task.Sep 25 2011, 1:20 PM

Should be fixed in r111252 (you may or may not want to try it ;-).