SQL Syntax Errors

Issue Summary

Hi,

I have a multi-site installation using xampp on windows, I have 2 sites up sharing the same code base

1. http://testsite1
2. http://site2

I have them installed on 2 different Postgres databases because for some reason I just could not install them on the same database (because I ust postgres instead of mysql??)

I'm have a Acquia Drupal 1.2 (Drupal Core 6.8) installed..

anyways here are the errors I'm getting:

right after installation:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "(" LINE 2: site_id serial CHECK (site_id >= 0)(11), ^ in D:\Workplace\xampplite\htdocs\drupal-base\includes\database.pgsql.inc on line 139.
* user warning: query: CREATE TABLE multisite_drupal_search_sites ( site_id serial CHECK (site_id >= 0)(11), table_prefix varchar(225) NOT NULL, site_url varchar(225) NOT NULL, PRIMARY KEY (site_id) ) in D:\Workplace\xampplite\htdocs\drupal-base\includes\database.inc on line 515.

when I searched for something and clicked on (website) tab:

* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "multisite_drupal_search_index" does not exist in D:\Workplace\xampplite\htdocs\drupal-base\includes\database.pgsql.inc on line 139.
* user warning: query: CREATE TEMPORARY TABLE temp_search_sids AS SELECT i.type, i.sid, i.subdmn_id, SUM(i.score * t.count) AS relevance, COUNT(*) AS matches FROM multisite_drupal_search_index i INNER JOIN multisite_drupal_search_total t ON i.word = t.word WHERE 1 AND (i.word = 'the') AND i.type = 'node' GROUP BY i.subdmn_id, i.type, i.sid HAVING COUNT(*) >= 1 in D:\Workplace\xampplite\htdocs\drupal-base\sites\all\modules\multisite_search\multisite_search.module on line 530.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "temp_search_sids" does not exist in D:\Workplace\xampplite\htdocs\drupal-base\includes\database.pgsql.inc on line 139.
* user warning: query: SELECT MAX(relevance) FROM temp_search_sids in D:\Workplace\xampplite\htdocs\drupal-base\sites\all\modules\multisite_search\multisite_search.module on line 533.