get error messages when using with postgres
bfo - January 3, 2008 - 22:11
| Project: | Admin message |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | needs review |
Description
I'm trying to use this module with postgres on drupal 5.5 and get the following error message:
query: SELECT n.nid, n.created, a.keep_new, a.php_visibility FROM node n LEFT JOIN admin_message a ON n.nid = a.nid WHERE n.sticky = 1 AND n.status = 1 AND n.type = 'admin_message' ORDER BY n.created DESC in /mounts/max30/home/cath/www/ukra/includes/database.pgsql.inc on line 144.
pg_query() [function.pg-query]: Query failed: ERROR: relation "admin_message" does not exist in /mounts/max30/home/cath/www/ukra/includes/database.pgsql.inc on line 125.
I'll try and get my other half who knows more about postgres to see if he can fix it and will let you know
#1
This module does not have PostgreSQL support in the .install file.
I've added the PostgreSQL table creation to the admin_message_install()
hook.
Please apply the patch and try reinstalling the module.