I tried creating a new site and got the error:

ERROR: syntax error at or near "WITH" at character 2

I'm using PostrgreSQL.

Comments

schuyler1d’s picture

schuyler1d commented

a postgres user! finally:-)
does your db username (set in multisite_manager admin settings) have any special chars?
i don't see anything wrong with the syntax in the code, but am not setup atm to test the code directly.

stodge’s picture

stodge commented

:)

No, I think the username is just "admin".

stodge’s picture

stodge commented

Similar issue:

ERROR: syntax error at or near "WITH PASSWORD" LINE 1: WITH PASSWORD '******' ^

schuyler1d’s picture

schuyler1d commented

is it possible you need to give your postgres user more privileges? (i.e. can you make the drupal user a 'superuser' at least temporarily?)

pasadenaguy’s picture

pasadenaguy commented

Not sure if this is related.... but query syntax for PostgreSQL seem to be wrong as everytime I'm installing a module I see:

# warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "s" at character 22 in ********************drupal.cybird.us/html/includes/database.pgsql.inc on line 139.
# user warning: query: UPDATE cybird_system s SET s.weight = 81 WHERE s.name = 'ajax' AND s.type = 'module' in *************/drupal.cybird.us/html/modules/ajax/ajax.install on line 26.

my setup: PostgreSQL 7.4.23, PHP 5.2.6, Apache 2.0.54, pdo_pgsql 1.0.2

I'd appreciate any help

EDIT: Ok.... So taking a deeper look, I figured it was the queries in the ajax.install AND ajax_ui.install of the Ajax module.