looks like you need to change <i>select user_id_sequence.nextval from dual</i> to <i>select nextval('user_id_sequence')</i> if you are running postgres.
<br><br>
although I'm surprised that you're running into this problem. Does openacs-235 = openacs 3.2.5?