• Register
0 votes

Problem :

I am trying to import mySql database which was originally an access database into phpmyadmin and its giving me following error:
incorrect table definition; there can be only one auto column and it must be defined as a key
6 5 3
6,930 points

Please log in or register to answer this question.

1 Answer

0 votes

Solution :

For those of you that got here in search of the #1075 error  then you should know that this happens if you set your index /autoincrement column in the form at first after that added some new columns and then at last wanted to submit the form. I guess when you add more columns the phpMyAdmin does some kind of background refresh and loses the "primary" information. So you still see it in your form but in the background in the SQL query it does not have this information any more.

So the solution is to deselect your primary column and set it again. It solves my issue.

9 7 4
38,600 points

Related questions

0 votes
1 answer 9 views
Problem: How do I correct the error from MySQL 'you can only have one auto increment column'.
asked Mar 19 ummesalma 25.2k points
0 votes
1 answer 2 views
Problem: How to solve this error? .. I Can't create table errno 150
asked Mar 25 Ifra 24.4k points
0 votes
1 answer 29 views
I want to know how to store multiple values in single column in MysQl.
asked Sep 29, 2020 Daniel Anderson 4k points
0 votes
1 answer 245 views
Problem: When i try to setup my databse using xampp phpmyadmin i am getting an 1932 error table 'phpmyadmin.pma__tracking' doesn't exist in engine. I need assistance how can we overcome this error.
asked Nov 13, 2020 prog_learner 2.5k points
1 vote
2 answers 100 views
Problem : I am very new to XAMPP. I have recently installed the XAMPP on the Windows machine. But suddenly I have started getting below error: Connection for controluser as defined in your configuration failed. I had my MySQL database installed on my Windows machine and ... access my index.php I guess something is wrong with my XAMPP installation. Can I have expert help on above issue to fix it?
asked Apr 13, 2020 morrisBson 3.2k points
0 votes
1 answer 36 views
0 votes
0 answers 8 views
Problem: the configuration file now needs a secret passphrase (blowfish_secret).
asked Feb 12 Dan phillip 4.8k points
0 votes
1 answer 121 views
0 votes
1 answer 1 view
1 view
Problem: I've been reading in every thread in here that is related to this but I always get it wrong. Please help cause I always get the error "Notice: Array to string conversion" in line "$address[] = mysql_result($row, 0 );" below. Please help. if ($p_address= ... $p_address)) { $address[] = mysql_result($row, 0 ); } $all_address = implode(',', $address); Please help me to fix this. Thanks.
asked Apr 3 Shovo210 13.9k points