Last modified: 2010-05-15 15:41:17 UTC
The following error pops-up when trying to install a wiki on a server with a postgresql db and 'iperform-wiki' as db username. --- Setting the search path for user iperform-wiki ... Warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "-" at character 20 in /wiki/includes/DatabasePostgres.php on line 138 FAILED. --- Changing the sql statement: /wiki/includes/DatabasePostgres.php line 138: $SQL = "ALTER USER $user SET search_path = $path"; $result = pg_query($this->mConn, $SQL); to: $SQL = "ALTER USER \"$user\" SET search_path = $path"; $result = pg_query($this->mConn, $SQL); Seems to fix the problem (using single quotes seems to cause problems also).
Fixed in svn, thanks for the report.