Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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
Comment #1
schuyler1d CreditAttribution: schuyler1d commenteda 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.
Comment #2
stodge CreditAttribution: stodge commented:)
No, I think the username is just "admin".
Comment #3
stodge CreditAttribution: stodge commentedSimilar issue:
ERROR: syntax error at or near "WITH PASSWORD" LINE 1: WITH PASSWORD '******' ^
Comment #4
schuyler1d CreditAttribution: schuyler1d commentedis it possible you need to give your postgres user more privileges? (i.e. can you make the drupal user a 'superuser' at least temporarily?)
Comment #5
pasadenaguy CreditAttribution: pasadenaguy commentedNot 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.