The Toolkit for Online Communities
18813 Community Members, 0 members online, 2129 visitors today
Log In Register
OpenACS Home : Forums : OpenACS Q&A : Project Manager 1.0 Version Released : One Message

Forum OpenACS Q&A: Re: Project Manager 1.0 Version Released

Posted by Randy O'Meara on

I'm seeing several different errors (one shown below) and want to be certain that I have the right version. I pulled mine from HEAD and just updated an hour ago. project-manager.info says version is 1.01.



Aolserver 4.0r2

oacs HEAD (updated yesterday)

PG 7.3.4

RH 9


Creating a project, fill in the blanks and submit:

ERROR:  Function pm_project__new_project_item("unknown", "unknown", "unknown", "unknown", "unknown", "unknown", timestamptz, timestamptz, "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", timestamptz, "unknown", "unknown", "unknown") does not exist
	Unable to identify a function that satisfies the given argument types
	You may need to add explicit typecasts

        select pm_project__new_project_item (
                to_timestamp('2004 04 30 00 00 00','YYYY MM DD HH24 MI SS'),
                to_timestamp('2004 04 30 00 00 00','YYYY MM DD HH24 MI SS'),

Posted by Andrei Popov on
I have installed my instance over the fresh download of 5.1 core + required dependencies (acs-datetime, acs-events, notifications, categories, organizations, logger, and acs-mail-lite AFAIR).  I suspect that your issue is in PG 7.3.4 -- there have been some changes to time/timestamp/etc. data types.

On a separate note, I am having problems logging in hours (but I have no problem changing percentage of completion), but can't post error message right now, as I am away from the other machine with OACS/PM instance.

One more note -- while installing 5.1 + deps, there were several times strange issues with the installer, whereby it would report an error -- but when looking at the logs no issues were recorded, albeit there were some extra messages.  I have not marked them down, unfortunately.  Will probably try to instantiate the same on another machine to see if it repeats, then would post them in bugtracker.

Posted by Andrei Popov on

This is the logger problem I have encountered:

Invalid switch: "-party_id"
    while executing
    (procedure "logger::entry::new" line 1)
    invoked from within
"logger::entry::new -entry_id $entry_id  -project_id $logger_project_id  -variable_id $variable_id  -value $value  -time_stamp $timestamp_ansi  -descri..."
    (procedure "pm::project::log_hours" line 18)
    invoked from within
"pm::project::log_hours  -entry_id $entry_id  -logger_project_id $project_id  -variable_id $variable_id  -value $value  -timestamp_ansi $time_stamp_ans..."
    invoked from within
"if { [string match [db_string check_if_exists "
        select 1
        from logger_entries
        where entry_id = :entry_id
    " -default "0"] "0"]} {

    ("uplevel" body line 7)
Posted by Jeff Davis on
Andrei, you should definitely submit a bug to bug tracker for those things; there is a "Project Manager" component to book them against.
Posted by Andrei Popov on

Looks like 5.1 logger (or rather 1.0b3) has no -party_id switch for logger::entry::new proc. Naturally, removing the offending bit from pm::project::log_hours resolves the issue.

Posted by Jade Rubick on
I submitted a patch for logger that adds a party_id switch for logger::entry. I think removing that switch is okay (I believe it is unnecessary). I added it in for bulk import of hours, so that you could (for example) import hours from ACS, as we did.

Now that I have commit rights, I'll commit that patch, bump up logger a version, and require that for the install. Or I'll remove it from project-manager.

Thanks for finding this.

I'm doing development on Postgres 7.3, so I'm not sure if Randy's problem is coming from using a different Postgres or something else.