I have done an install of ]po[ from the files on the ]Project Open[ web site. When I try and nuke the demo data I keep getting errors like:
Cleanup im_hours
Cleanup im_payments
Cleanup im_payments_audit
Cleanup dangeling_costs
Cleanup im_hours - set cost_id = null
Cleanup costs
. HTTP/1.1 500 Internal Server Error Server: AOLserver/4.5 MIME-Version: 1.0 Date: Tue, 14 Mar 2017 08:42:25 GMT Content-Type: text/html; charset=utf-8 Content-Length: 56224 Connection: close
Nuking user #9408 ...
... successful
Nuking user #9406 ...
The nuking of user 9406 failed. Probably this is because your installation of the ArsDigita Community System has been customized and there are new tables that reference the users table. Complain to your programmer!
For good measure, here's what the database had to say...
Database operation "dml" failed
(exception ERROR, "ERROR: missing FROM-clause entry for table "timespan_seq"
LINE 1: select timespan_seq.nextval from dual
^
QUERY: select timespan_seq.nextval from dual
CONTEXT: PL/pgSQL function time_interval__new(timestamp with time zone,timestamp with time zone) line 7 at SQL statement
PL/pgSQL function timespan__new(timestamp with time zone,timestamp with time zone) line 12 at RETURN
PL/pgSQL function im_forum_topics_calendar_update_tr() line 27 at assignment
")
pqerror was: "ERROR: missing FROM-clause entry for table "timespan_seq"
LINE 1: select timespan_seq.nextval from dual
^
QUERY: select timespan_seq.nextval from dual
CONTEXT: PL/pgSQL function time_interval__new(timestamp with time zone,timestamp with time zone) line 7 at SQL statement
PL/pgSQL function timespan__new(timestamp with time zone,timestamp with time zone) line 12 at RETURN
PL/pgSQL function im_forum_topics_calendar_update_tr() line 27 at assignment
"
(Status of PQexec call: PGRES_FATAL_ERROR)
SQL: update im_forum_topics set owner_id = '624' where owner_id = '9406'
Nuking office #27003 ...
Database operation "dml" failed (exception ERROR, "ERROR: update or delete on table "im_offices" violates foreign key constraint "im_companies_office_fk" on table "im_companies" DETAIL: Key (office_id)=(27003) is still referenced from table "im_companies". ") pqerror was: "ERROR: update or delete on table "im_offices" violates foreign key constraint "im_companies_office_fk" on table "im_companies" DETAIL: Key (office_id)=(27003) is still referenced from table "im_companies". " (Status of PQexec call: PGRES_FATAL_ERROR) SQL: delete from im_offices where office_id = '27003'
I reinstalled everything from scratch again, and did a minimal install. Again the nuke crashed whe cleaning up costs. If there anything I need to be doing?
Also on the installs with I tried to add the two lines:
add_missing_from = on
regex_flavor = extended
to the /var/lib/pgsql/data/postgresql.conf file, postgresql would not start up. When these two lines are removed postgresql starts. Not sure if this is what is causing my problems.
Greg
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
]project-open[ V4.0.4.
Running on CentOS 7, with the latest Postgresql etc.
I know you have a VM appliance, but that is for the desktop VM Server, for you have the VM for ESXi 5.5 Server?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Frank, I think I found the issue... I was running CentOS7 with gives me PostgreSQL 9. I see there is a not that Project Open 4.04 does not work on PG9, but on PG8. This explains a lot of the little issues I was having. I did follow your instuctions on the [Project Open[ site and just missed the part where you said does not work on Postgresql 9. Might I offer a little suggestion, put that in a BOLD point at the begining of the install like: ***NOTE ]Project Open[ 4.04 will not work on Postgresql 9.***
Reinstalling under Centos 6 with Postgresql 8. Will advise if all the problems are fixed.
Also is there much call for an ESXi VMWare version on your package? If it would help I would be more than happy to create a base machine and upload it to you.
Greg
Last edit: Gregory West 2017-03-16
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
]project-open[ V5.0.Beta4 is available for download as a VMware appliance here in the "Files" section. Please go for that. You'll even get some priority Beta support, OK?
OK, sounds good, I can test this out on CentOS 7, under VM ESXi 5.5. Should I start from the install of 4.04 and upgrade, or better to test all the steps in setting up a new ]PO[ from scratch on a clean OS?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I ran through the steps to create a 5.0 Project Open. Seems to go OK until this line:
psql -f projop.sql > import.log 2>&1
I looks like it fails there. The return is less than 1/2 second. Also I can not find the file projop.sql anywhere. Where should it be, and what file should it have been downloaded in?
Greg
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
set query "
select
p.,
u.,
pa.*,
p.person_id as sort_order,
im_name_from_user_id(p.person_id) as user_name
from
persons p,
parties pa,
users u
where
p.person_id = pa.party_id
and p.person_id = u.user_id
and demo_password is not null
order by
sort_order,
u.user_id
LIMIT 20
"
set old_demo_group ""
db_multirow -extend {view_url} users users_query $query {
set view_url ""
}
# ------------------------------------------------------ # Get current user email**
set current_user_id [ad_conn untrusted_user_id]
set username $username_org
set email $email_org
if {"" == $email} {
set email [db_string email "
select email
from parties
where party_id = :current_user_id and party_id > 0
" -default ""]
}
if {"" == $username} {
set username [db_string username "
select username
from users
where user_id = :current_user_id and user_id > 0
" -default ""]
}
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have done an install of ]po[ from the files on the ]Project Open[ web site. When I try and nuke the demo data I keep getting errors like:
Cleanup im_hours
Cleanup im_payments
Cleanup im_payments_audit
Cleanup dangeling_costs
Cleanup im_hours - set cost_id = null
Cleanup costs
. HTTP/1.1 500 Internal Server Error Server: AOLserver/4.5 MIME-Version: 1.0 Date: Tue, 14 Mar 2017 08:42:25 GMT Content-Type: text/html; charset=utf-8 Content-Length: 56224 Connection: close
Nuking user #9408 ...
... successful
Nuking user #9406 ...
The nuking of user 9406 failed. Probably this is because your installation of the ArsDigita Community System has been customized and there are new tables that reference the users table. Complain to your programmer!
For good measure, here's what the database had to say...
Database operation "dml" failed (exception ERROR, "ERROR: missing FROM-clause entry for table "timespan_seq" LINE 1: select timespan_seq.nextval from dual ^ QUERY: select timespan_seq.nextval from dual CONTEXT: PL/pgSQL function time_interval__new(timestamp with time zone,timestamp with time zone) line 7 at SQL statement PL/pgSQL function timespan__new(timestamp with time zone,timestamp with time zone) line 12 at RETURN PL/pgSQL function im_forum_topics_calendar_update_tr() line 27 at assignment ") pqerror was: "ERROR: missing FROM-clause entry for table "timespan_seq" LINE 1: select timespan_seq.nextval from dual ^ QUERY: select timespan_seq.nextval from dual CONTEXT: PL/pgSQL function time_interval__new(timestamp with time zone,timestamp with time zone) line 7 at SQL statement PL/pgSQL function timespan__new(timestamp with time zone,timestamp with time zone) line 12 at RETURN PL/pgSQL function im_forum_topics_calendar_update_tr() line 27 at assignment " (Status of PQexec call: PGRES_FATAL_ERROR) SQL: update im_forum_topics set owner_id = '624' where owner_id = '9406'Nuking office #27003 ...
Database operation "dml" failed (exception ERROR, "ERROR: update or delete on table "im_offices" violates foreign key constraint "im_companies_office_fk" on table "im_companies" DETAIL: Key (office_id)=(27003) is still referenced from table "im_companies". ") pqerror was: "ERROR: update or delete on table "im_offices" violates foreign key constraint "im_companies_office_fk" on table "im_companies" DETAIL: Key (office_id)=(27003) is still referenced from table "im_companies". " (Status of PQexec call: PGRES_FATAL_ERROR) SQL: delete from im_offices where office_id = '27003'
I reinstalled everything from scratch again, and did a minimal install. Again the nuke crashed whe cleaning up costs. If there anything I need to be doing?
Also on the installs with I tried to add the two lines:
add_missing_from = on
regex_flavor = extended
to the /var/lib/pgsql/data/postgresql.conf file, postgresql would not start up. When these two lines are removed postgresql starts. Not sure if this is what is causing my problems.
Greg
Which version exactly?
]project-open[ V4.0.4.
Running on CentOS 7, with the latest Postgresql etc.
I know you have a VM appliance, but that is for the desktop VM Server, for you have the VM for ESXi 5.5 Server?
Frank, I think I found the issue... I was running CentOS7 with gives me PostgreSQL 9. I see there is a not that Project Open 4.04 does not work on PG9, but on PG8. This explains a lot of the little issues I was having. I did follow your instuctions on the [Project Open[ site and just missed the part where you said does not work on Postgresql 9. Might I offer a little suggestion, put that in a BOLD point at the begining of the install like: ***NOTE ]Project Open[ 4.04 will not work on Postgresql 9.***
Reinstalling under Centos 6 with Postgresql 8. Will advise if all the problems are fixed.
Also is there much call for an ESXi VMWare version on your package? If it would help I would be more than happy to create a base machine and upload it to you.
Greg
Last edit: Gregory West 2017-03-16
Hi Greg,
]project-open[ V5.0.Beta4 is available for download as a VMware appliance here in the "Files" section. Please go for that. You'll even get some priority Beta support, OK?
Checkout: http://www.project-open.com/en/install-rhel-7
Let's keep discussing here. You'll get prio Beta support...
Cheers,
Frank
OK, sounds good, I can test this out on CentOS 7, under VM ESXi 5.5. Should I start from the install of 4.04 and upgrade, or better to test all the steps in setting up a new ]PO[ from scratch on a clean OS?
Frank did you know this link for the third file (which I assume is important) does not work....
http://sourceforge.net/projects/project-open/files/project-open/V5.0/project-open-Update-5.0.0.0.0.tgz
Thanks!
Just take any file from the "nightly builds" folder.
Also, just search google for "project-open cvs checkout", in order to see how to get the source code directly from our CVS repository.
... or just copy the /web/projop/packages/ folder form the 5.0.beta4 VMware...
Cheers,
Frank
Last edit: Frank Bergmann 2017-03-16
I ran through the steps to create a 5.0 Project Open. Seems to go OK until this line:
psql -f projop.sql > import.log 2>&1
I looks like it fails there. The return is less than 1/2 second. Also I can not find the file projop.sql anywhere. Where should it be, and what file should it have been downloaded in?
Greg
Good morning. I did a test load of project open. So far all i get is a screen full of code when i call up the web page
Hi,
When starting ]po[, or when nuking? Can you please pase the first 40 lines of the code here in the forum?
Thanks!
Frank
Good morning Frank, this is the code I get when I go into ]po[ 5.0. The install followed the instructions on the ]po[ site.
ad_page_contract {
Prompt the user for email and password.
@cvs-id $Id: index.tcl,v 1.11 2007/11/30 01:57:58 podesign Exp $
} {
{authority_id ""}
{username ""}
{email ""}
{return_url "/intranet/"}
}
set email_org $email
set username_org $username
------------------------------------------------------
Multirow
Users defined in the database
------------------------------------------------------
set query "
select
p.,
u.,
pa.*,
p.person_id as sort_order,
im_name_from_user_id(p.person_id) as user_name
from
persons p,
parties pa,
users u
where
p.person_id = pa.party_id
and p.person_id = u.user_id
and demo_password is not null
order by
sort_order,
u.user_id
LIMIT 20
"
set old_demo_group ""
db_multirow -extend {view_url} users users_query $query {
set view_url ""
}
# ------------------------------------------------------
# Get current user email**
set current_user_id [ad_conn untrusted_user_id]
set username $username_org
set email $email_org
if {"" == $email} {
set email [db_string email "
select email
from parties
where party_id = :current_user_id and party_id > 0
" -default ""]
}
if {"" == $username} {
set username [db_string username "
select username
from users
where user_id = :current_user_id and user_id > 0
" -default ""]
}