This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
April 21, 2009 5:55am
Subscribe [3]#1 / Apr 21, 2009 5:55am
Just starting to look at sending an email blast out to members. I went into “CP Home › Modules › Mailing List” and clicked on “View” for the “Default Mailing List” and I just get the error below. Any advice would be much appreciated.
——-
MySQL ERROR:
Error Number: 1054
Description: Unknown column ‘ip_address’ in ‘field list’
Query: SELECT user_id, list_id, email, ip_address FROM exp_mailing_list WHERE list_id = ‘1’
#2 / Apr 21, 2009 6:27am
We’ve seen this a few times. The solution is to remove and reinstall the module. But before you do that, save the email addresses in a text file so you can put them back in again.
#3 / Apr 21, 2009 6:27am
thanks
#4 / Apr 21, 2009 6:29am
Let us know how it goes 😊
#5 / Apr 21, 2009 6:30am
re-installing the module appears to have done the job.
#6 / Apr 21, 2009 6:34am
Glad to hear it 😊 If you need further help, simply start a new thread, please.