Hello,

When installing under PostgreSQL, the following error is printed:

* warning: pg_query() [function.pg-query]: Query failed: ERREUR: l'argument de AND doit être de type booléen, et non du type smallint in /home/html/drupal/includes/database.pgsql.inc on line 139.
    * user warning: query: SELECT delta, theme, weight, region, custom, throttle, visibility, pages, title FROM blocks WHERE status AND module = 'dhtml_menu' in /home/html/drupal/sites/all/modules/dhtml_menu/dhtml_menu.install on line 18.

The correct SQL query should be:

SELECT delta, theme, weight, region, custom, throttle, visibility, pages, title FROM blocks WHERE status = 1 AND module = 'dhtml_menu'

otherwize, most parsers will rewrite the query as SELECT delta, theme, weight, region, custom, throttle, visibility, pages, title FROM blocks WHERE (status AND module) = 'dhtml_menu' which fails.

I am not uploading a patch as status = 1 on line 18 should be easy.

CommentFileSizeAuthor
#1 dhtml_menu-old-update-489616-1.patch899 bytescburschka

Comments

cburschka’s picture

cburschka
they
commented
Version: 6.x-3.x-dev » 7.x-1.x-dev
Priority: Normal » Minor
StatusFileSize
new dhtml_menu-old-update-489616-1.patch899 bytes

Please note that this update hook is non-essential clean-up (even ignoring that the version it upgrades from is the ancient 6.x-1.x). It may be annoying during DB update, and I will patch it in the -dev versions, but it can easily be worked around by simply skipping the update and reinstating the normal block.

grub3’s picture

grub3 commented

Thanks. It should be applied.

grub3’s picture

grub3 commented
Status: Needs review » Fixed

Thanks, closing.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.