BradSmith, in your first post above, you refer to an error in a SQL statement - a 'Replace'. Where is that to be found in the Newsletter Subscribers mod? Replace can be dangerous, Update might be safer.

1054 errors are caused by running MySQL 4 code on MySQL 5. A search on the error in the forums will give several solutions.