Posted by stodge on July 2, 2009 at 3:05pm
3 followers
Jump to:
| Project: | Multisite Manager |
| Version: | 6.x-1.0-alpha1 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
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
#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?)
#5
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.