升級後無法上傳任何文件


#1

原本的社區版是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

#2

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.


#3

你进入 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);

#4

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


#5

这句话怎么用的 ,可以告诉我吗? @ Hyakko


7.0上传文件CSS报错问题
#7

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

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

#8

對.

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


#9

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


#10

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

image


#11

你去logs/seafile.log

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

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

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


#12

[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


#13

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


#14

OK, Very good ! !