F22-Raptor Posted January 25, 2009 Share Posted January 25, 2009 I just finished installing this contribution (ver. 2.1) but I can't find the newsletter_bulk module in the drop down list in Newsletter Manager. Also, no emails are sent out anymore if I use the existing newsletters modules (newsletter or product_notification). On the page shown after the user sign up for the newsletter there is a graphic missing in the corner, the path is: /images/table_background_visitor.gif is table_background_visitor.gif part of the initial installation of osC or was it supposed to come with the Simple Visitor Newsletter package? Everything else seems to be OK but if I can't send my newsletters then this contribution doesn't help me at all. Any suggestions are welcome. Thanks Quote Link to comment Share on other sites More sharing options...
Guest Posted February 26, 2009 Share Posted February 26, 2009 I am trying to install this but when I get to step 6 in the install.txt I am not sure which file I am supposed to add the include(DIR_WS_BOXES . 'visitoremail.php'); into. Thanks for a needed contrib. Blaine I have decided to put this on my column_left but I suppose you can put it anywhere you want it to be. My trouble is in Step 7! My instructions read: Step 7. Run this statment in phpMyAdmin (or your fav database program) CREATE TABLE `visitor` ( `email` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL , PRIMARY KEY ( `email` ) ) ENGINE = MYISAM ; Where is this "phpMyAdmin" file ??? Quote Link to comment Share on other sites More sharing options...
Guest Posted April 21, 2009 Share Posted April 21, 2009 I think I've finally got this add on working for me, except for one part. There is not unsubscribe link in the email being sent out, even though I have installed the appropriate addon for the unsubscribe link to show up in the email. I've checked the installation over and over and can't seem to figure out why the unsubscribe link is not there. Any ideas? Quote Link to comment Share on other sites More sharing options...
RobiD Posted June 26, 2009 Share Posted June 26, 2009 (edited) Can someone please tell me how to send HTML emails. Do I have to enable it somewhere? I have tested using Newsletter manager but it's still text only. I am using STS template and it's taken forever to get even just the box to show up where I want it. I have added emails (works) tested duplicate (works). I have read somewhere in this thread about a dropdown menu regarding the html newsletters -- where's that? I've gone through ever menu item and check everything. Do I need to change details in the Email Options under Configuration? Please help, my head hurts. David F22-Raptor - have you had any luck? Also, here's the image you're missing: http://www.techstufftrading.com.au/images/...und_visitor.gif Edited June 26, 2009 by RobiD Quote Link to comment Share on other sites More sharing options...
RobiD Posted June 26, 2009 Share Posted June 26, 2009 (edited) I have the same problem, but i did not find the solution yet. Does someone have the sollution to this problem: Just installed this nice contribution, but get this message when trying to send text newsletter through newsletter_bulk: "1146 - Table 'yournutri_life.TABLE_CUSTOMERS_TEMP' doesn't exist select * from TABLE_CUSTOMERS_TEMP" the table is there after installation according to instructions. Answered the question myself. You have to change the Email Options under Configuration to Use MIME HTML when sending emails, then when you go into Newsletter manager and either edit an existing newsletter, or create, the dropdown menu is then on that page. Ok, so now I'm up to here. Anyone sort this one??? Seems to be a common problem so I'm sure there is a simple answer. Thanks David Edited June 26, 2009 by RobiD Quote Link to comment Share on other sites More sharing options...
RobiD Posted June 26, 2009 Share Posted June 26, 2009 Ok, for the next person who has this problem, here is the solution. The TABLE_CUSTOMERS_TEMP has to be defined in /admin/includes/database_tables.php define('TABLE_VISITOR', 'visitor'); define('TABLE_CUSTOMERS_TEMP', 'customers_temp'); The instructions left out defining the customers temp table. Quote Link to comment Share on other sites More sharing options...
RobiD Posted June 26, 2009 Share Posted June 26, 2009 Ok, for the next person who has this problem, here is the solution. The TABLE_CUSTOMERS_TEMP has to be defined in /admin/includes/database_tables.php define('TABLE_VISITOR', 'visitor'); define('TABLE_CUSTOMERS_TEMP', 'customers_temp'); The instructions left out defining the customers temp table. I wish I had read this post before I started the install of this conbribution. It needs a lot of work to be ok. The instructions for installation is incomplete. It is missing vital instructions to get it working. It has poor customer management ie: who to send to and who not to. It completely messed up my shopping cart template. I am not being inflammatory here, just wish that someone had written it before I found it. Simple solution is to export your customers details from your database either directly from PHPmyAdmin or such or there is a contribution. Then just import into phpList and you can do everything. David Quote Link to comment Share on other sites More sharing options...
thinkingforward Posted August 5, 2009 Share Posted August 5, 2009 Hi, I have installed the original version. It adds to the database ok, but you can not actually view the email addresses within the admin area. is that correct? For example, when I select send mail, I can only see customers who have an account. Many thanks, Chris Quote Link to comment Share on other sites More sharing options...
thinkingforward Posted August 5, 2009 Share Posted August 5, 2009 Also, i'm having a prob with the footer going off centre on the subscription confirmation page. Many thanks! Quote Link to comment Share on other sites More sharing options...
thinkingforward Posted August 5, 2009 Share Posted August 5, 2009 link here Subscription bottom left. ta Quote Link to comment Share on other sites More sharing options...
thinkingforward Posted August 19, 2009 Share Posted August 19, 2009 Anyone had a problem with this not picking up the definitions? Quote Link to comment Share on other sites More sharing options...
abbott75 Posted May 1, 2010 Share Posted May 1, 2010 Hi, I have installed "Simple Visitor Newsletter With HTML Support & Bulk Mail v 2.0" however my newsletters still go out in plain text, and only customers receive them, ie not people who have used the subscribe box. Any tips? Thanks :) Quote Link to comment Share on other sites More sharing options...
Freddy.K Posted May 14, 2010 Share Posted May 14, 2010 (edited) Hello! Trying to install this contribution but nothing is showing up in my shop. I add the following to my column_right.php if (tep_session_is_registered('customer_id')) { } else { include(DIR_WS_BOXES . 'visitoremail.php'); } alas, nothing shows up.. hmm... i don't have a visitoremail.php? Where does that come from? I'm running the slightly outdated 2.2 MS2. Many thanks to anyone who can help me! EDIT: Also, if I manually add an email via the E-mail List the e-mail added won't receive any of the newsletters sent from the Newsletter module under Tools.. any idea? Edited May 14, 2010 by Freddy.K Quote Link to comment Share on other sites More sharing options...
Freddy.K Posted May 14, 2010 Share Posted May 14, 2010 Oookay - I got the box showing by downloading "Simple Visitor Newsletter With HTML Support & Bulk Mail v 2.1" from http://addons.oscommerce.com/info/5196 (being the newbie I am, I thought downloading the latest update/upload would be sufficient ;)) The box works as intended, it adds the (valid) emails entered to the database and sends an automatic confirmation. or wait... no, it spams automatic confirmation emails! Like loads of them! I've gotten 21 so far... B) Does anyone have a clue of what this is all about? Many many thanks in advance! /Freddy ps. You can see my shop live at http://www.slingen.se/catalog (use testuser//testpassword to login) Quote Link to comment Share on other sites More sharing options...
kevinb456 Posted July 9, 2010 Share Posted July 9, 2010 (edited) Found an error in the counting of recipients when using the newsletter module (this was not updated to account for the subscribers in the visitor table). It would previously only count the subscribers in the customers table. Edit: This is only a presentation error on the 'newsletter.php' page - it does not affect the actual sending. Fix is: Open /catalog/admin/includes/modules/newsletters/newsletter.php Find: --------------------------------------------------------------------------- $mail_query = tep_db_query("select count(*) as count from " . TABLE_CUSTOMERS . " where customers_newsletter = '1'"); --------------------------------------------------------------------------- Replace with: --------------------------------------------------------------------------- // REPLACED - To fix error in Simple Visitor Newsletter with HTML Support mod, not counting recipients in both customers and visitor tables. // $mail_query = tep_db_query("select count(*) as count from " . TABLE_CUSTOMERS . " where customers_newsletter = '1'"); // Start of replacement text $mail_query = tep_db_query("select visitor_newsletter_count.count + customers_newsletter_count.count as count from (select count(*) as count from " . TABLE_VISITOR . ") as visitor_newsletter_count, (select count(*) as count from " . TABLE_CUSTOMERS . " where customers_newsletter = '1') as customers_newsletter_count"); // END fix for Simple Visitor Newsletter with HTML Support mod --------------------------------------------------------------------------- Edited July 9, 2010 by kevinb456 Quote Link to comment Share on other sites More sharing options...
ZapMe1 Posted October 24, 2010 Share Posted October 24, 2010 Hi, I hope someone can help with my issue... I've installed this mod, and it displays fine in my store, and seems to function correctly! My issue? I need to add a "Visual Verify Code" to the infobox, to prevent spam mail from robots! I need to add the "circled" code to the place in the "array" that the arrow is pointing! Of course, it is in the wrong place now, as seen in the image below! Can someone please tell me how to "simply" add this code to the array, to get the Verify Image in the proper place within the infobox? Been trying for hours, and only get errors, as I'm not sure how to add this code to an existing array! Quote Link to comment Share on other sites More sharing options...
S-Bay Posted September 12, 2011 Share Posted September 12, 2011 (edited) Hi i need some help here! I install the Simple Visitor Newsletter With HTML Support, Bulk Mail and Admin v 2.2 Some work to install in the osC2.3 but ok Theres a bug in the admin , wend you go by hand put a new email there ,and the email is already in the db just return a page with a error: 1062 - Duplicate entry '[email protected]' for key 'PRIMARY' insert into visitors_email (email) values ('[email protected]') any idea to resolve this ? help please Tks Edited September 12, 2011 by S-Bay Quote Link to comment Share on other sites More sharing options...
vampirehunter Posted August 13, 2012 Share Posted August 13, 2012 Hi i need some help here! I install the Simple Visitor Newsletter With HTML Support, Bulk Mail and Admin v 2.2 Some work to install in the osC2.3 but ok Theres a bug in the admin , wend you go by hand put a new email there ,and the email is already in the db just return a page with a error: 1062 - Duplicate entry 'test@[member='msn'].com' for key 'PRIMARY' insert into visitors_email (email) values ('test@[member='msn'].com') any idea to resolve this ? help please Tks did you get this working? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.