Empty strings in search.php

[andersonwinkler]

We're getting this error when trying to download:

SQL error occured

Query failed on [Sat, 26 May 2018 11:09:20 -0400]: /var/www/html/search.php (line 4778)
Error: Incorrect integer value: '' for column 'req_downloadbeh' at row 1
SQL: insert into data_requests (req_username, req_ip, req_groupid, req_modality, req_downloadimaging, req_downloadbeh, req_downloadqc, req_destinationtype, req_nfsdir, req_seriesid, req_filetype, req_gzip, req_anonymize, req_preserveseries, req_dirformat, req_timepoint, req_ftpusername, req_ftppassword, req_ftpserver, req_ftpport, req_ftppath, req_nidbserver, req_nidbusername, req_nidbpassword, req_nidbinstanceid, req_nidbsiteid, req_nidbprojectid, req_downloadid, req_behonly, req_behformat, req_behdirrootname, req_behdirseriesname, req_date) values ('guest', [REDACTED], 1, 'mr', '1', '', '', 'nfs', [REDACTED], 7197, 'nifti4d', '', '1', '0', 'datetimeshortid', '', '', '', '', '21', '', '', '', '', '' , '', '', '', '', 'behnone', 'beh','beh', now())
Username: guest
SESSION
Array
(
    [enablebeta] => 0
    [username] => guest
    [validlogin] => true
    [isadmin] => false
    [instanceid] => 1
    [instancename] => Main
)

SERVER
Array
(
    [UNIQUE_ID] => [REDACTED]
    [HTTPS] => on
    [SSL_TLS_SNI] => [REDACTED]
    [HTTP_HOST] => [REDACTED]
    [CONTENT_TYPE] => application/x-www-form-urlencoded
    [HTTP_ORIGIN] => [REDACTED]
    [HTTP_ACCEPT_ENCODING] => br, gzip, deflate
    [HTTP_COOKIE] => [REDACTED]
    [HTTP_CONNECTION] => keep-alive
    [HTTP_ACCEPT] => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    [HTTP_USER_AGENT] => Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_4) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/11.1 Safari/605.1.15
    [HTTP_REFERER] => [REDACTED]/search.php
    [CONTENT_LENGTH] => 441
    [HTTP_ACCEPT_LANGUAGE] => en-us
    [PATH] => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
    [SERVER_SIGNATURE] => 
    [SERVER_SOFTWARE] => Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.2k-fips PHP/7.2.4 mod_apreq2-20090110/2.8.0 mod_perl/2.0.10 Perl/v5.16.3
    [SERVER_NAME] => [REDACTED]
    [SERVER_ADDR] => [REDACTED]
    [SERVER_PORT] => 443
    [REMOTE_ADDR] => [REDACTED]
    [DOCUMENT_ROOT] => /var/www/html
    [REQUEST_SCHEME] => https
    [CONTEXT_PREFIX] => 
    [CONTEXT_DOCUMENT_ROOT] => /var/www/html
    [SERVER_ADMIN] => [REDACTED]
    [SCRIPT_FILENAME] => /var/www/html/search.php
    [REMOTE_PORT] => 62166
    [GATEWAY_INTERFACE] => CGI/1.1
    [SERVER_PROTOCOL] => HTTP/1.1
    [REQUEST_METHOD] => POST
    [QUERY_STRING] => 
    [REQUEST_URI] => /search.php
    [SCRIPT_NAME] => /search.php
    [PHP_SELF] => /search.php
    [REQUEST_TIME_FLOAT] => 1527347360.864
    [REQUEST_TIME] => 1527347360
)

POST
Array
(
    [modality] => mr
    [action] => submit
    [seriesid] => Array
        (
            [0] => 7197
        )

    [destination] => nfs
    [nfsdir] => [REDACTED]
    [remoteftpserver] => 
    [remoteftppath] => 
    [remoteftpusername] => 
    [remoteftppassword] => 
    [remoteftpport] => 21
    [remoteconnid] => 
    [downloadimaging] => 1
    [subjectphenotype] => 1
    [subjectforms] => 1
    [studydata] => 1
    [seriesdata] => 1
    [filetype] => nifti4d
    [anonymize] => 1
    [dirformat] => datetimeshortid
    [preserveseries] => 0
    [behformat] => behrootdir
    [behdirnameroot] => beh
    [behdirnameseries] => beh
    [download] => Download
)

GET
Array
(
)

Depending on the choices on the form, this can happen with 'req_downloadbeh', 'req_downloadqc', 'req_gzip', 'req_timepoint', among others. Thanks!

[gbook]

Schema and search.php updated.