Webguyz,

That is easy to do BUT ... what I see happening is that when a new entry gets posted for say ... domain id 6, all the entries for that domain get the most current date.  Perhaps you can see what I did wrong.

Added a column "date_added"  with a default value of "datetime"

SFE does not CARE about extra fields but will not write them.  It looks like when an entry is added by SFE, it re-writes all entries for that domain ID so that you will propably loose the extra date and a new date will be written.  So .... I was looking at adding a table for referance that is triggered by changes BUT I still have to work out how to get around the re-write of all the entries.  Or ... I am not fully understanding what is happening when an entry is added by SFE.

Very cool. Thanks!

// New to VersionNumber = '3.5.3.677';
{TODO -cNew : SpamFilter Enterprise was deleting and re-inserting the entire AutoWhiteListForceDelivery list in the database when appending a new entry, possibly causing data loss in high traffic scenarios. This process was rewritten to append the new individual records only}

Solved my issue!  Thanks

jerbo128 wrote: Will the .677 look for duplicates in tables.  I have noticed that I have a fair amount of them in the autowhitelist table.    If 677 will not look for them- is it a problem having them?  If so... Anyone have a bit of SQL code that will remove duplicates? jerbo128

Are the duplicates created by SpamFilter, or by some other process..? We could not duplicate this, as in having SpamFilter create the dupes.
We were however able to create the duplicate entries manually in the database, there's nothing SpamFilter can do in that case... it will not remove the dupes once they are in there.

For the SQL:
Make a backup of your autowhitelist 1st!

DELETE FROM tblwl_autowhitelistforcedelivery
WHERE     (id IN
                            (SELECT     id
                               FROM          tblwl_autowhitelistforcedelivery AS F
                               WHERE      EXISTS
                                                             (SELECT     email, COUNT(id) AS Expr1
                                                               FROM          tblwl_autowhitelistforcedelivery AS tblwl_autowhitelistforcedelivery_2
                                                               WHERE      (email = F.email)
                                                               GROUP BY email
                                                               HAVING      (COUNT(id) > 1)))) AND (id NOT IN
                            (SELECT     MIN(id) AS Expr1
                               FROM          tblwl_autowhitelistforcedelivery AS F
                               WHERE      EXISTS
                                                             (SELECT     email, COUNT(id) AS Expr1
                                                               FROM          tblwl_autowhitelistforcedelivery AS tblwl_autowhitelistforcedelivery_1
                                                               WHERE      (email = F.email)
                                                               GROUP BY email
                                                               HAVING      (COUNT(id) > 1))
                               GROUP BY email))



PS - the SQL code came from: http://www.4guysfromrolla.com/webtech/sqlguru/q051200-2.shtm l


Edited by LogSat