无法导入excel文件,提示服务器内部错误。

如题,无法导入excel文件,提示服务器内部错误。我只是安装官方文档,设置https访问,修改了【dtable_web_settings】、【ccnet】、【nginx】三个配置文件的服务器相关信息。求解。谢谢
这是官网安装教程:
https://docs.seatable.cn/published/seatable-manual/docker/seatable-ce/Deploy%20SeaTable%20with%20Docker.md

这个问题应该看服务器的日志。

本人小白,日志看不懂啊 :joy:求大神指点!

看一下 dtable_events_io.log 这个文件

2022-01-24 12:51:34,556 [INFO] Run task: 1642999894554 <function get_dtable_export_content at 0x7f794ced2560>
2022-01-24 12:51:34,562 [INFO] Start prepare /tmp/dtable-io/0bdf41bd-4e9e-4fd7-91a1-79d877e78479/zip_file.zip for export DTable.
2022-01-24 12:51:34,565 [INFO] Clear tmp dirs and files before prepare.
2022-01-24 12:51:34,568 [INFO] Create content.json file.
2022-01-24 12:51:34,826 [ERROR] prepare dtable json failed. ERROR: HTTPSConnectionPool(host=‘yinghao1.cn’, port=4490): Max retries exceeded with url: /dtable-server/dtables/0bdf41bd-4e9e-4fd7-91a1-79d877e78479/ (Caused by SSLError(SSLCertVerificationError(1, ‘[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1076)’)))
2022-01-24 12:51:34,844 [INFO] Make zip file for download…
2022-01-24 12:51:34,846 [INFO] Create /tmp/dtable-io/0bdf41bd-4e9e-4fd7-91a1-79d877e78479/zip_file.zip success!
2022-01-24 12:51:34,846 [INFO] Run task success: 1642999894554 <function get_dtable_export_content at 0x7f794ced2560> cost 0s

2022-01-24 12:51:46,799 [INFO] Run task: 1642999906797 <function post_dtable_import_files at 0x7f794ced25f0>
2022-01-24 12:51:46,799 [INFO] Start import DTable: 3fe8bbb6-f894-4b01-996f-7ca5f252359e.
2022-01-24 12:51:46,801 [INFO] Prepare dtable json file and post it at file server.
2022-01-24 12:51:46,802 [ERROR] post dtable json failed. ERROR: [Errno 2] No such file or directory: ‘/tmp/dtable-io/3fe8bbb6-f894-4b01-996f-7ca5f252359e/dtable_zip_extracted/content.json’
2022-01-24 12:51:46,802 [INFO] Post asset files in tmp path to file server.
2022-01-24 12:51:46,803 [INFO] create forms from src dtable.
2022-01-24 12:51:46,805 [INFO] Remove extracted tmp file.
2022-01-24 12:51:46,805 [ERROR] rm extracted tmp file failed. ERROR: [Errno 2] No such file or directory: ‘/tmp/dtable-io/3fe8bbb6-f894-4b01-996f-7ca5f252359e’
2022-01-24 12:51:46,806 [INFO] Import DTable: 3fe8bbb6-f894-4b01-996f-7ca5f252359e success!
2022-01-24 12:51:46,806 [INFO] Run task success: 1642999906797 <function post_dtable_import_files at 0x7f794ced25f0> cost 0s

2022-01-24 14:24:57,534 [INFO] Run task: 1643005497532 <function get_dtable_export_content at 0x7fccbd708560>
2022-01-24 14:24:57,534 [INFO] Start prepare /tmp/dtable-io/054060c4-fe41-4017-984c-09791e1b08c6/zip_file.zip for export DTable.
2022-01-24 14:24:57,537 [INFO] Clear tmp dirs and files before prepare.
2022-01-24 14:24:57,538 [INFO] Create content.json file.
2022-01-24 14:24:57,658 [ERROR] prepare dtable json failed. ERROR: HTTPSConnectionPool(host=‘yinghao1.cn’, port=4490): Max retries exceeded with url: /dtable-server/dtables/054060c4-fe41-4017-984c-09791e1b08c6/ (Caused by SSLError(SSLCertVerificationError(1, ‘[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1076)’)))
2022-01-24 14:24:57,672 [INFO] Make zip file for download…
2022-01-24 14:24:57,674 [INFO] Create /tmp/dtable-io/054060c4-fe41-4017-984c-09791e1b08c6/zip_file.zip success!
2022-01-24 14:24:57,674 [INFO] Run task success: 1643005497532 <function get_dtable_export_content at 0x7fccbd708560> cost 0s

