Page 1 of 1

zzzzsys_user

Posted: Sun Feb 13, 2022 12:18 pm
by 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 ?

Re: zzzzsys_user

Posted: Sun Feb 13, 2022 12:24 pm
by kev1n
Export the table to an sql file, truncate the table, remove the dups and import again

Re: zzzzsys_user

Posted: Sun Feb 13, 2022 12:25 pm
by kev1n
BTW if there's a pk this shouldn't happen

Re: zzzzsys_user

Posted: Sun Feb 13, 2022 12:29 pm
by Duski
But there was no PK after install :-(
I'l try export, repair and import the table.
Thanx.

Re: zzzzsys_user

Posted: Sun Feb 13, 2022 7:30 pm
by Duski
Table is repaired.