当前位置：首页 > news >正文

MySQL Workbench Data Import Wizard:list index out of range

news 2025/7/15 13:40:30

MySQL Workbench的Data Import Wizard功能是用python实现的，MySQL Workbench自带了一个python，数据导入的时候出现错误提示

22:55:51 [ERR][ pymforms]: Unhandled exception in Python code:
Traceback (most recent call last):
File "D:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_export_be.py", line 547, in analyze_file
json_value = json.loads(col_value)
^^^^^^^^^^^^^^^^^^^^^
File "D:\Program Files\MySQL\MySQL Workbench 8.0 CE\Python\Lib\json\__init__.py", line 346, in loads
return _default_decoder.decode(s)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Program Files\MySQL\MySQL Workbench 8.0 CE\Python\Lib\json\decoder.py", line 337, in decode
obj, end = self.raw_decode(s, idx=_w(s, 0).end())
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Program Files\MySQL\MySQL Workbench 8.0 CE\Python\Lib\json\decoder.py", line 355, in raw_decode
raise JSONDecodeError("Expecting value", s, err.value) from None
json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "D:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_page_widget.py", line 98, in go_next
self.main.go_next_page()
File "D:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_form.py", line 77, in go_next_page
self.pages[index].page_activated(True)
File "D:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_wizard.py", line 186, in page_activated
self.call_create_preview_table()
File "D:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_wizard.py", line 344, in call_create_preview_table
self.create_preview_table(self.call_analyze())
^^^^^^^^^^^^^^^^^^^
File "D:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_wizard.py", line 353, in call_analyze
if not self.active_module.analyze_file():
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_export_be.py", line 552, in analyze_file
self._columns[j]['value'].append(col_value)
~~~~~~~~~~~~~^^^
IndexError: list index out of range