Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forums | Webyog

Tools to manage and monitor MySQL databases

Error: 1070

This topic is empty.

Viewing 1 reply thread

Author

Posts
- March 22, 2011 at 11:03 pm #32081
  
  peterlaursen
  Participant
  
  The error is a server error – not a SQLyog error – and is listed here:
  
  http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html#error_er_too_many_key_parts
  
  What is server version? Do you use excessive Foreign Keys and other type of keys and indexes? The error you get you will get with any client – not only SQLyog.
  
  But what is the particular operation you are performing when receiving this? During import? Do you import from one server version to another server version?
  
  A google search:
  
  http://www.google.dk/search?client=opera&rls=da&q=mysql+%2B+'Too+many+key+parts+specified%3B+max+16+parts+allowed'&sourceid=opera&ie=utf-8&oe=utf-8&channel=suggest
- March 22, 2011 at 11:24 pm #32082
  
  Scott Thompson
  Member
  
  Yes it is during a data import from a Greentree database using ODBC, I cannot change the number of keys that Greentree uses and if it is a MySQL limit I cannot change that either. Not sure if it is going to have any real impact on the data, guess I will wait and see what happens.
  
  Thanks for the reply.
  
  'peterlaursen' wrote:
  
  The error is a server error – not a SQLyog error – and is listed here:
  
  http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html#error_er_too_many_key_parts
  
  What is server version? Do you use excessive Foreign Keys and other type of keys and indexes? The error you get you will get with any client – not only SQLyog.
  
  But what is the particular operation you are performing when receiving this? During import? Do you import from one server version to another server version?
  
  A google search:
  
  http://www.google.dk/search?client=opera&rls=da&q=mysql+%2B+'Too+many+key+parts+specified%3B+max+16+parts+allowed'&sourceid=opera&ie=utf-8&oe=utf-8&channel=suggest
Author

Posts

Viewing 1 reply thread

You must be logged in to reply to this topic.