Hi all here error code when I try to install on drupal with postgre

warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "unsigned" at character 63 in /home/forum/drupal-6.15/includes/database.pgsql.inc on line 139.
user warning: query: CREATE TEMPORARY TABLE temp_faceted_search_results_1 (nid int unsigned NOT NULL, PRIMARY KEY (nid)) Engine=HEAP SELECT n.nid AS nid, 5 * POW(2, (GREATEST(MAX(n.created), MAX(n.changed), MAX(c.last_comment_timestamp)) - 1264958386) * 6.43e-8) + 5 * (2.0 - 2.0 / (1.0 + MAX(c.comment_count) * 0.0185185185185)) AS score FROM node AS n LEFT JOIN node_comment_statistics AS c ON n.nid = c.nid WHERE ((n.status = 1) AND (n.type IN ('forum'))) GROUP BY n.nid ASC ORDER BY score DESC in /home/forum/drupal-6.15/sites/all/modules/faceted_search/faceted_search.inc on line 1174.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "temp_faceted_search_results_1" does not exist in /home/forum/drupal-6.15/includes/database.pgsql.inc on line 139.
user warning: query: SELECT COUNT(*) FROM temp_faceted_search_results_1 in /home/forum/drupal-6.15/sites/all/modules/faceted_search/faceted_search.inc on line 1175.

Comments

EvanDonovan’s picture

EvanDonovan commented
Title: postgres support » Is this postgres support for this module?

Probably the syntax is different. Is this module marked as incompatible with Postgres?

dspring0021’s picture

dspring0021 commented

I'm experiencing this issue as well and I'm using PostgreSQL. Once I got past the PHP 5.3.2 patch issues, my installation seemed fine until I enabled the 'Content Type Facet'. There may be other facets that produce this or similar pgsql errors as well. So, once I enable the module and attempt to access a faceted search, I get the following:

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "unsigned" LINE 1: ...RARY TABLE temp_faceted_search_results_1 (nid int unsigned N... ^ in /var/www/drupal/includes/database.pgsql.inc on line 139.
    * user warning: query: CREATE TEMPORARY TABLE temp_faceted_search_results_1 (nid int unsigned NOT NULL, PRIMARY KEY (nid)) Engine=HEAP SELECT n.nid AS nid, 5 * POW(2, (GREATEST(MAX(n.created), MAX(n.changed), MAX(c.last_comment_timestamp)) - 1281635065) * 6.43e-8) + 5 * (2.0 - 2.0 / (1.0 + MAX(c.comment_count) * 1)) AS score FROM node AS n LEFT JOIN node_comment_statistics AS c ON n.nid = c.nid WHERE ((n.status = 1) AND (n.type IN ('agency'))) AND n.nid IN (SELECT node.nid AS nid FROM node node LEFT JOIN content_field_agency_name node_data_field_agency_name ON node.vid = node_data_field_agency_name.vid LEFT JOIN content_type_agency node_data_field_agency_phone ON node.vid = node_data_field_agency_phone.vid WHERE node.type in ('agency') ) GROUP BY n.nid ASC ORDER BY score DESC in /var/www/drupal/sites/all/modules/faceted_search/faceted_search.inc on line 1182.
    * warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "temp_faceted_search_results_1" does not exist in /var/www/drupal/includes/database.pgsql.inc on line 139.
    * user warning: query: SELECT COUNT(*) FROM temp_faceted_search_results_1 in /var/www/drupal/sites/all/modules/faceted_search/faceted_search.inc on line 1183.

I'm on Drupal 6.17 with PHP 5.3 and PostgreSQL 8.4.3.

David Lesieur’s picture

David Lesieur commented
Status: Active » Closed (duplicate)

See #230471: PostgreSQL support for Faceted Search.

dspring0021’s picture

dspring0021 commented

Thanks, David. I couldn't surmise if the last posted patch is an official stable patch or if there is still any work being done on the effort?