Scot's Scripts FAQs and Module Support
If you don't find the answers here contact us.
Documentation and support for our Miva modules is found here. If you can't find the answer you're looking for contact us and we'll add the information.
Scot's Mailing list / Mailing Lists / Ultimate List Fix - UNIQUE flag error
There are times when a glitch in the database system and when you try to pack a list, you'll see an error like, "an email address was created with the UNIQUE flag and already exists..."
This is not a serious error at all. It just means the list needs to be refreshed.
The first thing to try is the LIST UTILITIES > FIX MAILING LIST option. This is fairly automatic but also does not catch all error. If you still get the UNIQUE flag error after this, follow the steps below, a guaranteed easy fix.
Step 1
Create a temporary mailing list. Call it "temp" or something else obvious.
Step 2
Go to the "list utilities" from the main admin screen and click on the "merge mailing lists" option so merge your problem list into the new temporary list.
Step 3
Select the list you want to merge into: choose the temporary list you made in step 1.
Step 4
In the mailing lists displayed in the next section, find the mailing list that's having probems and check the box next to it.
Step 5
Click the "merge selections" button.
Step 6
Verify that the email addresses were merged (check list totals and any messages the merge process gives you) and if it's OK, clear the original list (use the "clear" link in the mailing list properties page) and then "merge" the temporary list back into the original list.
This cleans out the bad email addresses and any issues with the indexes that might have come up and gives you a fresh list without any issues.
That's all. You don't need to pack the list at this point because the merge includes a list pack.