'New version of PHPMyAdmin has stopped me being able to edit data [duplicate]

PHPMyAdmin has just been upgraded by my server admin to v4.0.4.2.

Now I am unable to edit rows in the following table:

CREATE TABLE IF NOT EXISTS `product_options` (
  `product_id` int(10) NOT NULL,
  `option_id` int(10) NOT NULL,
  KEY `product_id` (`product_id`,`option_id`)
)

PHPMyAdmin just returns this error message when I browse data in the table:

This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

I don't want a unique column in this table, so how can I edit data? Is there a setting I can change?

Many thanks

MySQL v5.1.70

phpmyadmin

Solution 1:^[1]

Without unique key, there is no way to differentiate between two same records which can exists. Therefore phpMyAdmin can not safely edit the table - you have no clue which of these would end up edited. Do you really want to have duplicate records in this table?

Solution 2:^[2]

All you got to do is add a unique column like one called id with a index = PRIMARY like the pic, or if you have one already that is called id that are numbers just make it PRIMARY

enter image description here

Solution 3:^[3]

You can just add a field that name is "id", and check A_I option.

Solution 4:^[4]

I found a solution which might help someone in future, I had table with id, which was not primary key and not auto increment, i added temp column, made it primary and auto increment, then i edited the id column and then i removed the temp column, after that i changed id to primary and auto increment

Solution 5:^[5]

I had the same issue. In my own case I already had an id column. I dropped the column and recreated it; this time I made it a primary key and ticked A_I (ie Auto-Increment). Everything went fine.

Note: You can only do this if changing your IDs does not affect your work.

Solution 6:^[6]

In my experience, you have more than 2 primary keys or you don't have any primary key.

Solution 7:^[7]

Before checking the AUTO_INCREMENT option, check that the column is INT instead of VARCHAR.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Michal ÄŒihaÅ™
Solution 2	zvzej
Solution 3	Birkhoff Lee
Solution 4	runningmark
Solution 5	Obinna Nnenanya
Solution 6	CertainPerformance
Solution 7	Mike

'New version of PHPMyAdmin has stopped me being able to edit data [duplicate]

Solution 1:[1]

Solution 2:[2]

Solution 3:[3]

Solution 4:[4]

Solution 5:[5]

Solution 6:[6]

Solution 7:[7]