By patis on

Hello,

I installed one site on a PostgreSQL database using some table prefix. The installation went OK and the site is up and running. Now I'm trying to install a second site, on an entirely different directory, using the same database but, of course, using a different table prefix. However I get the following error just after I enter the database info:

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near ")" at character 46 in /home/test/public_html/drupal/includes/database.pgsql.inc on line 138.
    * user warning: ERROR: syntax error at or near ")" at character 46 query: SELECT * FROM pnetmenu_router WHERE path IN () ORDER BY fit DESC LIMIT 1 OFFSET 0 in /home/test/public_html/drupal/includes/menu.inc on line 315.
    * warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near ")" at character 46 in /home/test/public_html/drupal/includes/database.pgsql.inc on line 138.
    * user warning: ERROR: syntax error at or near ")" at character 46 query: SELECT * FROM pnetmenu_router WHERE path IN () ORDER BY fit DESC LIMIT 1 OFFSET 0 in /home/test/public_html/drupal/includes/menu.inc on line 315.

Any ideas?

Thanks.

⋅ Categories: Drupal 6.x

Comments

lil-1’s picture

lil-1 commented

Hello,
I am not sure about PostgreSQL, but it seems to be the common problem with syntax error near menu router.
I was trying to do the same with Msql and fried my brain already having almost the same pink error box.
Check here, may be this discussion will help at least to get the idea of the trouble
#229825: backport "$_COOKIE['has_js'] must die" patch to 7.x
though I gave up and now trying to make the single sigh-on multi sites with CAS http://drupal.org/project/cas