0

I'm trying to join two tables to edit some data in phpymadmin, but I get an error saying "Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available."

Both tables contain a primaray id and also a unique key. How can I solve this?

Tried the following code:

SELECT fights.game_id, f1.lastname, f2.lastname, f1.id, f2.id, wfighter, lfighter, e.date, e.organization, e.event, fights.event_id FROM `fights`
join fighters f1 ON
f1.id = fights.wfighter
join fighters f2 ON
f2.id = fights.lfighter
join event e ON
e.event_id = fights.event_id
where e.organization = '1'
order by e.date desc, fights.game_id desc

https://ibb.co/7R6cJ5J https://ibb.co/44PJHjk

Simson
  • 3,373
  • 2
  • 24
  • 38
Martin
  • 15
  • 5
  • Possible duplicate of [MySQL: Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available](https://stackoverflow.com/questions/40520180/mysql-current-selection-does-not-contain-a-unique-column-grid-edit-checkbox) – Ancaron Oct 28 '19 at 13:46
  • I can't see `organization` column from request in screenshots – boden Oct 28 '19 at 20:38
  • Ancaron: Unfortunately I can't edit the config file of the phpmyadmin. Is there any other solution to this? – Martin Oct 29 '19 at 15:02
  • kbo: The event table consist of id (int11, primary key), organization (varchar 45), date (datetime) and event (varchar 45). – Martin Oct 29 '19 at 15:03
  • maybe somewhat related to https://github.com/phpmyadmin/phpmyadmin/issues/15346 – William Desportes Jan 08 '20 at 14:01

0 Answers0