[Koha-bugs] [Bug 8027] New: Wrong order for parameters in Z39.50 SQL INSERT

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8027

          Priority: P5 - low
 Change sponsored?: ---
            Bug ID: 8027
          Assignee: adrien.saurat at biblibre.com
           Summary: Wrong order for parameters in Z39.50 SQL INSERT
          Severity: normal
    Classification: Unclassified
                OS: All
          Reporter: adrien.saurat at biblibre.com
          Hardware: All
            Status: ASSIGNED
           Version: master
         Component: Z39.50 / SRU / OpenSearch Servers
           Product: Koha

In the z3950servers.pl page, the INSERT for new servers is prepared like this :
===================================
INSERT INTO z3950servers
 (host,port,db,userid,password,name,checked,rank,syntax,encoding,timeout)
 VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
===================================

but then executed like this :
===================================
        $sth->execute(
            $input->param( 'host' ),
            $input->param( 'port' ),
            $input->param( 'db' ),
            $input->param( 'userid' ),
            $input->param( 'password' ),
            $input->param( 'searchfield' ),
            $checked,
            $input->param( 'rank' ),
            $input->param( 'syntax' ),
            $input->param( 'timeout' ),
            $input->param( 'encoding' ) );
    }
===================================

The last parameters, timeout and encoding, are not in the same order.

-- 
You are receiving this mail because:
You are watching all bug changes.