There was a server error processing your request. We apologize.
Take me back where I was (before the error)
Database operation "select" failed (exception ERROR, "ERROR: subquery in FROM must have an alias LINE 2: select * from ( ^ HINT: For example, FROM (SELECT ...) [AS] foo. ") ERROR: subquery in FROM must have an alias LINE 2: select * from ( ^ HINT: For example, FROM (SELECT ...) [AS] foo. SQL: select * from ( select title, original_url, decode(when_published,null,0,1) as published_p, guid from ptv_items where live_p = 't' order by when_added desc ) where rownum < 16 while executing "ns_pg_bind select nsdb0 { select * from ( select title, original_url, decode(when_published,null,0,1) as published_p, guid from ptv_items ..." ("uplevel" body line 1) invoked from within "uplevel $ulevel [list ns_pg_bind $type $db $sql]" invoked from within "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 result [list] while { [db_getro..." (procedure "db_list_of_lists" line 27) invoked from within "db_list_of_lists q { select * from ( select title, original_url, decode(when_published,null,0,1) as published_p, guid from ptv_items where..." ("uplevel" body line 113) invoked from within "uplevel { ad_page_contract {} { {url:optional,trim ""} {title:optional,trim ""} {description:optional,trim ""} {more_url:option..." (procedure "code::tcl::/app/www.grumet.net/www/ptv/add" line 2) invoked from within "code::tcl::$__adp_stub" ("uplevel" body line 12) 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 6) 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/$extra_url"" ("uplevel" body line 2) invoked from within "uplevel $code" invoked from within "ad_try { rp_serve_abstract_file "$root/$extra_url" set tcl_url2file([ad_conn url]) [ad_conn file] set tcl_url2path..."