Posted by wa2nlinux on February 23, 2010 at 5:13am
4 followers
Jump to:
| Project: | Faceted Search |
| Version: | 6.x-1.0-beta2 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (duplicate) |
Issue Summary
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
#1
Probably the syntax is different. Is this module marked as incompatible with Postgres?
#2
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.
#3
See #230471: PostgreSQL support for Faceted Search.
#4
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?