Forum OpenACS Q&A: Error during change system time zone!

Collapse
Posted by Max Hermann on
Hi, just wanted to change system time zone, any idea? (suse, HEAD, postgres 7.2) Cheers
Request Error
Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR:  Unable to identify an operator '=' for types 'text' and 'integer'
	You will have to retype this query using an explicit cast

SQL: 
            select tz.tz, tz.gmt_offset
            from   timezones tz, 
                   timezone_rules tzr
            where  tzr.gmt_offset in (15300, -71100)
            and    tzr.tz_id = tz.tz_id
            and    to_date('2003-09-11 08:30:34', 'YYYY-MM-DD HH24:MI:SS') between tzr.utc_start and tzr.utc_end
            order  by tz
        
    while executing
"ns_pg_bind select nsdb0 {
            select tz.tz, tz.gmt_offset
            from   timezones tz, 
                   timezone_rules tzr
            ..."
    ("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 { value label selected_p } suggested_timezones select_suggested_timezones $query {
            set selected_p [string equal $tz $s..."
    ("uplevel" body line 29)
    invoked from within
"uplevel $body "
    ("uplevel" body line 1)
    invoked from within
"with_catch errmsg {
        set sysdate_utc_epoch [clock scan $sysdate_utc]
        set delta_hours [expr round(($sysdate_utc_epoch - $utc_epoch)*4.0 ..."
    invoked from within
"if { [info exists utc_epoch] } {
    with_catch errmsg {
        set sysdate_utc_epoch [clock scan $sysdate_utc]
        set delta_hours [expr round((..."
    ("uplevel" body line 72)
    invoked from within
"uplevel {
    	  # set-system-timezone.tcl
ad_page_contract {
  Set the acs-lang system parameter which says what the local timezone offset is
} {
   ..."
    (procedure "code::tcl::/web/web/packages/acs-lang/www/admin/set-s..." 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 7)
    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([ad_conn url]) [ad_conn path_inf..."
Collapse
Posted by Jon Griffin on
Upgrade to 7.3.4, I don't believe head will support 7.2 anyway.
Collapse
Posted by Lars Pind on
I think I have a fix in

packages/acs-lang/www/admin/set-system-timezone.tcl

I thought gmt_offset was integer, but it's text.

/Lars