I've google a bit about this can't seem to find a straight answer. Has anyone got the MySQL Error: 1075?
What does this errorcode mean?

Can you post the code or the table definition here ?

post the full error message the DB server vomited

OR if you know how to read mysql doc, you can check it up

---

A little googling, here is the accepted answer on stackoverflow n corresponding code

You can have an auto-Incrementing column that is not the PRIMARY KEY, as long as there is an index (key) on it:

CREATE TABLE members ( 
  id int(11)  UNSIGNED NOT NULL AUTO_INCREMENT,
  memberid VARCHAR( 30 ) NOT NULL , 
  `time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , 
  firstname VARCHAR( 50 ) NULL , 
  lastname VARCHAR( 50 ) NULL , 
  PRIMARY KEY (memberid) ,
  KEY (id)                          --- or:    UNIQUE KEY (id)
) ENGINE = MYISAM; 

---

Follow the link below for better explanation
https://stackoverflow.com/questions/8114535/mysql-1075-incorrect-table-definition-autoincrement-vs-another-key/8114994?utm_medium=organic&utm_source=google_rich_qa&utm_campaign=google_rich_qa

What is the complete error message, including script info? And where are you getting this? I did google search and found some solutions on how to fix MySQL error codes here: https://www.repairtoolbox.com/mysqlrepair.html

Hi,

Trt to fix it, by using MySQL database repair tool. This one is designed to fix MySQL database files, data and objects.