ERROR 1170 (42000) at line 102607:

General usage of Access to MySQL

Moderator: jr

hillmandj
Posts: 1
Joined: Fri Jun 07, 2013 5:32 pm

ERROR 1170 (42000) at line 102607:

Post by hillmandj »

Hi,

I created a Access to SQL dump file using Bullzip, but when I imported it into MySQL Workbench, I received this error: ERROR 1170 (42000) at line 102607: BLOB/TEXT column 'SID' used in key specification without a key length

A number of the tables were imported, but not all of them. Not sure how to fix this issue, since the database that was dumped is quite massive. Any suggestions?

Thanks!

-D