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 |
Jump to:
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
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
:)
No, I think the username is just "admin".
#3
Similar issue:
ERROR: syntax error at or near "WITH PASSWORD" LINE 1: WITH PASSWORD '******' ^
#4
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?)