ERROR 1170 (42000) at line 102607:

General usage of Access to MySQL

Moderator: jr

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

ERROR 1170 (42000) at line 102607:

Post by hillmandj »


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?


Post Reply