The 2026 Drupal Business Survey is open. Your response will help shape the future of the Drupal business ecosystem.This is a great module. But I ran into trouble when I started using a postgresql database. The queries have all these ` characters in them, which are only used in mysql, and they serve no purpose here except to make the queries incompatible with postgres.
This is a patch that takes the ` characters out.
| Comment | File | Size | Author |
|---|---|---|---|
| #2 | hkey.diff | 10.08 KB | galaxor |
| hotkey_postgres.diff | 8.61 KB | Anonymous (not verified) |
Comments
Comment #1
smokrisCommitted. Thanks. This will be part of 6.x-2.1.
Comment #2
galaxor commentedIt turns out there was a reason for the ` characters. In mysql, the word "key" is a reserved word. In hotkeys, there's a column called key. Therefore, if we don't quote the name `key`, then none of the queries work.
Here is a patch that changes the name of the `key` column to hkey, and then uses the column with that name, which is safe in postgres and mysql.
Comment #3
smokrisThanks, @galaxor. I revised the patch slightly, to use update_sql instead of the "useless field" hack, and applied it. It's part of the 6.x-2.2 release.