Forum OpenACS Development: problems with news in 4.5

Collapse
Posted by Rafael Calvo on
I started from scratch, new DB and code from CVS:
cvs -d:pserver:anonymous@openacs.org:/cvsroot update -r oacs-4-5
-d packages packages
Tryingto create a news item I get, pressing confirm in "news/preview" gives me:
Database operation "0or1row" failed (exception NSDB, "Query was
not a statement returning rows.")
           while executing
       "ns_pg_bind 0or1row nsdb0 {

           select news__new(
               null,               -- p_item_id
               null,               -- p_locale
               :publish_da..."
           ("uplevel" body line 1)
           invoked from within
       "uplevel $ulevel [list ns_pg_bind $type $db $sql"
           invoked from within
       "db_exec 0or1row $db $full_statement_name $sql"
           invoked from within
       "if {[regexp -nocase -- {^s*select} $test_sql match]} {
                   db_qd_log Debug "PLPGSQL: bypassed anon function"
                   set selection [db_ex..."
           ("uplevel" body line 6)
           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 create_news_item "
       begin
       :1 := news.new(
       title           => :publish_title,
       publish_date    => :publish_date_ansi, 
       archive_date    => :..."
           invoked from within
       "set news_id [db_exec_plsql create_news_item "
       begin
       :1 := news.new(
       title           => :publish_title,
       publish_date    => :publish_date_ansi, 
       archive..."
           ("uplevel" body line 76)
           invoked from within
       "uplevel {
                 # /packages/news/www/item-create-3.tcl

       ad_page_contract {

           Final insert into database to create a news item
           (no double-click..."
           (procedure
"code::tcl::/web/weg1/packages/news/www/item-create-3" line 2)
           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 3)
           invoked from within
       "adp_prepare "
           (procedure "template::adp_parse" line 30)
           invoked from within
       "template::adp_parse [file root [ad_conn file]] {}"
           (procedure "adp_parse_ad_conn_file" line 7)
           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([ad_conn url]) [ad_conn
path_inf..."
Is anyone having this problem?
I am not sure if this "bug reporting should go here or the OACS testing bboard, but that one seems less active.
Collapse
Posted by Tom Jackson on

You need to post the first error in the server.log file, usually called something like servicename-errors.log. The above error report is not very helpful.

Collapse
Posted by Don Baccus on
Weird ... I got a problem but for a different reason, the package as written had some bad checks for file vs. text.

And it is fundamentally stupid as it assumes an uploaded file is a Word document.  Upload a JPEG and it is returned as the Word mime type!

How depressing ...

Other than these interesting characteristics it works fine, though.

Collapse
Posted by Rafael Calvo on
well, I installed from the nightly tar ball (march 12) and everything is fine. This and the problem in bboard I reported on another thread