尝试安装Loganalyzer 4.1.5时出现PHP错误

Question

我成功地测试了向它发送syslog消息，并且可以看到数据库到目前为止正在收集这些消息。我还成功地测试了php可以连接到我为rsyslog设置的数据库

    <?php
    $link = mysqli_connect("{host}", "{user}", "{password}", "{database}");

    if (!$link) {
        echo "Error: Unable to connect to MySQL." . PHP_EOL;
        echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
        echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
        exit;
    }

    echo "Success: A proper connection to MySQL was made!." . PHP_EOL;
    echo "Host information: " . mysqli_get_host_info($link) . PHP_EOL;

    mysqli_close($link);
    ?>

然后，我从命令行php-fdb-test.php运行这个命令，它似乎起作用了。

我的问题似乎是在运行Loganalyzer install.php文件时出现的。

[Mon Dec 12 15:23:21.563908 2016] [:error] [pid 1400] [client {ip}:50958] PHP Warning:  mysqli_select_db() expects parameter 1 to be mysqli, string given in /var/www/html/loganalyzer/install.php on line 382, referer: http://{ip}/loganalyzer/install.php?step=3

    >>> this is the line from install.php
        // Try to select the DB!
                                $db_selected = mysqli_select_db($_SESSION['UserDBName'], $link_id);
                                if(!$db_selected)
                                        RevertOneStep( $content['INSTALL_STEP']-1, GetAndReplaceLangStr( $content['LN_INSTALL_ERRORACCESSDENIED'], $_SESSION['UserDBName']) . "<br>" . DB_ReturnSimpleErrorMsg());


[Mon Dec 12 15:23:21.563997 2016] [:error] [pid 1400] [client {IP}:50958] PHP Warning:  mysqli_errno() expects parameter 1 to be mysqli, integer given in /var/www/html/loganalyzer/include/functions_db.php on line 215, referer: http://{ip}/loganalyzer/install.php?step=3
[Mon Dec 12 15:23:21.564013 2016] [:error] [pid 1400] [client {IP}:50958] PHP Warning:  mysqli_error() expects parameter 1 to be mysqli, integer given in /var/www/html/loganalyzer/include/functions_db.php on line 215, referer: http://{ip}/loganalyzer/install.php?step=3

    >>>> this is the line from functions_db.php
        // Return Mysql Error
                return "Mysql Error " . mysqli_errno($userdbconn) . " - Description: " . mysqli_error($userdbconn);
}

我已经把头撞到墙上有一阵子了。谁能给我指个正确的方向吗？

Answer 1

mysql_select_db的参数似乎错误，应该是mysqli_select_db(mysqli$link,string$dbname)。

因此，将该行更改为$db_selected=mysqli_select_db($link_id,$_session['userdbname'])；应该可以纠正该错误。

我还将检查$userdbconn和$link_id的设置位置。mysqli_errno()当前传递的连接无效。