Forum .LRN Q&A: .lrn head installation
any idea, what it could be?
[12/Aug/2007:21:29:11][5851.3030846384][-conn:0-] Error: Ns_PgExec: result status: 7 message: ERROR: column u.oid does not exist
LINE 5: part.email, mr.rel_id, u.oid as row_id
^
[12/Aug/2007:21:29:11][5851.3030846384][-conn:0-] Warning: blank-compat: /home/openacs/openacs/packages/acs-admin/www/users/member-state-change.adp uses deprecated property title instead of doc(title).
[12/Aug/2007:21:29:11][5851.3030846384][-conn:0-] Warning: blank-compat: /home/openacs/openacs/packages/acs-admin/www/users/member-state-change.adp uses deprecated property header_stuff instead of head.
[12/Aug/2007:21:29:11][5851.3030846384][-conn:0-] Error: GET http://69.67.174.135:8090/acs-admin/users/member-state-change?member%5fstate=approved&return%5furl=%2fdotlrn%2fadmin%2fuser%2dnew%2d2%3freferer%3d%252fdotlrn%252f%26user%255fid%3d549&user%5fid=549
referred by "http://69.67.174.135:8090/acs-admin/users/member-state-change?member%5fstate=approved&return%5furl=%2fdotlrn%2fadmin%2fuser%2dnew%2d2%3freferer%3d%252fdotlrn%252f%26user%255fid%3d549&user%5fid=549";
Database operation "0or1row" failed
(exception ERROR, "ERROR: column u.oid does not exist
LINE 5: part.email, mr.rel_id, u.oid as row_id
^
")
while executing
"ns_pg_bind 0or1row nsdb0 {
select u.email_verified_p as email_verified_p_old,
mr.member_state as member_state_old,
per.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 0or1row $db $full_statement_name $sql"
invoked from within
"set selection [db_exec 0or1row $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 0or1row $db $full_statement_name $sql]
}"
(procedure "db_0or1row" line 50)
invoked from within
"db_0or1row get_states {
select email_verified_p as email_verified_p_old,
member_state as member_state_old,
first_names || ' ..."
("uplevel" body line 1)
(procedure "code::tcl::/home/openacs/openacs/packages/acs-admin/www/user..." line 1)
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"
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..."
contrary to the usual behaviour, the newest PostgreSQL default is to create the tables without the oid's and this explains the error you got.
You can recreate your database after setting the param into postgresql.conf or simply remove the oid column from the offending query, because its usage is not very important.