Anankke / SSPanel-UIM

Multi-purpose proxy service management system
MIT License
9.36k stars 3.4k forks source link

[BUG] 由2022.12升級到2022.12.1,財務系統不可用(全新安裝則正常) #1915

Closed NekoCloudServices closed 1 year ago

NekoCloudServices commented 1 year ago

Environment 环境

OS: Debian 11 Bullseye stable PHP version: PHP 8.1 with OPcache DB version: MariaDB 10.6 Commit: 2022.12—>2022.12.1 Release

Bug Info

Describe the issue you run into. 请描述你遇到的问题。

復現步驟: 1、按照2022年12月3日版本的(官方安裝教程),並按照 https://github.com/Anankke/SSPanel-Uim/issues/1695 中的指示移除 db\migrations\20220505044345_string_to_text.php 后進行全新安裝2022.12版本

2、按照 https://github.com/Anankke/SSPanel-Uim/issues/1864 的指示導入 update.sql

3、數據庫保持不動,移除網站目錄文件,而後 git clone 2022.12.1 版本,配置好 config/.config.php 和 config/appprofile.php ,根據 https://github.com/Anankke/SSPanel-Uim/issues/1848 的指示執行 php xcat Tool importAllSettings 並修改 config 表裏 db_version 值為 2023020100 ,執行 bash update.sh release 2022.12.1 2023030500 與 php xcat ClientDownload(直到此步驟均無報錯)

4、登錄網站,用戶端商店系統正常(舊商店界面),管理端財務系統報錯

財務-商品 報錯 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sspanel.product' doesn't exist (SQL: select * from product order by id desc)

財務-訂單 報錯 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sspanel.order' doesn't exist (SQL: select * from order order by id desc)

財務-賬單 報錯 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sspanel.invoice' doesn't exist (SQL: select * from invoice order by id desc)

財務-優惠碼 報錯 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sspanel.user_coupon' doesn't exist (SQL: select * from user_coupon order by id desc)

財務-禮品卡 報錯 SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sspanel.gift_card' doesn't exist (SQL: select * from gift_card order by id desc)

直接全新安裝 2022.12.1 版本則沒有問題......由全新安裝的 2022.12.1 版本升級到 2023.1 也沒有問題 但是如果全新安裝 2022.12 並升級到 2022.12.1,財務系統就會報錯,此時若繼續升級 2023.1 則財務和商店系統都會報錯

另外,全新安裝 2022.12.1 後,根據wiki描述通過 bash update.sh release 2023.1 2023032600 指令嘗試升級,並不能把文件更新到2023.1的版本(即網站目錄内文件依舊為2022.12.1的狀態),git報錯如下:

Hint: Pulling without specifying how to reconcile divergent branches is discouraged. You can squelch this message by running one of the following commands sometime before your next pull:

   git config pull.rebase false  # merge (the default strategy)
   git config pull.rebase true   # rebase
   git config pull.ff only       # fast-forward only

 You can replace "git config" with "git config --global" to set a default preference for all repositories. You can also pass --rebase, --no-rebase, or --ff-only on the command line to override the configured default per invocation.

Already up to date.
fatal: ambiguous argument '2023.1': unknown revision or path not in the working tree.
Use '--' to separate paths from revisions, like this:
'git <command> [<revision>...] -- [<file>...]'
NekoCloudServices commented 1 year ago

@M1Screw 嗚嗚 我提的那個pr只是解決了【根據wiki描述通過 bash update.sh release 2023.1 2023032600 指令嘗試升級,並不能把文件更新到2023.1的版本】的問題呀 前一個數據庫方面的問題還沒有解決的 可不可以重新開一下這個issues QAQ