#232 Backup does not work

[Above]

I used the sample database, but deleted some records,
to try. Then I selected the
intranet/admin/backup/backup-2

command.

I get:

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

ERROR: syntax error at or near ")" at character 733

SQL:
select
p.*,
c.company_name,
parent_p.project_name as parent_name,
im_email_from_user_id(p.project_lead_id) as
project_lead_email,
im_email_from_user_id(p.supervisor_id) as
supervisor_email,
im_category_from_id(p.project_type_id) as
project_type,
im_category_from_id(p.project_status_id) as
project_status,
im_category_from_id(p.billing_type_id) as
billing_type,
to_char(p.end_date, 'YYYYMMDD HH24:MI') as
end_date_time,
to_char(p.start_date, 'YYYYMMDD HH24:MI') as
start_date_time
from
im_projects p,
im_projects parent_p,
im_companies c
where
p.company_id = c.company_id
and p.parent_id = parent_p.project_id(+)

while executing
"ns_pg_bind select nsdb1 {
select
p.*,
c.company_name,
parent_p.project_name as parent_name,
im_email_from_user_id(p.pr..."
("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 counter 0
while { [db_getrow $..."
(procedure "db_foreach" line 36)
invoked from within
"db_foreach projects_info_query $backup_sql {

\# Append a line of data based on

the "column_vars" parameter list
set row_ctr 0
foreach column_var $c..."
(procedure "im_backup_report" line 60)
invoked from within
"im_backup_report $view_id"
invoked from within
"set report [im_backup_report $view_id]"
("uplevel" body line 5)
invoked from within
"uplevel 1 $code_block "
("1" arm line 1)
invoked from within
"switch $errno {
0 {
# TCL_OK
}
1 {
# TCL_ERROR
..."
("while" body line 20)
invoked from within
"while { [db_getrow $db $selection] } {
incr counter
if { [info exists array_val] } {
unset array_val
..."
("uplevel" body line 5)
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 counter 0
while { [db_getrow $..."
(procedure "db_foreach" line 36)
invoked from within
"db_foreach foreach_report $sql {
ns_write "<li>Exporting $view_name ..."
ns_log Notice "backup-2: im_backup_report $view_id"

set report [..."
("uplevel" body line 71)
invoked from within
"uplevel {
# /packages/intranet-
core/www/admin/backup.tcl

ad_page_contract {
Changes all clients, users, prices etc to allow
to convert..."

(procedure "code::tcl::C:/ProjectOpen/projop/packages/in
tranet-core/www/..." 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..."

Ryszard Kasprzyk
English Polish translator
www.abovetranslations.com

[Frank Bergmann]

Logged In: YES
user_id=521421

Should fix with V3.0.0.2.4.

This type of backup is now deprecated in favour to a
PostgreSQL backup due to some extension that can't be
reasonably backed up this way.

V3.0.0.2.4 has this backup option disabled. The enabled one
should work fine for you.

Bests,
Frank