升級後無法上傳任何文件

[Hyakko]

原本的社區版是6.2.X 先升級到6.3.4 然後再升級到7.0.0 後
使用任何帳戶都無法上傳文件。

並顯示這個錯誤.
{“error”: "Internal error. "}

2019-05-30更新:
剛測試, 這個問題出現在web 的介面上. 桌面版沒問題

已解決:
你进入 seafile-db 数据库中手工执行下以下的语句:

CREATE TABLE IF NOT EXISTS WebUploadTempFiles (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, re

[Hyakko]

seafile.log

[05/29/2019 09:57:07 AM] …/common/seaf-db.c(425): Error prepare statement SELECT tmp_file_path FROM WebUploadTempFiles WHERE repo_id = ? AND file_path = ?: mysql_stmt_prepare failed: Table ‘seafile-db.WebUploadTempFiles’ doesn’t exist.
[05/29/2019 09:57:07 AM] upload-file.c(1127): Failed to get upload temp file path from db.
[05/29/2019 10:30:14 AM] …/common/seaf-db.c(425): Error prepare statement SELECT tmp_file_path FROM WebUploadTempFiles WHERE repo_id = ? AND file_path = ?: mysql_stmt_prepare failed: Table ‘seafile-db.WebUploadTempFiles’ doesn’t exist.
[05/29/2019 10:30:14 AM] upload-file.c(1127): Failed to get upload temp file path from db.
[05/29/2019 10:30:26 AM] …/common/seaf-db.c(425): Error prepare statement SELECT tmp_file_path FROM WebUploadTempFiles WHERE repo_id = ? AND file_path = ?: mysql_stmt_prepare failed: Table ‘seafile-db.WebUploadTempFiles’ doesn’t exist.
[05/29/2019 10:30:26 AM] upload-file.c(1127): Failed to get upload temp file path from db.

[daniel.pan]

你进入 seafile-db 数据库中手工执行下以下的语句:

CREATE TABLE IF NOT EXISTS WebUploadTempFiles (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, repo_id CHAR(40) NOT NULL, file_path TEXT NOT NULL, tmp_file_path TEXT NOT NULL);

[Hyakko]

@daniel.pan

CREATE TABLE IF NOT EXISTS WebUploadTempFiles (id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, repo_id CHAR(40) NOT NULL, file_path TEXT NOT NULL, tmp_file_path TEXT NOT NULL);

問題解決了. 感謝
但是這一句的大約是做了甚麼?

[xxq0396]

这句话怎么用的 ，可以告诉我吗？ @ Hyakko

[Hulk]

需要你登录MySQL数据，这个语句是在seahub_db里创建一个数据表，

1. mysql 命令登录数据
2. use seahub_db; 切换到seahub_db中
3. 执行上边哪个语句

[Hyakko]

對.

但是我都不知他的運作原理.

[xxq0396]

如果使用了SQLite呢？ 怎么解决升级7.0后不能上传文件的问题啊？

[xxq0396]

SQLite 碰到的升级7.0.0后WEB端不能上传文件的，大神帮忙给个建议。感谢啊！！

[Hyakko]

你去logs/seafile.log

把相關的 log 找出來
再看看是否跟其他人差不多吧.

如果是, 便看看怎加入到SQL

注: 我都是邊學linux 邊試這個軟件.

[xxq0396]

[05/30/2019 11:19:37 AM] …/common/seaf-db.c(425): Error prepare statement SELECT tmp_file_path FROM WebUploadTempFiles WHERE repo_id = ? AND file_path = ?: sqlite3_prepare_v2 failed: no such table: WebUploadTempFiles.
[05/30/2019 11:19:37 AM] upload-file.c(1127): Failed to get upload temp file path from db.
[05/30/2019 11:22:32 AM] …/common/seaf-db.c(425): Error prepare statement SELECT tmp_file_path FROM WebUploadTempFiles WHERE repo_id = ? AND file_path = ?: sqlite3_prepare_v2 failed: no such table: WebUploadTempFiles.
[05/30/2019 11:22:32 AM] upload-file.c(1127): Failed to get upload temp file path from db.

日志如上，请各位帮忙看看，感谢。 ！

不过看起来和你的日志差不多。你的是mysql，我的是sqlite3

[Java]

@xxq0396

WebUploadTempFiles WHERE repo_id = ? AND file_path = ?: sqlite3_prepare_v2 failed: no such table: WebUploadTempFiles.
[05/30/2019 11:19:37 AM] upload-file.c(1127): Failed to get upload temp file path from db.
[05/30/2019 11:22:32 AM] …/common/seaf-db.c(425): Error prepare statement SELECT tmp_file_path FROM WebUploadTempFiles WHERE repo_id = ? AND file_path = ?: sqlite3_prepare_v2 failed: no such table:

sqlite3 /<你的路径>/seafile-data/seafile.db

CREATE TABLE [WebUploadTempFiles]( [id] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, [repo_id] CHAR(40) NOT NULL, [file_path] TEXT NOT NULL, [tmp_file_path] TEXT NOT NULL );

.quit

[xxq0396]

OK, Very good ! !