2022-01-24 14:25:22,972 [INFO] Run task: 1643005522971 <function post_dtable_import_files at 0x7fccbd7085f0>
2022-01-24 14:25:22,973 [INFO] Start import DTable: 8bb3cd49-cdb4-4616-89ae-44c59e8c7ef5.
2022-01-24 14:25:22,976 [INFO] Prepare dtable json file and post it at file server.
2022-01-24 14:25:22,976 [ERROR] post dtable json failed. ERROR: [Errno 2] No such file or directory: ‘/tmp/dtable-io/8bb3cd49-cdb4-4616-89ae-44c59e8c7ef5/dtable_zip_extracted/content.json’
2022-01-24 14:25:22,977 [INFO] Post asset files in tmp path to file server.
2022-01-24 14:25:22,977 [INFO] create forms from src dtable.
2022-01-24 14:25:22,979 [INFO] Remove extracted tmp file.
2022-01-24 14:25:22,980 [ERROR] rm extracted tmp file failed. ERROR: [Errno 2] No such file or directory: ‘/tmp/dtable-io/8bb3cd49-cdb4-4616-89ae-44c59e8c7ef5’
2022-01-24 14:25:22,980 [INFO] Import DTable: 8bb3cd49-cdb4-4616-89ae-44c59e8c7ef5 success!
2022-01-24 14:25:22,980 [INFO] Run task success: 1643005522971 <function post_dtable_import_files at 0x7fccbd7085f0> cost 0s

Max retries exceeded with url: /dtable-server/dtables/5a5a2531-4c36-417c-9095-6d6930e223c8/ (Caused by NewConnectionError(’<urllib3.connection.HTTPConnection object at 0x7f5cdc5eb990>: Failed to establish a new connection: [Errno -2] Name or service not known’))
2022-03-26 09:29:05,745 [ERROR] Failed to handle task 1648258145675, error: prepare dtable json failed. ERROR: HTTPConnectionPool(host=‘mr50235403nb1’, port=10090): Max retries exceeded with url: /dtable-server/dtables/5a5a2531-4c36-417c-9095-6d6930e223c8/ (Caused by NewConnectionError(’<urllib3.connection.HTTPConnection object at 0x7f5cdc5eb990>: Failed to establish a new connection: [Errno -2] Name or service not known’))

同样有这个问题, 应该怎么解决呢?

我也有这个问题,而且如果点了导入,在选择文件的时候取消,浏览器就会卡死

已解决,原因是Docker容器不能正确解析域名,将extra_hosts加入到docker-compose文件中即可

具体怎么加入呢?可以详细点吗

我也遇到了这个问题,请问你具体是怎么修改的呢

我的也是这个问题,请问具体怎么解决呢?extra_hosts怎么添加

经过反复测试

for seaf-server

FILE_SERVER_ROOT = ‘http://192.168.2.*/seafhttp/’
这个必须改为内网地址

不行呢,我的本来就是用的内部ip。其他功能都正常,就是导入Excel表不行,导入dtable都可以。

dtable_web.log日志报以下错误
2022-09-30 10:38:38,865 [ERROR] seahub.api2.endpoints.dtable_io:326 post upload excel error: HTTPConnectionPool(host=‘192.168.131.142’, port=80): Max retries exceeded with url: /seafhttp/upload-api/b165461c-bff5-4ea3-a353-83f10b4c553f?replace=1 (Caused by NewConnectionError(’<urllib3.connection.HTTPConnection object at 0x7f7e04ddbf90>: Failed to establish a new connection: [Errno 110] Connection timed out’))
2022-09-30 10:38:38,865 [ERROR] django.request:230 log_response Internal Server Error: /api/v2.1/workspace/3/import-dtable/

extra_hosts下面10.1.70.1是什么地址?

是在内网这个域名解析出来的地址

改回内网IP也还是不行啊,还是无法导出

这里需要把端口带上去吗?

这里不用带端口的。



可是我这样设置了还是不行,可以导入导出dtable文件,但是就是导出不了excel文件