Forum OpenACS Q&A: Re: Project manager 2.50 beta 1 released

Collapse
Posted by Al Walworth on
Using PM 2.50b1 on OACS 5.1.1, on the Task page clicking on "Add task" results in "No data." where the table of projects should appear (and where it did appear in PM 2.20b2).

I was able to get the table to reappear by deleting

        p.parent_id = :root_folder and

from the WHERE clause of select_a_project in www/task-select-project-postgresql.xql (and restarting aolserver).

Is this an appropriate change?  So far it works, but I don't know if it could have bad side effects.

Any explanation of why the problem occurred (the query in task-select-project-postgresql.xql did not change from 2.20b2), the purpose of "p.parent_id = :root_folder", and the recommended approach to fixing the problem would be most welcome.

Collapse
Posted by Jade Rubick on
Al, can you email the output of

# select * from cr_folders;

from psql?

I think your change is probably okay, but it may be indicative of more going on, and I'd like to track it down.