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