Forum OpenACS Q&A: Re: Upgrade Problem from 5.4 to 5.5

Collapse
Posted by Nima Mazloumi on
Also on server start I get the following error:

[11/Nov/2009:20:42:06][12527.1549695744][-main-] Error: Ns_PgExec: result status: 7 message: FEHLER: Datentyp text hat keine Standardoperatorklasse für Zugriffsmethode »gist«
HINT: Sie müssen für den Index eine Operatorklasse angeben oder eine Standardoperatorklasse für den Datentyp definieren.

[11/Nov/2009:20:42:06][12527.1549695744][-main-] Error: Error sourcing /www/dotlrn-2.5.0/packages/xowiki/tcl/xowiki-procs.tcl:
Database operation "dml" failed
(exception ERROR, "FEHLER: Datentyp text hat keine Standardoperatorklasse für Zugriffsmethode »gist«
HINT: Sie müssen für den Index eine Operatorklasse angeben oder eine Standardoperatorklasse für den Datentyp definieren.
")

while executing
"ns_pg_bind dml nsdb0 {create index xowiki_page_page_order_idx ON xowiki_page using gist (page_order)}"
("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 dml $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 {
db_exec dml $db $full_statement_name $sql
}"
(procedure "db_dml" line 100)
invoked from within
"db_dml [my qn create-index-$name] "create $uniquepart index $name ON $table $using ($col)""
(procedure "index" line 12)
::xo::db::require->index
invoked from within
"::xo::db::require index -table xowiki_page -col page_order -using [expr {[::xo::db::has_ltree] ? "gist" : ""}]"
(in namespace eval "::xowiki" script line 94)
invoked from within
"namespace eval ::xowiki {
#
# create classes for different kind of pages
#
::xo::db::CrClass create Page -superclass ::xo::db::CrItem \
..."
(file "/www/dotlrn-2.5.0/packages/xowiki/tcl/xowiki-procs.tcl" line 9)
invoked from within
"source $__file "