I was trying to install contacts packages and I've got an error message on the installation process.
************************
************************
Installing packages...
Installing Organization 0.5d2
Installing data model for Organization 0.5d2...
Loading data model /home/yabtdev/yabtdev/packages/organizations/sql/postgresql/organizations-create.sql...
Failed to install Organization, version 0.5d2. The following error was generated:
couldn't execute "psql": no such file or directory
NOTE: If the error comes from a sql script you may try to source it manually. When you are done with that you should revisit the APM and try again but remember to leave the manually souced sql scipts unchecked on the previous page.
****************************
****************************
Then I went back to the previous page and un-check the boxes. Which gave me the installation process ok:
So,I’ve just installed and I’m trying to figure out how to use the package. But now it seems it is missing a table called contacts.
Ps. I've tryed on both version OACS-5-1 and OACS-5-2
The message is right bellow. Do you ha ve any idea what did go wrong?
best,
iuri
Server Error
/ home / yabtdev / yabtdev / packages / dotlrn / www / dotlrn-master-kelp
There was a server error processing your request. We apologize.
Take me back where I was (before the error)
Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")
ERROR: relation "contacts" does not exist
SQL:
select contacts.*, sort_first_names as contact_name
from contacts
where party_id is not null
and upper(sort_first_names) like upper('%')
and upper(sort_first_names) like upper('%%')
and status = 'current'
order by contacts.sort_first_names asc, contacts.object_type desc, contacts.email desc
limit 20 offset 0
while executing
"ns_pg_bind select nsdb0 {
select contacts.*, sort_first_names as contact_name
from contacts
where party_id is not null
and upper(sort_first_..."
("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 select $db $full_statement_name $sql"
invoked from within
"set selection [db_exec select $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 [db_exec select $db $full_statement_name $sql]
set local_counter 0
# Make sure 'n..."
(procedure "db_multirow" line 40)
invoked from within
"db_multirow -extend { contact_url email_url object_type_pretty } -unclobber entries get_contact_info {} {
set contact_url "view/$party_id"
if ..."
("uplevel" body line 240)
invoked from within
"uplevel {
ad_page_contract {
@author Matthew Geddert mailto:openacs@geddert.com
@creation-date 2004-07-28
@cvs-id $Id: index.tcl,v 1.1.2.3 2004..."
(procedure "code::tcl::/home/yabtdev/yabtdev/packages/contacts/www/index" 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..."
