'Error "Index out of range" in MySQL Workbench 6.0.8.11354 (6.0), what is wrong?

I just started designing a database in MySQLWorkbench 6.0. I created a few tables but now when I click the "Add table" button it shows a message: "Index out of range" and the program crashes.

Any idea what is wrong or what could I have done to get this error ?

None of the tables have any values, they just have the fields and field type, with their primary keys and foreign keys (something tells me it's something I did when connecting tables via the foreign keys, I'm new to this software).

Any help appreciated!

mysqlsqlmysql-workbench


Solution 1:[1]

Have you tried restarting MySQL Workbench? I haven't heard of such a problem before, but maybe steps you did in a certain order caused this exception.

In any case you should file a bug report for it at http://bugs.mysql.com to get this fixed. Only via such a report developers can take notice.

Solution 2:[2]

Once the alert popped up, I hit ok and then clicked on the little wrench icon above the utf selection. I had to change how it would separate the columns from ';' to ',' This fixed my issue without having to change any of the content in the csv.

Solution 3:[3]

I just ran into this, Some of the fields in my CSV contained " and ' characters. Removing those fixed it.

Solution 4:[4]

I played around with the delimiter settings on the wizard until it worked, had to change from ';' to ',' for it to work.

Solution 5:[5]

I know it's been so long already but my issue was solved after opening the cvs as an excel (calc in linux) then saving as csv again.

Solution 6:[6]

Once error shows up click OK Click on settings icon Change field separator as per your csv

Done ! It worked for me

Step 1

Step 2

Step 3

Solution 7:[7]

MySQL workbench 6.3 I had to put all of my column values in "". After I could import data. Hope help!

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Mike Lischke
Solution 2 hardScrabble
Solution 3 dryicebomb
Solution 4 Pete Allen
Solution 5 barnelisme
Solution 6 Sanket Patil
Solution 7 HowToTellAChild

Related Questions