[Bug] chatexcel上传文件时报错excel load error，none is not an allowed value，type_error.none.not_allowed

[saymyname77]

Search before asking

• [X] I had searched in the issues and found no similar issues.

Operating system information

Linux

Python version information

3.10

DB-GPT version

latest release

Related scenes

• [ ] Chat Data
• [X] Chat Excel
• [ ] Chat DB
• [ ] Chat Knowledge
• [ ] Model Management
• [ ] Dashboard
• [ ] Plugins

Installation Information

• [X] Installation From Source

• [ ] Docker Installation

• [ ] Docker Compose Installation

• [ ] Cluster Installation

• [ ] AutoDL Image

• [ ] Other

Device information

gpu:4090 * 2

Models information

llm:baichuan2-7b embedding：m3e-large

What happened

chatExcel上传文件后网页右上角弹窗none is not an allowed value', 'type': 'type_error.none.not_allowed

终端提示：File "/root/.ph/pilot/openapi/api_v1/api_v1.py", line 335, in params_load logger.error("excel load error!", e) Message: 'excel load error!' Arguments: (ValidationError(model='ConversationVo', errors=[{'loc': ('user_name',), 'msg': 'none is not an allowed value', 'type': 'type_error.none.not_allowed'}]),)

What you expected to happen

希望功能正常

How to reproduce

源码安装完chatexcel上传文件

Additional context

pip list Package Version Editable project location

---

