• PHPBB3 Both the database and the directory containing it must be writable -- 含解题过程


    解题:我用的是SQLite数据库,原因是没有填对数据库路径,
    Database server name: /var/www/html/phpBB3/db

    解题过程:

    1.Google Both the database and the directory containing it must be writable
    发现 https://fossies.org/linux/phpBB/language/en/install.php中有以下内容
    'INST_ERR_DB_NO_WRITABLE' => 'Both the database and the directory containing it must be writable.',

    2.在安装包目录查找INST_ERR_DB_NO_WRITABLE

    grep -ir "INST_ERR_DB_NO_WRITABLE" phpBB3/*
    找到:/var/www/html/phpBB3/phpbb/install/helper/database.php

        // Check if SQLite database is writable
        if ($dbms_info['SCHEMA'] === 'sqlite'
            && (($this->filesystem->exists($dbhost) && !$this->filesystem->is_writable($dbhost)) || !$this->filesystem->is_writable(pathinfo($dbhost, PATHINFO_DIRNAME))))
        {
            $errors[] = array(
                'title' =>'INST_ERR_DB_NO_WRITABLE',
            );
        }

    就以为是填localhost,又以为是填localhost/phpBB3/db 都不对,虽然安装成功,到后面点击ACP访问管理后台时报错:

    General Error
    SQL ERROR [ sqlite3 ]
    no such table: phpbb_config [1]
    An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

    3.又Google no such table: phpbb_config 没有找到答案.

    4.再看database.php这段代码this->filesystem->is_writable($dbhost)
    灵机一动,dbhost应该是本地的一个路径,我在phpBB3里新建了一个db目录就可以了.
    安装时填写Database server name为/var/www/html/phpBB3/db

     5.大功告成:http://localhost/phpBB3/

     

  • 相关阅读:
    立方体
    file 图片预览
    [LeetCode][JavaScript]Single Number III
    [LeetCode][JavaScript]Longest Substring Without Repeating Characters
    [LeetCode][JavaScript]Missing Number
    [LeetCode][JavaScript]Course Schedule II
    [LeetCode][JavaScript]Course Schedule
    [LeetCode][JavaScript]Ugly Number II
    [LeetCode][JavaScript]Ugly Number
    [LeetCode][JavaScript]Single Number II
  • 原文地址:https://www.cnblogs.com/v5captain/p/14190794.html
Copyright © 2020-2023  润新知