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

CommentFileSizeAuthor
#1 admin_message.install.206089.patch708 bytesjaydub
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

jaydub’s picture

jaydub CreditAttribution: jaydub commented
Status: Active » Needs review
FileSize
admin_message.install.206089.patch708 bytes

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.

dsnopek’s picture

dsnopek
he/him
Primary language English
Location USA
CreditAttribution: dsnopek commented
Status: Needs review » Closed (won't fix)

Version for Drupal 5 is now unsupported. Sorry for the inconvenience!