Does not work with Postgres back-end

Brad_Macpherson - August 8, 2007 - 08:31
Project:Sliced Book Navigation
Version:5.x-1.1
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:active
Description

Module does not work when using Postgres as the back-end. The installation script detects the absence of MySQL and gives a generic error message ("Table installation for the Sliced Book Navigation module was unsuccessful. The tables may need to be installed by hand.").

I tried creating the slicedbook_navigation table manually, with 'nid' as a non-null integer primary key, and 'attribute' as a varchar 128. The module then showed itself as available and I was able to try and show a level 0 menu in the left sidebar. The following errors are typical of errors coming up whenever sliced navigation blocks are shown:

  • warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "slicedbook_navigation" does not exist in /opt/csw/apache2/share/htdocs/distributed/includes/database.pgsql.inc on line 125.
  • user warning: query: SELECT nid, attribute FROM slicedbook_navigation in /opt/csw/apache2/share/htdocs/distributed/includes/database.pgsql.inc on line 144.

After a little more hacking around (switching the module on and off, changing the book to be sliced), the error messages disappear but the block is not rendered. There are no rows present in the slicedbook_navigation table.

Using PHP 5.2.1, Drupal 5.1, PostGres 8.2.3.

 
 

Drupal is a registered trademark of Dries Buytaert.