Tieba-Cloud-Sign 无法向数据库写入

使用安装向导安装完成后可以正常访问，但只能从数据库读取，无法写入数据库（保存设置和添加帐号所产生的更改都不会生效）下面是我在保持设置时产生的数据库的日志 `

<pma_xml_export version="1.0" xmlns:pma="https://www.phpmyadmin.net/some_doc_url/"> pma:structure_schemas <pma:database name="mysql" collation="latin1_swedish_ci" charset="latin1"> <pma:table name="general_log"> CREATE TABLE general_log ( event_time timestamp(6) NOT NULL DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6), user_host mediumtext NOT NULL, thread_id int(11) NOT NULL, server_id int(10) unsigned NOT NULL, command_type varchar(64) NOT NULL, argument mediumtext NOT NULL ) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='General log'; </pma:table> </pma:database> </pma:structure_schemas>

<!--
- 数据库： 'mysql'
-->
<database name="mysql">
    <!-- 表 general_log -->
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:08.824813</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5670</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SET NAMES utf8</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:08.824959</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5670</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM tc_options</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:08.825200</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5670</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT *  FROM `tiebacloud`.`tc_cron` ORDER BY `orde` ASC</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:08.825312</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5670</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM `tc_plugins` ORDER BY `order` ASC</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:08.825465</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5670</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">Select `order` From `tiebacloud`.`tc_plugins` Where `name`='wmzz_debug' LIMIT 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:08.825608</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5670</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM  `tiebacloud`.`tc_users` WHERE `id` = '1' LIMIT 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:08.825738</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5670</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT COUNT(*) FROM  `tiebacloud`.`tc_tieba` WHERE `uid` = 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:08.825900</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5670</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM  `tiebacloud`.`tc_baiduid` WHERE uid = 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:08.825974</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5670</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM  `tiebacloud`.`tc_users_options` WHERE uid = 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:08.826242</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5670</column>
        <column name="server_id">1</column>
        <column name="command_type">Quit</column>
        <column name="argument"></column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:09.015514</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5671</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SET NAMES utf8</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:09.015683</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5671</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM tc_options</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:09.015935</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5671</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT *  FROM `tiebacloud`.`tc_cron` ORDER BY `orde` ASC</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:09.016050</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5671</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM `tc_plugins` ORDER BY `order` ASC</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:09.016218</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5671</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">Select `order` From `tiebacloud`.`tc_plugins` Where `name`='wmzz_debug' LIMIT 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:09.016347</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5671</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM  `tiebacloud`.`tc_users` WHERE `id` = '1' LIMIT 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:09.016475</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5671</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT COUNT(*) FROM  `tiebacloud`.`tc_tieba` WHERE `uid` = 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:09.016562</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5671</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM  `tiebacloud`.`tc_baiduid` WHERE uid = 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:09.016634</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5671</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM  `tiebacloud`.`tc_users_options` WHERE uid = 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:09.017383</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5671</column>
        <column name="server_id">1</column>
        <column name="command_type">Quit</column>
        <column name="argument"></column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:09.361669</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5673</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SET NAMES utf8</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:09.361836</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5673</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM tc_options</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:09.362104</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5673</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT *  FROM `tiebacloud`.`tc_cron` ORDER BY `orde` ASC</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:09.362276</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5673</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM `tc_plugins` ORDER BY `order` ASC</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:09.362462</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5673</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">Select `order` From `tiebacloud`.`tc_plugins` Where `name`='wmzz_debug' LIMIT 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:09.362616</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5673</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM  `tiebacloud`.`tc_users` WHERE `id` = '1' LIMIT 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:09.362759</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5673</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT COUNT(*) FROM  `tiebacloud`.`tc_tieba` WHERE `uid` = 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:09.362887</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5673</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM  `tiebacloud`.`tc_baiduid` WHERE uid = 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:09.362973</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5673</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM  `tiebacloud`.`tc_users_options` WHERE uid = 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:09.363317</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5673</column>
        <column name="server_id">1</column>
        <column name="command_type">Quit</column>
        <column name="argument"></column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:12.719420</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5677</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SET NAMES utf8</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:12.719542</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5677</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM tc_options</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:12.719749</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5677</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT *  FROM `tiebacloud`.`tc_cron` ORDER BY `orde` ASC</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:12.719897</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5677</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM `tc_plugins` ORDER BY `order` ASC</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:12.720052</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5677</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">Select `order` From `tiebacloud`.`tc_plugins` Where `name`='wmzz_debug' LIMIT 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:12.720207</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5677</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM  `tiebacloud`.`tc_users` WHERE `id` = '1' LIMIT 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:12.720346</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5677</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT COUNT(*) FROM  `tiebacloud`.`tc_tieba` WHERE `uid` = 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:12.720446</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5677</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM  `tiebacloud`.`tc_baiduid` WHERE uid = 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:12.720527</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5677</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM  `tiebacloud`.`tc_users_options` WHERE uid = 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:12.721087</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5677</column>
        <column name="server_id">1</column>
        <column name="command_type">Quit</column>
        <column name="argument"></column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:13.860800</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5679</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SET NAMES utf8</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:13.861586</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5679</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM tc_options</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:13.861820</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5679</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT *  FROM `tiebacloud`.`tc_cron` ORDER BY `orde` ASC</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:13.861996</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5679</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM `tc_plugins` ORDER BY `order` ASC</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:13.862195</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5679</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">Select `order` From `tiebacloud`.`tc_plugins` Where `name`='wmzz_debug' LIMIT 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:13.862343</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5679</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM  `tiebacloud`.`tc_users` WHERE `id` = '1' LIMIT 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:13.862480</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5679</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT COUNT(*) FROM  `tiebacloud`.`tc_tieba` WHERE `uid` = 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:13.862571</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5679</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM  `tiebacloud`.`tc_baiduid` WHERE uid = 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:13.862898</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5679</column>
        <column name="server_id">1</column>
        <column name="command_type">Query</column>
        <column name="argument">SELECT * FROM  `tiebacloud`.`tc_users_options` WHERE uid = 1</column>
    </table>
    <table name="general_log">
        <column name="event_time">2018-12-05 18:38:13.863476</column>
        <column name="user_host">tiebacloud[tiebacloud] @ localhost []</column>
        <column name="thread_id">5679</column>
        <column name="server_id">1</column>
        <column name="command_type">Quit</column>
        <column name="argument"></column>
    </table>
</database>

</pma_xml_export>`

