Question: When I attempt to use my mailing list, I get the following error:
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'
What causes this, and how can I fix it?
Answer: This problem was due to a defect in an earlier version of ExpressionEngine 1.6.1.
You can fix it one of two ways:
1. Uninstall and reinstall the module.
or
2.Add the following code using PHPMyAdmin or similar program.
ALTER TABLE `exp_mailing_list` ADD `ip_address` VARCHAR(16) NOT NULL AFTER `list_id`