clikbiz Posted February 22, 2007 Posted February 22, 2007 Hi, I wanted to add the Newsletter contribution to my site. However, it doesn't appear to work. One of the problem I found through the admin Tools -> Newsletter Manager while trying to send the mail was the following: 1054 - Unknown column 'customers_newsletter' in 'where clause' select count(*) as count from newsletters where customers_newsletter = '1' I realised that the table newsletters doesn't have the customers_newsletter field. Do I need to insert this field into the table? Additionally, when I try to create a new newsletter, when I try to save the newsletter, there's an error message: Error: Newsletter module required However, I've followed the instructions and I'm sure that the required files are in place. On my website, I can see the Newsletter page, however, when I try to sign up, it doesn't appear to register as my details are not inserted into the database and I'm not sent an email. Can you please help. Thanks
clikbiz Posted February 23, 2007 Author Posted February 23, 2007 Anyone have this problem before? I really need to set this up soon and I'm trying to debug the best I can.
davidinottawa Posted February 23, 2007 Posted February 23, 2007 Hi, I wanted to add the Newsletter contribution to my site. However, it doesn't appear to work. One of the problem I found through the admin Tools -> Newsletter Manager while trying to send the mail was the following: 1054 - Unknown column 'customers_newsletter' in 'where clause' select count(*) as count from newsletters where customers_newsletter = '1' I realised that the table newsletters doesn't have the customers_newsletter field. Do I need to insert this field into the table? Yes! Additionally, when I try to create a new newsletter, when I try to save the newsletter, there's an error message: Error: Newsletter module required http://www.oscommerce.com/forums/lofiversion/i...hp/t141421.html http://www.oscommerce.com/forums/lofiversion/i...162231-850.html
Recommended Posts
Archived
This topic is now archived and is closed to further replies.