Something wrong with phpmyadmin

[Frankc]

I intensively worked with phpmyadmin during the past few days but a hour or so ago phpmyadmin become relative problematic.

Anyone else experienced this type of behaviour?

1) Right-click on edit a row don't work. Right-click on edit gives popup window with the field data.

2) Delete a row or more and instead of the normal "Do you really want to delete from TABLE where ID = xx" etc, the system now wants to confirm EVERYTHING in that field.

Do you really want to delete from TABLE where ID = 1 AND field 2 = xx AND field 3 = xx and field 4 = xxx. (Even if field 4 (xxx) represent a LONGTEXT field, then the system still say AND field 4 = "xxxxx LONGTEXT .....xxxx")

I already restarted mysql as well as my computer but still the same problem with very slow reaction from phpmyadmin.

Any ideas would be appreciated please?

 

[Frankc]

Explaining above don't let it seems like a major problem but just consider the following if you have a lot to do.

If you select 10 data rows and click delete.

Instead of a confirm deletion message with 10 rows, one for each data row where ID = 1 ... up to... 10, the system instead

Start processing and display ALL data in above 10 rows so if some of the fields in a row is longtext or whatever, a large amount of data are displayed and if you click yes, the system then compare and check each and every field with the generated field = xxx statement.

 

[Frankc]

My error sorry.

(During database manipulation I change the primary key to index and forgot to change it back to primary key)

</thread>