Forum OpenACS Q&A: Project Manager Error editing task

Collapse
1: Project Manager Error editing task
Posted by damon pin on 02/01/06 02:45 AM
I downloaded openacs 5.15 and install the project manager from openacs repository, version is 3.0.1d1

When I tried to edit a task, the following error is returned,
seems the function pm_task_new_task_revision is mismatched,
have you seen similar error, thanks for your help.

Damon

Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR: function pm_task__new_task_revision("unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", timestamp with time zone, "unknown", "unknown", "unknown", "unknown") does not exist
HINT: No function matches the given name and argument types. You may need to add explicit type casts.

SQL:
select pm_task__new_task_revision (
'951',
'931',
'ELS Remote Backup',
'Initial backup from ELS inside, then move the device to EL home.',
'text/plain',
'2006-02-14',
'0',
'2.8',
'1.6',
'4.0',
NULL,
'1',
current_timestamp,
'454',
'192.168.0.90',
'799',
'1')

while executing
"ns_pg_bind 0or1row nsdb0 {
select pm_task__new_task_revision (
:task_item_id,
:project_item_id,
:title,
:description,
..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
}
..."
invoked from within
"db_exec 0or1row $db $full_statement_name $sql"
invoked from within
"if {[regexp -nocase -- {^\s*select} $test_sql match]} {
ns_log Debug "PLPGSQL: bypassed anon function"
set selection [..."
("uplevel" body line 6)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
# plsql calls that are simple selects bypass the plpgsql
# mechanism for creating anonymous fun..."
(procedure "db_exec_plsql" line 57)
invoked from within
"db_exec_plsql new_task_revision { *SQL }"
(procedure "pm::task::edit" line 21)
invoked from within
"pm::task::edit -task_item_id $task_item_id($num) -project_item_id $project_item_id($num) -title $task_title..."
("foreach" body line 33)
invoked from within
"foreach num $number {

# --------------------------
# figure out estimated hours
# --------------------------

if {[st..."
invoked from within
"if {[string is true $edit_p]} {

# -------
# EDITING
# -------


# -----------------------------------------------------
#..."
("uplevel" body line 109)
invoked from within
"uplevel {
#

ad_page_contract {

Processes the add or edit

@author Jade Rubick (mailto:jader@bread.com)
@creation-date 2004-10-13..."
(procedure "code::tcl::/var/lib/aolserver/elshk/packages/project-manager..." line 2)
invoked from within
"code::tcl::$__adp_stub"
invoked from within
"if { [file exists $__adp_stub.tcl] } {

# ensure that data source preparation procedure exists and is up-to-date
adp_init tcl $__adp_stub
..."
("uplevel" body line 3)
invoked from within
"uplevel {

if { [file exists $__adp_stub.tcl] } {

# ensure that data source preparation procedure exists and is up-to-date
adp_init t..."
(procedure "adp_prepare" line 2)
invoked from within
"adp_prepare "
(procedure "template::adp_parse" line 30)
invoked from within
"template::adp_parse [file root [ad_conn file]] {}"
(procedure "adp_parse_ad_conn_file" line 5)
invoked from within
"$handler"
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"ad_try {
$handler
} ad_script_abort val {
# do nothing
}"
invoked from within
"rp_serve_concrete_file [ad_conn file]"
(procedure "rp_serve_abstract_file" line 60)
invoked from within
"rp_serve_abstract_file "$root/$path""
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"ad_try {
rp_serve_abstract_file "$root/$path"
set tcl_url2file([ad_conn url]) [ad_conn file]
set tcl_url2path_info..."

Collapse
2: Re: Project Manager Error editing task (response to 1)
Posted by Janine Ohmer on 02/01/06 08:48 AM
Try again with a copy checked out from CVS on the oacs-5-2 branch. The version you have is from HEAD (the repository was being built incorrectly until a few days ago) and does not work.
Collapse
3: Re: Re: Project Manager Error editing task (response to 2)
Posted by damon pin on 02/02/06 08:12 AM
Hi Janine

Thanks for your quick reply, I will try again.

Collapse
4: Re: Project Manager Error editing task (response to 1)
Posted by damon pin on 02/16/06 03:22 AM
I am a CVS newbie, so this is a little confusing

if I do CVS co -r oacs-5-2 project-manager

I get project manager version 2.70a1 and
not the latest version on oacs-5-2 branch , which is 2.71a4.

How can I get the latest version ?

Thanks for helping

Collapse
5: Re: Project Manager Error editing task (response to 1)
Posted by Michael Steigman on 02/16/06 05:19 PM
Interesting, Janine - I thought new work is occuring on HEAD and not 5.2. Are you working on the package? Are you coordinating with Malte (who is working on HEAD)?

If we were to follow our own developer guidelines, work *should* be happening on 5.2. At some point soon, both Contacts and PM should be merged to 5.2 and development should continue there.

Collapse
6: Re: Re: Project Manager Error editing task (response to 5)
Posted by Malte Sussdorff on 02/17/06 11:44 AM
The reason and merrit to doing the work in HEAD was: 5.2 was not out there when we started, so we should have worked on 5.1, which was impossible due to dependencies on 5.2 core. So we decided to go with HEAD, also because HEAD usually is a branch where things are expected to break (and we did a lot of changes).

Merging contacts and AMS into 5.2 is easy, same goes for tasks and mail-tracking. What is going to be tricky though is merging Project Manager as Janine did a whole lot of work, especially for Oracle, and I do not want her to have to go through the pain again in short time to update the PM package for Oracle yet again once we merged it to 5.2. Not to mention that the merge most likely will be a challenge in the first place, which should be done, but where we don't have the time for at the moment (though anyone with a little bit of spare time is highly encourage to do this).