• Register
Log In
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.9k points
edited by

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.

36.1k points

Related questions

1 vote
2 answers 27 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 morrisBson 3.2k points
1 vote
1 answer 16 views
Problem : I am very new to XAMPP, MYSQL and phpMyAdmin. I have the MYSQL table which contains nearly the 7 million records. When I try to access the big table from my phpMyAdmin I always face below error: Fatal error: Maximum execution time of 30 seconds ... a maximum execution time to the maximum possible value. I am very confused about this error so looking for help on this XAMPP error.
asked May 18 Martin K 6.6k points
0 votes
1 answer 130 views
Problem : Currently I am facing many problems because of below message I have tried everything that I could, but below message is not going away: “The secret passphrase in configuration (blowfish_secret) is too short.” I am working on Windows, I have already restarted ... to clear the browser history and cookies in my browser but still I am facing the error. How can I fix the error?
asked Feb 24 mphil 2.3k points
0 votes
1 answer 88 views
Problem : I am trying to learn the pSQL. I recently moved my Laravel App from the MySQL to pSQL. But now I keep on getting below error. “The Response content must be a string or object implementing __toString(), "boolean" given.” I have the API that was returning my promotion before but now it only returns the above error. Can anyone suggest me solution on above error ?
asked Feb 13 mphil 2.3k points
2 votes
1 answer 10 views
Problem : I am very new to PHP. I am trying to retrieve the image name and then explode and finally to display it. But my problem is I am getting extra blank image in my output. I am struggling to remove the extra blank image from the output. My Php code as below: <?php ... ($myimages as $myimage){ echo "<img src='{$myimage}' height='200' width='300' />"; } ?> Kindly guide me in fixing the issue.
asked Mar 24 morrisBson 3.2k points