| Bug #94958 | Get Error Whenever I try to import CSV | ||
|---|---|---|---|
| Submitted: | 10 Apr 2019 0:01 | Modified: | 14 Jun 2019 21:05 |
| Reporter: | Troy Whitney | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S3 (Non-critical) |
| Version: | 8.0.15 | OS: | Windows (Microsoft Windows 10 Home) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | WBBugReporter | ||
[10 Apr 2019 1:13]
Troy Whitney
So I have seen this error showing up a lot in my search for the fix. Because of the nature of the error message it seems something big might be wrong. However, I solved this by happenstance by double clicking the schema of the database I was working with. Once it was "bold/highlighted" the import worked fine. Instead of an ugly unhelpful message maybe a friendly reminder to set a default database would be a better solution to this particular issue. Thanks. Solved.
[14 May 2019 21:05]
MySQL Verification Team
Thank you for the bug report. Please try version 8.0.16 if the issue is still present, please attach a csv file and create table statement if needed.
[15 Jun 2019 1:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Description: ----[For better reports, please attach the log file after submitting. You can find it in C:\Users\karra\AppData\Roaming\MySQL\Workbench\log\wb.log] 17:49:19 [WRN][SqlEditorSchemaTree]: Error fetching index information for 'coc_wp_db'.'coc_fishing_times_basic_table': MySQL_ResultSet::getString: invalid value of 'columnIndex' 17:49:46 [ERR][ pymforms]: Unhandled exception in Python code: Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_page_widget.py", line 97, in go_next self.main.go_next_page() File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_form.py", line 76, in go_next_page self.pages[index].page_activated(True) File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_wizard.py", line 581, in page_activated self.preload_existing_tables() File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_wizard.py", line 599, in preload_existing_tables rset = self.main.editor.executeManagementQuery(u"SHOW FULL TABLES FROM `%s`" % self.main.destination_table['schema'], 0) DBError: ("Incorrect database name ''", 1102) 17:50:00 [ERR][SQL Editor Form]: Error Code: 1102 Incorrect database name '' 17:50:00 [ERR][ pymforms]: Unhandled exception in Python code: Traceback (most recent call last): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_page_widget.py", line 97, in go_next self.main.go_next_page() File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\wizard_form.py", line 68, in go_next_page if not self.pages[current_page].validate(): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_wizard.py", line 727, in validate if not self.drop_table_cb.get_active() and (table_name in self.table_list or self.check_if_table_exists(self.main.destination_table['schema'], self.main.destination_table['table'])): File "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\sqlide_power_import_wizard.py", line 706, in check_if_table_exists rset = self.main.editor.executeManagementQuery(u"SHOW TABLES FROM `%s` like '%s'" % (schema, table), 1) DBError: ("Incorrect database name ''", 1102) When ever I try to import CSV I get this error: Incorrect Database name on Table Data Import 1102 How to repeat: Open a table. Then click import. Select CSV. Get error.