| Bug #76991 | Workbench Table Data Import Wizard Error | ||
|---|---|---|---|
| Submitted: | 10 May 2015 0:28 | Modified: | 21 May 2015 3:06 |
| Reporter: | Mike Arian | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S2 (Serious) |
| Version: | MySQL 5 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[10 May 2015 0:30]
Mike Arian
sample snippet of csv file
Attachment: mysql sample.csv (application/vnd.ms-excel, text), 28.02 KiB.
[10 May 2015 0:31]
Mike Arian
wb.log file
Attachment: wblog.txt (text/plain), 7.44 KiB.
[11 May 2015 7:36]
Marcin Szalowicz
Thank you for the bug report.
[21 May 2015 3:06]
Philip Olson
Posted by developer: Fixed as of the upcoming MySQL Workbench 6.3.4 release, and here's the changelog entry: Executing the "Table Data Import" wizard with CSV data would sometimes fail when using a remote MySQL connection. Thank you for the bug report.
[18 Mar 2017 21:03]
Douglas Bonneville
I'm 6.3.9 and have this exact same error, starting with an Amazon RDS instance. Was there a regression of this error?
Description: I have created an instance of MySQL running on Amazon RDS. I have created several tables and have succesfully connected from MySQL Workbench. I am trying to run the table data import wizard to load a csv file into my physicians table in MySQL and keep getting the same error: Starting... Prepare Import... Prepare Import done Import data file.... - Prepare Import Traceback (most recent call last): File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\workbench\wizard_progress_page_widget.py", line 192, in thread_work self.func() File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_power_import_wizard.py", line 123, in start_import retval = self.module.start(self.stop) File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_power_import_export_be.py", line 256, in start ret = self.start_import() File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules\sqlide_power_import_export_be.py", line 407, in start_import self._editor.executeManagementCommand(query, 1) DBError: ("You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Dec,ID,PA1,PA2,PA_State) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,' at line 1", 1064) ERROR: Import data file: ("You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Dec,ID,PA1,PA2,PA_State) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,' at line 1", 1064) Failed How to repeat: happens every time I try