dbispconfig table, Undefined index: where_clause

Discussion in 'Installation/Configuration' started by Taleman, Feb 22, 2021.

  1. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Using PHPMyAdmin, browse dbispconfig table web_domain pops up window. PHPMyAdmin Version information: 4.6.6deb4+deb9u2
    Somewhat hard to cut and paste from the window, the messages disappear if I close that popup window.
    Code:
    Notice in ./libraries/DisplayResults.php#5320
     Undefined index: where_clause
    
    Backtrace
    
    ./libraries/DisplayResults.php#4584: PMA\libraries\DisplayResults->_handleNonPrintableContents(
    string 'blob',
    string 'upload_max_filesize = 64M',
    string 'PMA_mimeDefaultFunction',
    array,
    string 'PMA_mimeDefaultFunction',
    ,
    )
    ./libraries/DisplayResults.php#4318: PMA\libraries\DisplayResults->_getSortedColumnMessage(
    ,
    string '`custom_php_ini`',
    )
    ./libraries/sql.lib.php#1689: PMA\libraries\DisplayResults->getTable(

    Code:
    Notice in ./libraries/DisplayResults.php#5320
     Undefined index: where_clause
    
    Backtrace
    
    ./libraries/DisplayResults.php#4610: PMA\libraries\DisplayResults->_handleNonPrintableContents(
    string 'blob',
    I have tried repair table, for that table and all tables in dbispconfig. Does not change the situation.
    What is this, and how to fix?
    Code:
    ##### SERVER #####
    IP-address (as per hostname): ***.***.***.***
    [WARN] could not determine server's ip address by ifconfig
    [INFO] OS version is Debian GNU/Linux 9.13 (stretch)
    
    [INFO] uptime:  20:20:27 up 2 days, 11:32,  1 user,  load average: 1,14, 1,76, 1,58
    
    [INFO] memory:
                  total        used        free      shared  buff/cache   available
    Mem:            15G        3,8G        331M        2,0G         11G        9,5G
    Swap:          2,0G         18M        1,9G
    
    [INFO] ISPConfig is installed.
    
    ##### ISPCONFIG #####
    ISPConfig version is 3.1.15p3
    
    
    ##### VERSION CHECK #####
    
    [INFO] php (cli) version is 7.0.33-38+0~20210112.44+debian9~1.gbpab637c
    
    ##### PORT CHECK #####
    
    [WARN] Port 143 (IMAP server) seems NOT to be listening
    [WARN] Port 993 (IMAP server SSL) seems NOT to be listening
    [WARN] Port 110 (POP3 server) seems NOT to be listening
    [WARN] Port 995 (POP3 server SSL) seems NOT to be listening
    [WARN] Port 465 (SMTP server SSL) seems NOT to be listening
    
    ##### MAIL SERVER CHECK #####
    
    [WARN] I found no "submission" entry in your postfix master.cf
    [INFO] this is not critical, but if you want to offer port 587 for smtp connections you have to enable this.
    [WARN] I found no "smtps" entry in your postfix master.cf
    [INFO] this is not critical, but if you want to offer SSL for smtp (not TLS) connections you have to enable this.
    
    ##### RUNNING SERVER PROCESSES #####
    
    [INFO] I found the following web server(s):
        Apache 2 (PID 16477)
    [INFO] I found the following mail server(s):
        Postfix (PID 1576)
    [WARN] I could not determine which pop3 server is running.
    [WARN] I could not determine which imap server is running.
    [INFO] I found the following ftp server(s):
        PureFTP (PID 2008)
    
    ##### LISTENING PORTS #####
    (only        ()
    Local        (Address)
    [localhost]:11211        (1098/memcached)
    [anywhere]:111        (1001/rpcbind)
    [anywhere]:21        (2008/pure-ftpd)
    [anywhere]:22        (1133/sshd)
    [localhost]:25        (1576/master)
    *:*:*:*::*:3306        (1407/mysqld)
    [localhost]11        (1001/rpcbind)
    *:*:*:*::*:80        (16477/apache2)
    *:*:*:*::*:8080        (16477/apache2)
    *:*:*:*::*:8081        (16477/apache2)
    *:*:*:*::*:21        (2008/pure-ftpd)
    *:*:*:*::*:22        (1133/sshd)
    *:*:*:*::*:25        (1576/master)
    *:*:*:*::*:443        (16477/apache2)
    
    
    
    
    ##### IPTABLES #####
    Chain INPUT (policy ACCEPT)
    target     prot opt source               destination         
    f2b-recidive  tcp  --  [anywhere]/0            [anywhere]/0           
    f2b-postfix-sasl  tcp  --  [anywhere]/0            [anywhere]/0            multiport dports 25
    f2b-dovecot  tcp  --  [anywhere]/0            [anywhere]/0            multiport dports 110,995,143,993,587,465,4190
    f2b-pure-ftpd  tcp  --  [anywhere]/0            [anywhere]/0            multiport dports 21
    f2b-php-url-fopen  tcp  --  [anywhere]/0            [anywhere]/0            multiport dports 80,443
    f2b-apache-noscript  tcp  --  [anywhere]/0            [anywhere]/0            multiport dports 80,443
    f2b-sshd   tcp  --  [anywhere]/0            [anywhere]/0            multiport dports 22
    
    Chain FORWARD (policy ACCEPT)
    target     prot opt source               destination         
    
    Chain OUTPUT (policy ACCEPT)
    target     prot opt source               destination         
    
    Chain f2b-apache-noscript (1 references)
    target     prot opt source               destination         
    REJECT     all  --  ***.***.***.***       [anywhere]/0            reject-with icmp-port-unreachable
    RETURN     all  --  [anywhere]/0            [anywhere]/0           
    
    Chain f2b-dovecot (1 references)
    target     prot opt source               destination         
    RETURN     all  --  [anywhere]/0            [anywhere]/0           
    
    Chain f2b-php-url-fopen (1 references)
    target     prot opt source               destination         
    RETURN     all  --  [anywhere]/0            [anywhere]/0           
    
    Chain f2b-postfix-sasl (1 references)
    target     prot opt source               destination         
    RETURN     all  --  [anywhere]/0            [anywhere]/0           
    
    Chain f2b-pure-ftpd (1 references)
    target     prot opt source               destination         
    REJECT     all  --  ***.***.***.***        [anywhere]/0            reject-with icmp-port-unreachable
    RETURN     all  --  [anywhere]/0            [anywhere]/0           
    
    Chain f2b-recidive (1 references)
    target     prot opt source               destination         
    REJECT     all  --  ***.***.***.***       [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***        [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***         [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***        [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***       [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***         [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***       [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***          [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***       [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***        [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***          [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***        [anywhere]/0            reject-with icmp-port-unreachable
    
     
    Last edited: Feb 22, 2021
  2. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    In PMA, it is shown which PHP version is used. Could you check this?
     
  3. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Check #1 again, I had wrong paste of htf_report.txt.
    PHPMyAdmin:
    • PHP version: 7.0.33-38+0~20210112.44+debian9~1.gbpab637c
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    It's not an issue in the ISPConfig database, it is an (uncritical) issue in phpmyadmin (PHP notice level), but this seems to throw an error with backtrace on your system. Did you maybe altered php error reporting settings?
     
  5. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    I may have some time ago. But for one website, and I checked just now and I have undone the error reporting settings.
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    And did the error go away in phpmyadmin after undoing the change? If you need different settings for a specific site, then you can set them in php.ini directives field on the options tab of that website.
     
  7. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    I have not managed to get rid of the notice messages. I'm migrating away from this server soon, so I'll just ignore the problem and try to examine the contents of that table my other means.
     

Share This Page