Dec 05 '18 10:12 rhjdvsgsgks

别的开源项目能正常写入到这个库吗？

Dec 06 '18 01:12 mokeyjay

@mokeyjay 我给每个项目都以相同的方法单独配置了用户和数据库，WordPress和nextcloud都能正常工作

用的这个方法创建的数据库和用户

Dec 06 '18 04:12 rhjdvsgsgks

🤔这就奇怪了，闻所未闻啊

Dec 06 '18 06:12 mokeyjay

@mokeyjay 不知道和数据库排序规则有没有关系，我utf8mb4_general_ci和utf8_general_ci都试过了

Dec 06 '18 11:12 rhjdvsgsgks

@mokeyjay 突然想到了是不是因为Nginx的配置，没有传递某些参数，所以才没向数据库写入

location / {
        # This is cool because no php is touched for static content.
        # include the "?$args" part so non-default permalinks doesn't break when using query string
        try_files $uri $uri/ /index.php?$args;
}
location ~ \.php$ {
        fastcgi_split_path_info ^(.+?\.php)(/.*)$;
        include fastcgi_params;
        fastcgi_param PATH_INFO $fastcgi_path_info;
        fastcgi_param HTTPS on;
        #Avoid sending the security headers twice
        fastcgi_param modHeadersAvailable true;
        fastcgi_param front_controller_active true;
        fastcgi_pass php-handler;
        fastcgi_intercept_errors on;
        fastcgi_request_buffering off;
}

Dec 07 '18 16:12 rhjdvsgsgks

Tieba-Cloud-Sign Tieba-Cloud-Sign copied to clipboard

无法向数据库写入

Tieba-Cloud-Sign
Tieba-Cloud-Sign copied to clipboard