I'm getting the same error:

SQL Error: Duplicate entry '6-4' for key 1

I've tried this:

UPDATE ubbt_USER_GROUPS SET GROUP_ID = '4' WHERE GROUP_ID = '5' AND USER_ID > '1'

and this:

UPDATE ubbt_USER_GROUPS SET GROUP_ID = '4' WHERE GROUP_ID = '5' AND USER_ID > 1

and get the same error.


- Allen
- ThreadsDev | PraiseCafe