the sql it attempts to execute when upgrading is incorrect (at last on my flavor of mysql).

incorrect:
ALTER {path_access} CHANGE pid pid SERIAL NOT NULL AUTO_INCREMENT

correct:
ALTER TABLE {path_access} CHANGE pid pid SERIAL NOT NULL AUTO_INCREMENT

Comments

budda’s picture

Status: Active » Fixed

That will teach me to commit to CVS and go to bed without testing. Thanks. Fix committed to CVS.

Status: Fixed » Closed (fixed)

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