ERROR: syntax error at or near "WITH" at character 2 (PostgreSQL)

stodge - July 2, 2009 - 15:05
Project:Multisite Manager
Version:6.x-1.0-alpha1
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:active
Description

I tried creating a new site and got the error:

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

I'm using PostrgreSQL.

#1

schuyler1d - July 2, 2009 - 19:08

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.

#2

stodge - July 2, 2009 - 19:12

:)

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

#3

stodge - October 28, 2009 - 12:14

Similar issue:

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

#4

schuyler1d - October 28, 2009 - 14:38

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?)

 
 

Drupal is a registered trademark of Dries Buytaert.