zzzzsys_user Topic is solved

[Duski]

I noticed, that in my zzzzsys_user table there are many duplicated records with the same zzzzsys_user_id. I'd like refine the table, but PHPmyAdmin says "Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available". Thats why I'm not able to delete duplicated records nor set an unique column, because there are many duplicated records. A vicious circle situation
What can I do ?

[kev1n]

Export the table to an sql file, truncate the table, remove the dups and import again

[kev1n]

BTW if there's a pk this shouldn't happen

[Duski]

But there was no PK after install
I'l try export, repair and import the table.
Thanx.

[Duski]

Table is repaired.