The Drupal 6 version of this module doesn't properly upgrade the path_access table in the database. Specifically, the "pid" field must be altered to become a serial field, i.e. add the "auto_increment" attribute. Otherwise errors occur on the /admin/user/pathaccess/edit/* screens.

This task should be performed in an update function in the path_access.install file which would be run automatically during update.php; currently no such function exists.

Comments

psynaptic’s picture

psynaptic commented
Status: Active » Needs work

Any chance of a patch? :)

budda’s picture

budda
Primary language English
Location Cheshire
commented
Status: Needs work » Needs review

I think the answer is:

<?php
function path_access_update_6100() {
  $ret = array();
  
  $ret[] = update_sql("ALTER {path_access} CHANGE pid pid INT NOT NULL AUTO_INCREMENT");
  
  return $ret;
}
?>
budda’s picture

budda
Primary language English
Location Cheshire
commented

Code committed to CVS. Needs testing.

budda’s picture

budda
Primary language English
Location Cheshire
commented
Status: Needs review » Fixed

Based on http://drupal.org/node/668224 I asume the upgrade does work with the recently committed CVS update code.

Status: Fixed » Closed (fixed)

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