33 comentários

• Orzenil Silva Junior(usuário não autenticado)

  25 de Março de 2007, 14:16

   

  Iuri,

   dê uma olhada em

  www.​open​acs.​org/​foru​ms/m​essa​ge-v​iew?​mess​age_​id=9​2293​4

  caso deseje usar o patch não esqueça antes de realizar um backup dos seus dados. O upgrade vai mexer no banco de dados.

   

  
  

  • iuri sampaio(usuário não autenticado)

    1 de Abril de 2007, 4:10

     

    Orzenil,

    baixei organization0.6d3 de oacs-head e segui os passos do llink no bugstomp.
    www.​open​acs.​org/​bugt​rack​er/o​pena​cs/p​atch​?pat​ch_n​umbe​r=84​4
    . Estou com um erro de sql. Acredito que sejam valores passados como NULL que nao sao aceitos.

    alguma pista??             

     

     

    [01/Apr/2007:06:54:47][1092.114696][-conn:conaje::4] Error: Ns_PgExec: result status: 7 message: ERROR:  function organization__new("unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown") does not exist
    HINT:  No function matches the given name and argument types. You may need to add explicit type casts.

    [01/Apr/2007:06:54:50][1092.114696][-conn:conaje::4] Error: POST 72.2​49.3​8.15​0/do​tlrn​/clu​bs/a​c/or​gs_a​c/ad​d-ed​it?
    referred by "http://72.249.38.150/dotlrn/clubs/ac/orgs_ac/add-edit"
    Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

    ERROR:  function organization__new("unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown", "unknown") does not exist
    HINT:  No function matches the given name and argument types. You may need to add explicit type casts.

    SQL:
            select organization__new (
            'test',
            'test',
            'test',
            null,
            '2',
            'test',
            'test',
            'test',
            '508',
            '201.12.190.95',
            '6970'
            );

        while executing
    "ns_pg_bind 0or1row nsdb0 {
            select organization__new (
            :legal_name,
            :name,
            :notes,
            null,
            :org_type_id,
          ..."
        ("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
    "if {[regexp -nocase -- {^\s*select} $test_sql match]} {
                    # ns_log Debug "PLPGSQL: bypassed anon function"
                    set selection..."
        ("uplevel" body line 6)
            invoked from within
    "uplevel 1 $code_block "
        invoked from within
    "db_with_handle -dbn $dbn db {
                # plsql calls that are simple selects bypass the plpgsql
                # mechanism for creating anonymous fun..."
        (procedure "db_exec_plsql" line 57)
        invoked from within
    "db_exec_plsql do_insert_org { *SQL* }"
        invoked from within
    "set organization_id [db_exec_plsql do_insert_org { *SQL* }]"
        ("uplevel" body line 5)
        invoked from within
    "uplevel #$level $new_data"
        ("1" arm line 598)
        invoked from within
    "switch $errno {
                        0 {
                            # TCL_OK
                        }
                        1 {
                            # TCL_E..."
        (procedure "ad_form" line 612)
        invoked from within
    "ad_form -name org -form {
        organization_id:key
        {name:text
            {label "Name"}
        }
        {legal_name:text
            {label "Legal name"}
        }
    ..."
        ("uplevel" body line 41)
        invoked from within
    "uplevel {
    ad_page_contract {
        Simple add/edit form for organizations
    } {
        organization_id:integer,optional
        organization_type_id:integer,mult..."
        (procedure "code::tcl::/home/conaje/conaje/packages/organizations/www/ad..." 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 2)
        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 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..."

    
    

    • Orzenil Silva Junior(usuário não autenticado)

      2 de Abril de 2007, 20:14

       

      Iuri,

      que estranho.. testei novamente e não tive problema. O erro que vc relata mostra que o sistema não achou a função organization__new com os argumentos que vc passou.

      A função organization__new que criei no patch tem 12 argumentos e vc está chamando a função com 11 argumentos. Vc realizou o upgrade do pacote ou já instalou direto a versao 0.6d4 depois de aplicar o patch?