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:
None 
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 0:01] Troy Whitney
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.
[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".