mercredi 29 juin 2016

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

This is not a question but a self generated problem/question and solution that I found working. I thought it would be decent courtesy to share since there was not a complete working solution I could find.

The error generated in phpMyAdmin is:

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

There are several working solutions depending on your exact scenario.

For example, as long as all of your AI or Unique identifier field are unique then you can simply alter the table and ensure this is the Primary key and set to unique value.

I solved this with this solution on one of my tables.

The other table had multiple AI int values that were the Primary field, but there were multiple values of the same kind.

The simple fix for this was to just add a column to the end of the table as Unique AI Int. Basically all MySQL is saying is it needs a unique value in each record to differentiate the rows.

Hope this was helpful.

Aucun commentaire:

Enregistrer un commentaire