Does not work with Postgres back-end
| Project: | Sliced Book Navigation |
| Version: | 5.x-1.1 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
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.
