Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.I just installed the module and I am unable to use it because of some PostgreSQL errors. I'd appreciate any helps as I'd really like to use this module. Thanks!
pg_query() [<a href='function.pg-query'>function.pg-query</a>]: Query failed: ERROR: invalid input syntax for integer: "" in /var/www/includes/database.pgsql.inc on line 139.
query: INSERT INTO path_access (rid, pages, visibility) VALUES (1, '', '') in /var/www/sites/all/modules/contrib/path_access/path_access.module on line 121.
| Comment | File | Size | Author |
|---|---|---|---|
| #2 | 1031230-path_access-empty_string_is_not_zero.patch | 639 bytes | xurizaemon |
Comments
Comment #1
xurizaemonThis issue occurs when first editing a role's path access settings. When displaying the initial form, path access attempts to insert the role ID into the path_access table. Visibility is an INTEGER. MySQL masks this error by interpreting '' as 0 for INT columns.
In #1013732: Port Path Access to Drupal 7 I've simply replaced '' with 0 for the visibility column, which has the same end result and doesn't throw an SQL error.
Comment #2
xurizaemonI'm using this module on D7 not D6, so I have not tested this patch.
Comment #3
tseven commentedJust applied the patch on my D6 install and everything seems fine.
Thank you.
I hope this fix makes it into the next update.
Comment #4
mrfelton commentedFixed in git:
http://drupalcode.org/project/path_access.git/commitdiff/0465d16?hp=7e32...
Thanks.
Comment #6
rmcom commentedProposing that this path should go into a final D6 release.
Comment #7
xurizaemonSetting version, status so this can be considered for 6.x release per previous request - seems like there's a patch already here. If you want this patch in, please act by reviewing it and updating the status accordingly.