Grumet.Net
Begin main content

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..."