absl-py 2.0.0 abstract_singleton 1.0.1 accelerate 0.24.1 aiofiles 23.2.1 aiohttp 3.8.4 aiosignal 1.3.1 alembic 1.12.0 anyio 3.7.1 async-timeout 4.0.3 attributedict 0.3.0 attrs 23.1.0 auto_gpt_plugin_template 0.0.3 auto-gptq 0.5.1+cu118 autoawq 0.1.7+cu118 backoff 2.2.1 bcrypt 4.0.1 beautifulsoup4 4.12.2 bitsandbytes 0.41.0 blessings 1.7 blis 0.7.11 bs4 0.0.1 cachetools 5.3.2 catalogue 2.0.10 certifi 2023.11.17 chardet 5.1.0 charset-normalizer 3.3.2 chroma-hnswlib 0.7.3 chromadb 0.4.10 click 8.1.7 cmake 3.27.7 codecov 2.1.13 colorama 0.4.6 coloredlogs 15.0.1 colour-runner 0.1.1 confection 0.1.4 contourpy 1.2.0 coverage 7.3.2 cpm-kernels 1.0.11 cycler 0.12.1 cymem 2.0.8 dashscope 1.13.3 dataclasses 0.6 dataclasses-json 0.6.3 DataProperty 1.0.1 datasets 2.15.0 db-gpt 0.4.2 /root/.ph deepdiff 6.7.1 dill 0.3.7 distlib 0.3.7 distro 1.8.0 duckdb 0.8.1 duckdb-engine 0.9.2 et-xmlfile 1.1.0 exceptiongroup 1.2.0 fastapi 0.98.0 filelock 3.13.1 flatbuffers 23.5.26 fonttools 4.45.1 frozenlist 1.4.0 fschat 0.2.33 fsspec 2023.10.0 gekko 1.0.6 gitdb 4.0.11 GitPython 3.1.40 greenlet 3.0.1 gTTS 2.3.1 h11 0.14.0 httpcore 1.0.2 httptools 0.6.1 httpx 0.25.2 huggingface-hub 0.19.4 humanfriendly 10.0 idna 3.6 importlib-resources 5.12.0 inspecta 0.1.3 Jinja2 3.1.2 joblib 1.3.2 jsonlines 4.0.0 jsonpatch 1.33 jsonpointer 2.4 jsonschema 4.20.0 jsonschema-specifications 2023.11.1 kiwisolver 1.4.5 langchain 0.0.341 langchain-core 0.0.6 langcodes 3.3.0 langsmith 0.0.67 lit 17.0.5 lm-eval 0.3.0 lxml 4.9.3 Mako 1.3.0 Markdown 3.5.1 markdown-it-py 3.0.0 markdown2 2.4.10 MarkupSafe 2.1.3 marshmallow 3.20.1 matplotlib 3.8.2 mbstrdecoder 1.1.3 mdurl 0.1.2 monotonic 1.6 mpmath 1.3.0 msgpack 1.0.7 multidict 6.0.4 multiprocess 0.70.15 murmurhash 1.0.10 mypy-extensions 1.0.0 networkx 3.2.1 nh3 0.2.14 nltk 3.8.1 numexpr 2.8.7 numpy 1.26.2 nvidia-cublas-cu11 11.10.3.66 nvidia-cublas-cu12 12.1.3.1 nvidia-cuda-cupti-cu11 11.7.101 nvidia-cuda-cupti-cu12 12.1.105 nvidia-cuda-nvrtc-cu11 11.7.99 nvidia-cuda-nvrtc-cu12 12.1.105 nvidia-cuda-runtime-cu11 11.7.99 nvidia-cuda-runtime-cu12 12.1.105 nvidia-cudnn-cu11 8.5.0.96 nvidia-cudnn-cu12 8.9.2.26 nvidia-cufft-cu11 10.9.0.58 nvidia-cufft-cu12 11.0.2.54 nvidia-curand-cu11 10.2.10.91 nvidia-curand-cu12 10.3.2.106 nvidia-cusolver-cu11 11.4.0.1 nvidia-cusolver-cu12 11.4.5.107 nvidia-cusparse-cu11 11.7.4.91 nvidia-cusparse-cu12 12.1.0.106 nvidia-nccl-cu11 2.14.3 nvidia-nccl-cu12 2.18.1 nvidia-nvjitlink-cu12 12.3.101 nvidia-nvtx-cu11 11.7.91 nvidia-nvtx-cu12 12.1.105 onnxruntime 1.16.3 openai 1.3.5 openpyxl 3.1.2 optimum 1.14.1 ordered-set 4.1.0 overrides 7.4.0 packaging 23.2 pandas 2.0.3 pathvalidate 3.2.0 pathy 0.10.3 peft 0.6.2 Pillow 10.1.0 pip 23.3.1 platformdirs 4.0.0 pluggy 1.3.0 portalocker 2.8.2 posthog 3.0.2 preshed 3.0.9 prettytable 3.9.0 prompt-toolkit 3.0.41 protobuf 3.20.3 psutil 5.9.4 pulsar-client 3.3.0 pyarrow 14.0.1 pyarrow-hotfix 0.6 pybind11 2.11.1 pycountry 22.3.5 pydantic 1.10.13 Pygments 2.17.2 PyJWT 2.8.0 Pympler 1.0.1 PyMySQL 1.1.0 pyparsing 3.1.1 pypdf 3.17.1 PyPika 0.48.9 pyproject-api 1.6.1 pytablewriter 1.2.0 python-dateutil 2.8.2 python-docx 1.1.0 python-dotenv 1.0.0 python-multipart 0.0.6 python-pptx 0.6.23 pytz 2023.3.post1 PyYAML 6.0.1 referencing 0.31.0 regex 2023.10.3 requests 2.31.0 rich 13.7.0 rocksdict 0.3.18 rootpath 0.1.1 rouge 1.0.1 rouge-score 0.1.2 rpds-py 0.13.1 sacrebleu 1.5.0 safetensors 0.4.1 scikit-learn 1.3.2 scipy 1.11.4 seaborn 0.13.0 sentence-transformers 2.2.2 sentencepiece 0.1.99 setuptools 68.0.0 shortuuid 1.0.11 six 1.16.0 smart-open 6.4.0 smmap 5.0.1 sniffio 1.3.0 soupsieve 2.5 spacy 3.5.3 spacy-legacy 3.0.12 spacy-loggers 1.0.5 SQLAlchemy 2.0.22 sqlitedict 2.1.0 sqlparse 0.4.4 srsly 2.4.8 starlette 0.27.0 svgwrite 1.4.3 sympy 1.12 tabledata 1.3.3 tabulate 0.9.0 tcolorpy 0.1.4 tenacity 8.2.3 termcolor 2.3.0 texttable 1.7.0 thinc 8.1.12 threadpoolctl 3.2.0 tiktoken 0.5.1 tokenizers 0.13.3 toml 0.10.2 tomli 2.0.1 torch 2.1.0 torchaudio 2.0.2 torchvision 0.15.2 tox 4.8.0 tqdm 4.66.1 tqdm-multiprocess 0.0.11 transformers 4.33.3 triton 2.1.0 typepy 1.3.2 typer 0.7.0 typing_extensions 4.8.0 typing-inspect 0.9.0 tzdata 2023.3 urllib3 2.1.0 uvicorn 0.24.0.post1 uvloop 0.19.0 virtualenv 20.24.7 wasabi 1.1.2 watchfiles 0.21.0 wavedrom 2.0.3.post3 wcwidth 0.2.12 websockets 12.0 wheel 0.41.2 xformers 0.0.22.post7 xlrd 2.0.1 XlsxWriter 3.1.9 xxhash 3.4.1 yarl 1.9.3 zhipuai 1.0.7 zstandard 0.22.0

Are you willing to submit PR?

• [ ] Yes I am willing to submit a PR!

[fangyinc]

@saymyname77 辛苦拉一下最新 main 分支的代码，最新的代码这个问题已经修复了。

[nuaabuaa07]

我也出现了类似报错，今天重新拉取代码后，确实不报错了，正常了

[github-actions[bot]]

This issue has been marked as stale, because it has been over 30 days without any activity.

[github-actions[bot]]

This issue bas been closed, because it has been marked as stale and there has been no activity for over 7 days.