|
#
1
deal with a small bug in phpMyadmin |
 |
|
|
luke1 |
 |
|
|
| Online |
no |
| State |
453 |
| Grouping |
Super Admin |
| Class |
class4 |
| Score |
250 |
| Wealth |
62 |
| Posts |
230 |
| Login |
07:37:57 |
|
|
|
i have added a lot of members in a table, the emails are not unique. Now i need to make emails unique, the phpMyadmin detects the emails are not unique, so it don't allow us to do that, a button for making unique is disabled.
The thing is that i have removed all duplicate emails, the button is still disabled, this could be not serious bug, but we are disabled if we based on this button.
So, if you are sure that you have removed all duplicate email, you need to write a simple sql to run in phpMyadmin:
alter table member modify email varchar(100) unique;
Hits: 303, Date: 2010-05-21 23:56:31
|
|
|
|
|
Post new topic
)
)
Quote
Edit 
