Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New version of PHPMyAdmin has stopped me being able to edit data

Tags:

phpmyadmin

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

like image 576
SammyBlackBaron Avatar asked Aug 14 '13 08:08

SammyBlackBaron


People also ask

Why database is not showing in phpMyAdmin?

Your app is probably connected using a different, lower privileged user. Try running select user(); from your app and from phpMyAdmin and you will know for sure. Assuming your app is running with a different user, you will need to add privilages for it to access the database you create.


2 Answers

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

like image 150
zvzej Avatar answered Oct 24 '22 12:10

zvzej


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.

like image 35
Obinna Nnenanya Avatar answered Oct 24 '22 12:10

Obinna Nnenanya