After changing the references of "rownum" to "limit" now I get this error message:
Database operation "dml" failed
while executing
"ns_db dml $db "drop function $function_name ()""
invoked from within
"db_exec_plpgsql $db $full_statement_name $sql $statement_name"
invoked from within
"if {[regexp -nocase -- {^s*select} $test_sql match]} {
ns_log Notice "PLPGSQL: bypassed anon function"
set selection [db_exec..."
("uplevel" body line 5)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle db {
# plsql calls that are simple selects bypass the plpgsql
# mechanism for creating anonymous functions (OpenACS - ..."
(procedure "db_exec_plsql" line 13)
invoked from within
"db_exec_plsql user_insert {
begin
:1 := acs.add_user(user_id => :user_id,
email => :email,
url => :url,
first_names => :first_names,..."
("uplevel" body line 2)
invoked from within
"uplevel 1 $transaction_code "
(procedure "db_transaction" line 1)
invoked from within
"db_transaction {
db_exec_plsql user_insert {
begin
:1 := acs.add_user(user_id => :user_id,
email => :email,
url => :url,
first_name..."
(procedure "ad_user_new" line 22)
invoked from within
"ad_user_new $email $first_names $last_name $password $password_question $password_answer"
invoked from within
"set user_id [ad_user_new $email $first_names $last_name $password $password_question $password_answer]"
("uplevel" body line 3)
invoked from within
"uplevel 1 $transaction_code "
(procedure "db_transaction" line 39)
invoked from within
"db_transaction {
set user_id [ad_user_new $email $first_names $last_name $password $password_question $password_answer]
if { !$user_id } ..."
invoked from within
"if { ![db_string user_exists {
select count(*) from parties where email = :email
}] } {
db_transaction {
set user_id [ad_user_new $ema..."
(file "/opt/aolserver/servers/server1/packages/acs-bootstrap-installer/installer/create-administrator-2.tcl" line 25)
invoked from within
"source $path"
And now I'm working on how to solve this.
There is any sugestion ?