no postgresql support
francisd - March 4, 2008 - 22:12
| Project: | Node Relativity |
| Version: | 5.x-2.2 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | patch (code needs work) |
Description
Hello,
When I try to access Relativity's advanced settings, I get this error message:
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "relativity_query" does not exist in /var/www/suivis/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT n.nid, n.title FROM node n INNER JOIN relativity_query r ON r.nid=n.nid WHERE n.type='relativity' AND r.search_types LIKE '%"groupe"%' in /var/www/suivis/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "relativity_query" does not exist in /var/www/suivis/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT n.nid, n.title FROM node n INNER JOIN relativity_query r ON r.nid=n.nid WHERE n.type='relativity' AND r.search_types LIKE '%"projet"%' in /var/www/suivis/includes/database.pgsql.inc on line 144.Also, when I try to visualize a node, I get this one :
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "relativity" does not exist in /var/www/suivis/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT parent_nid FROM relativity WHERE nid = 2 in /var/www/suivis/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "relativity" does not exist in /var/www/suivis/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT parent_nid as pid FROM relativity WHERE nid = 2 in /var/www/suivis/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "relativity" does not exist in /var/www/suivis/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT nid FROM relativity WHERE parent_nid = 2 in /var/www/suivis/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "relativity" does not exist in /var/www/suivis/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT nid FROM relativity WHERE parent_nid = 2 in /var/www/suivis/includes/database.pgsql.inc on line 144.What's the problem ?
Thanks.
#1
I made a patch to support postgresql database.
#2
applied your patch everything seems to work fine.
Thanks
#3
The patch does not handle hook_uninstall. I'm doing my oen testing of this module today, so I will likely provide another patch soon.