Address Book Question

[ecarter]

I've got entries in the address book of spam addresses. I've since deleted the tickets associated with the addresses. Due to some bad inbox rules, the addresses registered as "#Nonspam".

So, when I click on one of the contacts I see:
0 open ticket(s) | 0 closed ticket(s) | compose

At the bottom - is there a way to delete all the addresses with no tickets associated with them?

If not, can I simply delete all the addresses from my database in the "address" table - or are there other tables I'd need to update as well?

[Hildy]

You'd need to delete from address and address_auth, at a bare minimum, but you've also got ties to tickets, audit logs, etc. (For your purposes (spam), this probably isn't a big deal.)

[ecarter]

Thanks, the address_auth table was empty - not sure if that's a problem. I just deleted all the addresses from the address table and they disappeared. I made sure to mark them "banned" then did a SQL query to delete all the entries with is_banned=1

[Hildy]

The address_auth table is for the Support Center login info, basically, so you may just not be using that.

[ecarter]

Ah ok good. :) thanks for the help!