The ]popo[ V4.0 installer for download.
The file is available here on SourceForge -> Files -> project-open -> V4.0 ->
project-open-VMware-4.0.1.0.1-dev1.zip
The version is called "Dev-1", because it's still under development (not even "alpha").
However, the developments that are missing are new features rather then instabilities
of the base product, so we are already using this version in production for many
customers.
In contrast to the basically stable product code, we have chosen CentOS 6.2 as the
base for the VMware. This version is completely new for us, so there may still be some
quirks to come.
We are going to use ]PO[ as our ERP on our IT company (we are a small MSP)
We tested the 4.0 version but we gonna stick with the 3.5 for now.
We are on the early phase of knowing the program and is functionality.
I want to thank you for this fix:
# su - root
# yum install graphviz-gd
Because the 3.5 vmware as the same error :) By the way, can't find the post about 3.5 vmaware release, can you help us?
A note to the community: Both vmware versions can be installed in Virtualbox, just create a machine and use the VMDK files as the disk. In version 3.5 you have o to use SCSI controller for the disk, in version 4.0 the default SATA works just fine.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Database operation "0or1row" failed
(exception ERROR, "ERROR: function im_ticket__new(integer, character varying, timestamp with time zone, integer, character varying, integer, character varying, integer, integer, integer, integer) does not exist
LINE 1: SELECT im_ticket__new ( $1 , $2 , $3 , $4 , $5 , $6 ,…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
QUERY: SELECT im_ticket__new ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 , $11 )
CONTEXT: PL/pgSQL function "im_ticket__new" line 16 at return
")
while executing
"ns_pg_bind 0or1row nsdb0 {
SELECT im_ticket__new (
:ticket_id, - p_ticket_id
'im_ticket', - object_type
now(), - creation_date
:error_…"
("uplevel" body line 1)
invoked from within
"uplevel $ulevel
"
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel $args]
}
…"
invoked from within
"db_exec 0or1row $db $full_name $sql"
invoked from within
"set selection "
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection
}"
(procedure "db_string" line 27)
invoked from within
"db_string ticket_insert {}"
invoked from within
"set ticket_id "
("uplevel" body line 309)
invoked from within
"uplevel {
# /packages/intranet-forum/www/intranet/forum/new-system-error.tcl
#
# Copyright (C) 2003 - 2009 ]project-open[
#
# All rights reserved. Ple…"
(procedure "code::tcl::/web/projop/packages/intranet-forum/www/new-syste…" line 2)
invoked from within
"code::tcl::$__adp_stub"
invoked from within
"if { } {
# 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 { } {
# 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"
invoked from within
"template::adp_parse [file root ] {}"
(procedure "adp_parse_ad_conn_file" line 6)
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 "
(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()
set tcl_url2path_info() [ad_conn path_…"
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Here is a detailed dump of what took place at the time of the error, which may assist a programmer in tracking down the problem:
Database operation "0or1row" failed
(exception ERROR, "ERROR: function to_date(timestamp with time zone, unknown) does not exist
LINE 1: select to_date(date_trunc('month',add_months( $1 ,1)),'YYYY-…
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
QUERY: select to_date(date_trunc('month',add_months( $1 ,1)),'YYYY-MM-DD') - 1
CONTEXT: PL/pgSQL function "last_day" line 6 at SQL statement
")
pqerror was: "ERROR: function to_date(timestamp with time zone, unknown) does not exist
LINE 1: select to_date(date_trunc('month',add_months( $1 ,1)),'YYYY-…
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
QUERY: select to_date(date_trunc('month',add_months( $1 ,1)),'YYYY-MM-DD') - 1
CONTEXT: PL/pgSQL function "last_day" line 6 at SQL statement
"
(Status of PQexec call: PGRES_FATAL_ERROR)
SQL: select to_char(trunc(to_date('2012-02-09', 'yyyy-mm-dd'), 'Month'), 'fmMonth') as month,
to_char(trunc(to_date('2012-02-09', 'yyyy-mm-dd'), 'Month'), 'YYYY') as year,
to_char(trunc(to_date('2012-02-09', 'yyyy-mm-dd'), 'Month'), 'J') as first_julian_date_of_month,
to_char(last_day(to_date('2012-02-09', 'yyyy-mm-dd')), 'DD') as num_days_in_month,
to_char(trunc(to_date('2012-02-09', 'yyyy-mm-dd'), 'Month'), 'D') as first_day_of_month,
to_char(last_day(to_date('2012-02-09', 'yyyy-mm-dd')), 'DD') as last_day,
trunc(add_months(to_date('2012-02-09', 'yyyy-mm-dd'), 1),'Day') as next_month,
trunc(add_months(to_date('2012-02-09', 'yyyy-mm-dd'), -1),'Day') as prev_month,
trunc(to_date('2012-02-09', 'yyyy-mm-dd'), 'year') as beginning_of_year,
to_char(last_day(add_months(to_date('2012-02-09', 'yyyy-mm-dd'), -1)), 'DD') as days_in_last_month,
to_char(add_months(to_date('2012-02-09', 'yyyy-mm-dd'), 1), 'fmMonth') as next_month_name,
to_char(add_months(to_date('2012-02-09', 'yyyy-mm-dd'), -1), 'fmMonth') as prev_month_name
from dual
while executing
"ns_pg_bind 0or1row nsdb0 -bind d11 {select to_char(trunc(to_date(:the_date, 'yyyy-mm-dd'), 'Month'), 'fmMonth') as month,
to_char(trunc(to_date(:…"
("eval" body line 1)
invoked from within
"eval
"
invoked from within
"db_exec 0or1row $db $full_statement_name $sql"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection
}"
(procedure "db_0or1row" line 50)
invoked from within
"db_0or1row calendar_get_information {select to_char(trunc(to_date(:the_date, 'yyyy-mm-dd'), 'Month'), 'fmMonth') as month,
to_char(trunc(to_date(…"
("uplevel" body line 1)
invoked from within
"uplevel db_0or1row $args"
(procedure "db_1row" line 2)
invoked from within
"db_1row calendar_get_information $month_info_query -bind $bind_vars -column_set calendar_info_set"
(procedure "calendar_get_info_from_db" line 31)
invoked from within
"calendar_get_info_from_db $date"
("uplevel" body line 137)
invoked from within
"uplevel {
# /packages/intranet-timesheet2/www/hours/index.tcl
#
# Copyright (C) 1998-2004 various parties
# The code is based on ArsDigita ACS 3.4
#
#…"
(procedure "code::tcl::/web/projop/packages/intranet-timesheet2/www/hour…" line 2)
invoked from within
"code::tcl::$__adp_stub"
("uplevel" body line 12)
invoked from within
"uplevel {
if { } {
# 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"
invoked from within
"template::adp_parse [file root ] {}"
(procedure "adp_parse_ad_conn_file" line 6)
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 "
(procedure "rp_serve_abstract_file" line 60)
invoked from within
"rp_serve_abstract_file "$root/$extra_url""
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"ad_try {
rp_serve_abstract_file "$root/$extra_url"
set tcl_url2file()
set tcl_url2path…"
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If I click on any project I get this error. V 4.0.3
Here is a detailed dump of what took place at the time of the error, which may assist a programmer in tracking down the problem:
Database operation "0or1row" failed
(exception ERROR, "ERROR: column pi.item_project_member_hourly_cost does not exist
LINE 5: coalesce(pi.item_project_member_hourly_cost, '30') as ho…
^
")
pqerror was: "ERROR: column pi.item_project_member_hourly_cost does not exist
LINE 5: coalesce(pi.item_project_member_hourly_cost, '30') as ho…
^
"
(Status of PQexec call: PGRES_FATAL_ERROR)
SQL:
select sum(amount_converted * hourly_cost)
from (
select sum(pi.item_value) as amount_converted,
coalesce(pi.item_project_member_hourly_cost, '30') as hourly_cost
from im_planning_items pi
where pi.item_object_id = '32672' and
pi.item_cost_type_id = 3736
group by
pi.item_project_member_id,
pi.item_project_member_hourly_cost
) t
while executing
"ns_pg_bind 0or1row nsdb1 {
select sum(amount_converted * hourly_cost)
from (
select sum(pi.item_value) as amount_converted,
coalesce(pi.ite…"
("uplevel" body line 1)
invoked from within
"uplevel $ulevel
"
invoked from within
"db_exec 0or1row $db $full_name $sql"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection
}"
(procedure "db_string" line 27)
invoked from within
"db_string ts_budget $planning_ts_hours_sql -default 0.0"
(procedure "im_cost_update_project_cost_cache" line 128)
invoked from within
"im_cost_update_project_cost_cache $project_id"
(procedure "im_costs_project_finance_component" line 63)
invoked from within
"im_costs_project_finance_component -show_details_p 0 $user_id $project_id"
("uplevel" body line 1)
invoked from within
"uplevel 1 $component_tcl"
("uplevel" body line 8)
invoked from within
"uplevel 1 $code_block "
("uplevel" body line 1)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection
set counter 0
while { [db_getrow $…"
(procedure "db_foreach" line 36)
invoked from within
"db_foreach get_plugins $plugin_sql {
if {"" == $sort_order} { set sort_order $default_sort…"
(procedure "im_component_bay" line 59)
invoked from within
"im_component_bay left"
("uplevel" body line 26)
invoked from within
"uplevel {
set __adp_output ""
set __adp_master
set __adp_properties(title) "[ad_quotehtml…"
(procedure "template::code::adp::/web/projop/packages/intranet-core/www/…" line 2)
invoked from within
"template::code::${template_extension}::$__adp_stub"
invoked from within
"template::adp_parse [file root ] {}"
(procedure "adp_parse_ad_conn_file" line 6)
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 "
(procedure "rp_serve_abstract_file" line 60)
invoked from within
"rp_serve_abstract_file "$root/$extra_url""
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"ad_try {
rp_serve_abstract_file "$root/$extra_url"
set tcl_url2file()
set tcl_url2path…"
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Before I fixed the project page I could look at my timesheet form. Now when I click on timesheet I get this:
Here is a detailed dump of what took place at the time of the error, which may assist a programmer in tracking down the problem:
Database operation "0or1row" failed
(exception ERROR, "ERROR: function to_date(integer, unknown) does not exist
LINE 12: and day between to_date(2455956, 'J') and t…
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
")
pqerror was: "ERROR: function to_date(integer, unknown) does not exist
LINE 12: and day between to_date(2455956, 'J') and t…
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
"
(Status of PQexec call: PGRES_FATAL_ERROR)
SQL:
select
sum(hours) as unconfirmed_hours
from (
select
to_char(day, 'J') as julian_date,
sum(hours) as hours
from
im_hours
where
user_id = 32677
and day between to_date(2455956, 'J') and to_date(2455962, 'J')
and conf_object_id is null
group by
to_char(day, 'J')
) i
while executing
"ns_pg_bind 0or1row nsdb0 {
select
sum(hours) as unconfirmed_hours
from (
select
to_char(day, 'J') as julian_date,
…"
("uplevel" body line 1)
invoked from within
"uplevel $ulevel
"
invoked from within
"db_exec 0or1row $db $full_name $sql"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection
}"
(procedure "db_string" line 27)
invoked from within
"db_string get_unconfirmed_hours $sql -default 0"
(procedure "get_unconfirmed_hours_for_period" line 20)
invoked from within
"get_unconfirmed_hours_for_period $current_user_id $start_date_julian_wf $end_date_julian_wf"
("uplevel" body line 265)
invoked from within
"uplevel {
# /packages/intranet-timesheet2/www/hours/index.tcl
#
# Copyright (C) 1998-2004 various parties
# The code is based on ArsDigita ACS 3.4
#
#…"
(procedure "code::tcl::/web/projop/packages/intranet-timesheet2/www/hour…" line 2)
invoked from within
"code::tcl::$__adp_stub"
("uplevel" body line 12)
invoked from within
"uplevel {
if { } {
# 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"
invoked from within
"template::adp_parse [file root ] {}"
(procedure "adp_parse_ad_conn_file" line 6)
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 "
(procedure "rp_serve_abstract_file" line 60)
invoked from within
"rp_serve_abstract_file "$root/$extra_url""
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"ad_try {
rp_serve_abstract_file "$root/$extra_url"
set tcl_url2file()
set tcl_url2path…"
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Please update the package intranet-planning from CVS. The latest version includes an upgrade script /packages/intranet-planning/sql/postgresq/upgrade/upgrade-4.0.3.0.2-4.0.3.0.3.sql that you can execute using "psql -f …". This will fix the listed issue.
Hi Cmich,
> ERROR: function to_date(integer, unknown) does not exist
Please perform a CVS update of the /packages/intranet-timesheet2 to fix the issue.
Thanks for reporting!
Frank
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
bash-4.1$ psql -f upgrade-4.0.3.0.2-4.0.3.0.3.sql
psql:upgrade-4.0.3.0.2-4.0.3.0.3.sql:3: NOTICE: adding missing FROM-clause entry for table "acs_log_id_seq"
LINE 1: …ogs (log_id, log_level, log_key, message) values (acs_log_id…
^
QUERY: insert into acs_logs (log_id, log_level, log_key, message) values (acs_log_id_seq.nextval, 'debug', $1 , $2 )
CONTEXT: PL/pgSQL function "acs_log__debug" line 5 at SQL statement
acs_log__debug
0
(1 row)
CREATE FUNCTION
inline_0
0
(1 row)
DROP FUNCTION
CREATE FUNCTION
psql:upgrade-4.0.3.0.2-4.0.3.0.3.sql:70: ERROR: column "item_project_member_hourly_cost" does not exist
LINE 1: …r_id is not null and item_cost_type_id = 3736 and item_proje…
^
QUERY: select * from im_planning_items where item_project_member_id is not null and item_cost_type_id = 3736 and item_project_member_hourly_cost is null
CONTEXT: PL/pgSQL function "inline_0" line 4 at FOR over SELECT rows
DROP FUNCTION
CREATE FUNCTION
bash-4.1$
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
The ]popo[ V4.0 installer for download.
The file is available here on SourceForge -> Files -> project-open -> V4.0 ->
project-open-VMware-4.0.1.0.1-dev1.zip
The version is called "Dev-1", because it's still under development (not even "alpha").
However, the developments that are missing are new features rather then instabilities
of the base product, so we are already using this version in production for many
customers.
In contrast to the basically stable product code, we have chosen CentOS 6.2 as the
base for the VMware. This version is completely new for us, so there may still be some
quirks to come.
For a status of the development please see
http://www.project-open.org/documentation/project_open_roadmap , go to the V4.0
section and drill down into the links of the packages for a status.
Please let us know about your experience with the VMware and post any issues
either here in this forum or in the "Bug Tracker".
Cheers!
Frank
Hi,
I've got already the first amendments, the reverse proxy Pound is not running correctly.
As user "root" please enter:
# chkconfig -add pound
# chkconfig -levels 345 pound on
# /etc/init.d/pound restart
Cheers,
Frank
Hi,
Here is the next fix for a display issue of workflows. You need to create a symbolic
link to the "dot" Linux command:
# su - root
# cd /usr/local/bin
# ln -s /usr/bin/dot
Cheers,
Frank
Another fix for GraphViz "dot":
# su - root
# yum install graphviz-gd
Bests,
Frank
Hi,
I see that we've got 45 downloads so far, but no feedback yet, neither positive nor negative.
Could you please let us know if things have worked out for you after downloading the VMware?
Just drop a short note in this thread, please.
Thanks!
Frank
Hi,
We are going to use ]PO[ as our ERP on our IT company (we are a small MSP)
We tested the 4.0 version but we gonna stick with the 3.5 for now.
We are on the early phase of knowing the program and is functionality.
I want to thank you for this fix:
# su - root
# yum install graphviz-gd
Because the 3.5 vmware as the same error :) By the way, can't find the post about 3.5 vmaware release, can you help us?
A note to the community: Both vmware versions can be installed in Virtualbox, just create a machine and use the VMDK files as the disk. In version 3.5 you have o to use SCSI controller for the disk, in version 4.0 the default SATA works just fine.
First error, cannot list all users:
Database operation "0or1row" failed
(exception ERROR, "ERROR: function im_ticket__new(integer, character varying, timestamp with time zone, integer, character varying, integer, character varying, integer, integer, integer, integer) does not exist
LINE 1: SELECT im_ticket__new ( $1 , $2 , $3 , $4 , $5 , $6 ,…
^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.
QUERY: SELECT im_ticket__new ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 , $11 )
CONTEXT: PL/pgSQL function "im_ticket__new" line 16 at return
")
while executing
"ns_pg_bind 0or1row nsdb0 {
SELECT im_ticket__new (
:ticket_id, - p_ticket_id
'im_ticket', - object_type
now(), - creation_date
:error_…"
("uplevel" body line 1)
invoked from within
"uplevel $ulevel
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel $args]
}
…"
invoked from within
"db_exec 0or1row $db $full_name $sql"
invoked from within
"set selection "
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection
}"
(procedure "db_string" line 27)
invoked from within
"db_string ticket_insert {}"
invoked from within
"set ticket_id "
("uplevel" body line 309)
invoked from within
"uplevel {
# /packages/intranet-forum/www/intranet/forum/new-system-error.tcl
#
# Copyright (C) 2003 - 2009 ]project-open[
#
# All rights reserved. Ple…"
(procedure "code::tcl::/web/projop/packages/intranet-forum/www/new-syste…" line 2)
invoked from within
"code::tcl::$__adp_stub"
invoked from within
"if { } {
# 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 { } {
# 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"
invoked from within
"template::adp_parse [file root ] {}"
(procedure "adp_parse_ad_conn_file" line 6)
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 "
(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()
set tcl_url2path_info() [ad_conn path_…"
Hi Pgerado,
Please let us know the URL where this error occurs.
Cheers,
Frank
/intranet/users/index?&user_group_name=All
If i click Timesheet i get this error:
Here is a detailed dump of what took place at the time of the error, which may assist a programmer in tracking down the problem:
Database operation "0or1row" failed
(exception ERROR, "ERROR: function to_date(timestamp with time zone, unknown) does not exist
LINE 1: select to_date(date_trunc('month',add_months( $1 ,1)),'YYYY-…
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
QUERY: select to_date(date_trunc('month',add_months( $1 ,1)),'YYYY-MM-DD') - 1
CONTEXT: PL/pgSQL function "last_day" line 6 at SQL statement
")
pqerror was: "ERROR: function to_date(timestamp with time zone, unknown) does not exist
LINE 1: select to_date(date_trunc('month',add_months( $1 ,1)),'YYYY-…
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
QUERY: select to_date(date_trunc('month',add_months( $1 ,1)),'YYYY-MM-DD') - 1
CONTEXT: PL/pgSQL function "last_day" line 6 at SQL statement
"
(Status of PQexec call: PGRES_FATAL_ERROR)
SQL: select to_char(trunc(to_date('2012-02-09', 'yyyy-mm-dd'), 'Month'), 'fmMonth') as month,
to_char(trunc(to_date('2012-02-09', 'yyyy-mm-dd'), 'Month'), 'YYYY') as year,
to_char(trunc(to_date('2012-02-09', 'yyyy-mm-dd'), 'Month'), 'J') as first_julian_date_of_month,
to_char(last_day(to_date('2012-02-09', 'yyyy-mm-dd')), 'DD') as num_days_in_month,
to_char(trunc(to_date('2012-02-09', 'yyyy-mm-dd'), 'Month'), 'D') as first_day_of_month,
to_char(last_day(to_date('2012-02-09', 'yyyy-mm-dd')), 'DD') as last_day,
trunc(add_months(to_date('2012-02-09', 'yyyy-mm-dd'), 1),'Day') as next_month,
trunc(add_months(to_date('2012-02-09', 'yyyy-mm-dd'), -1),'Day') as prev_month,
trunc(to_date('2012-02-09', 'yyyy-mm-dd'), 'year') as beginning_of_year,
to_char(last_day(add_months(to_date('2012-02-09', 'yyyy-mm-dd'), -1)), 'DD') as days_in_last_month,
to_char(add_months(to_date('2012-02-09', 'yyyy-mm-dd'), 1), 'fmMonth') as next_month_name,
to_char(add_months(to_date('2012-02-09', 'yyyy-mm-dd'), -1), 'fmMonth') as prev_month_name
from dual
while executing
"ns_pg_bind 0or1row nsdb0 -bind d11 {select to_char(trunc(to_date(:the_date, 'yyyy-mm-dd'), 'Month'), 'fmMonth') as month,
to_char(trunc(to_date(:…"
("eval" body line 1)
invoked from within
"eval
invoked from within
"db_exec 0or1row $db $full_statement_name $sql"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection
}"
(procedure "db_0or1row" line 50)
invoked from within
"db_0or1row calendar_get_information {select to_char(trunc(to_date(:the_date, 'yyyy-mm-dd'), 'Month'), 'fmMonth') as month,
to_char(trunc(to_date(…"
("uplevel" body line 1)
invoked from within
"uplevel db_0or1row $args"
(procedure "db_1row" line 2)
invoked from within
"db_1row calendar_get_information $month_info_query -bind $bind_vars -column_set calendar_info_set"
(procedure "calendar_get_info_from_db" line 31)
invoked from within
"calendar_get_info_from_db $date"
("uplevel" body line 137)
invoked from within
"uplevel {
# /packages/intranet-timesheet2/www/hours/index.tcl
#
# Copyright (C) 1998-2004 various parties
# The code is based on ArsDigita ACS 3.4
#
#…"
(procedure "code::tcl::/web/projop/packages/intranet-timesheet2/www/hour…" line 2)
invoked from within
"code::tcl::$__adp_stub"
("uplevel" body line 12)
invoked from within
"uplevel {
if { } {
# 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"
invoked from within
"template::adp_parse [file root ] {}"
(procedure "adp_parse_ad_conn_file" line 6)
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 "
(procedure "rp_serve_abstract_file" line 60)
invoked from within
"rp_serve_abstract_file "$root/$extra_url""
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"ad_try {
rp_serve_abstract_file "$root/$extra_url"
set tcl_url2file()
set tcl_url2path…"
in url:
/intranet-timesheet2/hours/index
i really want to use this software to later ressel to my customers, but it's beeing hard :)
Hi,
The issue has been fixed in ]po[ V4.0.3, which is not available also as an "upgrade installer" in the V4.0 section.
Cheers,
Frank
If I click on any project I get this error. V 4.0.3
Here is a detailed dump of what took place at the time of the error, which may assist a programmer in tracking down the problem:
Database operation "0or1row" failed
(exception ERROR, "ERROR: column pi.item_project_member_hourly_cost does not exist
LINE 5: coalesce(pi.item_project_member_hourly_cost, '30') as ho…
^
")
pqerror was: "ERROR: column pi.item_project_member_hourly_cost does not exist
LINE 5: coalesce(pi.item_project_member_hourly_cost, '30') as ho…
^
"
(Status of PQexec call: PGRES_FATAL_ERROR)
SQL:
select sum(amount_converted * hourly_cost)
from (
select sum(pi.item_value) as amount_converted,
coalesce(pi.item_project_member_hourly_cost, '30') as hourly_cost
from im_planning_items pi
where pi.item_object_id = '32672' and
pi.item_cost_type_id = 3736
group by
pi.item_project_member_id,
pi.item_project_member_hourly_cost
) t
while executing
"ns_pg_bind 0or1row nsdb1 {
select sum(amount_converted * hourly_cost)
from (
select sum(pi.item_value) as amount_converted,
coalesce(pi.ite…"
("uplevel" body line 1)
invoked from within
"uplevel $ulevel
invoked from within
"db_exec 0or1row $db $full_name $sql"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection
}"
(procedure "db_string" line 27)
invoked from within
"db_string ts_budget $planning_ts_hours_sql -default 0.0"
(procedure "im_cost_update_project_cost_cache" line 128)
invoked from within
"im_cost_update_project_cost_cache $project_id"
(procedure "im_costs_project_finance_component" line 63)
invoked from within
"im_costs_project_finance_component -show_details_p 0 $user_id $project_id"
("uplevel" body line 1)
invoked from within
"uplevel 1 $component_tcl"
("uplevel" body line 8)
invoked from within
"uplevel 1 $code_block "
("uplevel" body line 1)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection
set counter 0
while { [db_getrow $…"
(procedure "db_foreach" line 36)
invoked from within
"db_foreach get_plugins $plugin_sql {
if {$any_perms_set_p > 0 && "f" == $perm} { continue }
if {"" == $sort_order} { set sort_order $default_sort…"
(procedure "im_component_bay" line 59)
invoked from within
"im_component_bay left"
("uplevel" body line 26)
invoked from within
"uplevel {
set __adp_output ""
set __adp_master
set __adp_properties(title) "[ad_quotehtml…"
(procedure "template::code::adp::/web/projop/packages/intranet-core/www/…" line 2)
invoked from within
"template::code::${template_extension}::$__adp_stub"
invoked from within
"template::adp_parse [file root ] {}"
(procedure "adp_parse_ad_conn_file" line 6)
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 "
(procedure "rp_serve_abstract_file" line 60)
invoked from within
"rp_serve_abstract_file "$root/$extra_url""
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"ad_try {
rp_serve_abstract_file "$root/$extra_url"
set tcl_url2file()
set tcl_url2path…"
Pls. deactivate portlet "Project Planning" for now:
http:////intranet/admin/components/index?package_key_form=intranet-planning
I disabled that portlet and restarted the server. I'm getting the same error. Any ideas?
Fixed it! Had to disable the portlet and the package! Thanks for the help!
Before I fixed the project page I could look at my timesheet form. Now when I click on timesheet I get this:
Here is a detailed dump of what took place at the time of the error, which may assist a programmer in tracking down the problem:
Database operation "0or1row" failed
(exception ERROR, "ERROR: function to_date(integer, unknown) does not exist
LINE 12: and day between to_date(2455956, 'J') and t…
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
")
pqerror was: "ERROR: function to_date(integer, unknown) does not exist
LINE 12: and day between to_date(2455956, 'J') and t…
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
"
(Status of PQexec call: PGRES_FATAL_ERROR)
SQL:
select
sum(hours) as unconfirmed_hours
from (
select
to_char(day, 'J') as julian_date,
sum(hours) as hours
from
im_hours
where
user_id = 32677
and day between to_date(2455956, 'J') and to_date(2455962, 'J')
and conf_object_id is null
group by
to_char(day, 'J')
) i
while executing
"ns_pg_bind 0or1row nsdb0 {
select
sum(hours) as unconfirmed_hours
from (
select
to_char(day, 'J') as julian_date,
…"
("uplevel" body line 1)
invoked from within
"uplevel $ulevel
invoked from within
"db_exec 0or1row $db $full_name $sql"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection
}"
(procedure "db_string" line 27)
invoked from within
"db_string get_unconfirmed_hours $sql -default 0"
(procedure "get_unconfirmed_hours_for_period" line 20)
invoked from within
"get_unconfirmed_hours_for_period $current_user_id $start_date_julian_wf $end_date_julian_wf"
("uplevel" body line 265)
invoked from within
"uplevel {
# /packages/intranet-timesheet2/www/hours/index.tcl
#
# Copyright (C) 1998-2004 various parties
# The code is based on ArsDigita ACS 3.4
#
#…"
(procedure "code::tcl::/web/projop/packages/intranet-timesheet2/www/hour…" line 2)
invoked from within
"code::tcl::$__adp_stub"
("uplevel" body line 12)
invoked from within
"uplevel {
if { } {
# 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"
invoked from within
"template::adp_parse [file root ] {}"
(procedure "adp_parse_ad_conn_file" line 6)
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 "
(procedure "rp_serve_abstract_file" line 60)
invoked from within
"rp_serve_abstract_file "$root/$extra_url""
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"ad_try {
rp_serve_abstract_file "$root/$extra_url"
set tcl_url2file()
set tcl_url2path…"
Hi,
> Project Planning
Please update the package intranet-planning from CVS. The latest version includes an upgrade script /packages/intranet-planning/sql/postgresq/upgrade/upgrade-4.0.3.0.2-4.0.3.0.3.sql that you can execute using "psql -f …". This will fix the listed issue.
Hi Cmich,
> ERROR: function to_date(integer, unknown) does not exist
Please perform a CVS update of the /packages/intranet-timesheet2 to fix the issue.
Thanks for reporting!
Frank
bash-4.1$ psql -f upgrade-4.0.3.0.2-4.0.3.0.3.sql
psql:upgrade-4.0.3.0.2-4.0.3.0.3.sql:3: NOTICE: adding missing FROM-clause entry for table "acs_log_id_seq"
LINE 1: …ogs (log_id, log_level, log_key, message) values (acs_log_id…
^
QUERY: insert into acs_logs (log_id, log_level, log_key, message) values (acs_log_id_seq.nextval, 'debug', $1 , $2 )
CONTEXT: PL/pgSQL function "acs_log__debug" line 5 at SQL statement
acs_log__debug
0
(1 row)
CREATE FUNCTION
inline_0
0
(1 row)
DROP FUNCTION
CREATE FUNCTION
psql:upgrade-4.0.3.0.2-4.0.3.0.3.sql:70: ERROR: column "item_project_member_hourly_cost" does not exist
LINE 1: …r_id is not null and item_cost_type_id = 3736 and item_proje…
^
QUERY: select * from im_planning_items where item_project_member_id is not null and item_cost_type_id = 3736 and item_project_member_hourly_cost is null
CONTEXT: PL/pgSQL function "inline_0" line 4 at FOR over SELECT rows
DROP FUNCTION
CREATE FUNCTION
bash-4.1$
Any ideas on that error? I i try to run upgrade script for this through project open itself I get a server error 500.
Hi Cmich,
The issue should be fixed in CVS with an upgrade script in intranet-planning.
Please update and execute.
Cheers,
Frank