Forum .LRN Q&A: Response to dotLRN some basic questions.
10: Response to dotLRN some basic questions. (response to 1)
Posted by Benjamin Bytheway on 06/22/02 11:14 PM
I've been trying to get this to work for the past little while and stumbled on to another openACS/Postgres bug.
This one is found in /packages/acs-kernel/acs-objects-create.sql
In the function acs_object__update_last_modified, the update statement reads:
update acs_objects set acs_objects.last_modified = v_last_modified where acs_objects.object_id = acs_object__update_last_modified__object_id;
This causes Postgres to give: ERROR: parser: parse error at or near "."
The correct statement should be:
update acs_objects set last_modified = v_last_modified where object_id = acs_object__update_last_modified__object_id;
(Let me know where else I should post this bug.)