Meenu Posted March 10, 2008 Share Posted March 10, 2008 hi i have the same problem how can u solve it. i read all u r msg,but not get any solutions.........plz help me ok i solved this problem............... Quote Link to comment Share on other sites More sharing options...
letmelearn Posted March 14, 2008 Share Posted March 14, 2008 I am using this contribution, Newsletter Unsubscirbe, together with this contribution and but without bulk-mailer. And i have at the moment managed to come to a point where visitor receive a link in his/her e-mail which can be used to unsubscribe. Problem I am now facing is this that the query I am carry out, listed below: tep_db_query("delete from " . TABLE_VISITOR . " where convert ('" . TABLE_VISITOR . "''"."''"email"' using utf8) = '" . $email_to_unsubscribe . "'"); Gives me folloing error: Parse error: syntax error, unexpected T_STRING in unsubscribe_done.php on line 76 I feel I am really close, but can not figure out whats wrong with that query. If someone could please have a loot at it and correct it for me. Thanks in advance. Hi Zahoor, could you post how you solved this problem? Thanks LML Quote Link to comment Share on other sites More sharing options...
bpmcclure Posted March 19, 2008 Share Posted March 19, 2008 Hi, I installed the basic version, no bulk mailer, and it works as advertised. But the error messages do not display correctly. Instead, I get a red bar with Error Symbol "ALREADY_EXIST", for example. None of the error messages seem to work. Any ideas? Thanks, Bruce Quote Link to comment Share on other sites More sharing options...
bpmcclure Posted March 19, 2008 Share Posted March 19, 2008 Hi, I installed the basic version, no bulk mailer, and it works as advertised. But the error messages do not display correctly. Instead, I get a red bar with Error Symbol "ALREADY_EXIST", for example. None of the error messages seem to work. Any ideas? Thanks, Bruce This is the code that appears to be offending. Can someone smarter than me take a look and see what is wrong here? Thanks, Bruce if (!tep_validate_email($to_email_address)) { $error = true; $messageStack->add('visitor', ERROR_TO_ADDRESS); } if ($visitor = tep_db_fetch_array($visitor_query)) { //check if this e-mail already exists in visitor database $error = true; $messageStack->add('visitor', ALREADY_EXIST); } elseif ($customer = tep_db_fetch_array($customer_query)) { //okay, does it exist in our customer database? $error = true; $messageStack->add('visitor', ALREADY_EXIST); } if ($error == false) { // everything is okay $sql_data_array = array('email' => $to_email_address); tep_db_perform(TABLE_VISITOR, $sql_data_array); } } ?> Quote Link to comment Share on other sites More sharing options...
Rikbud Posted March 27, 2008 Share Posted March 27, 2008 Can someone assist me? Everything is fine except when sending bulk newletter I could this msg at Newsletter Manager 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BULKMAILER_LIMIT' at line 1 select customers_firstname, customers_lastname, customers_email_address from customers_temp limit BULKMAILER_LIMIT [TEP STOP] Y had the same problem, you did not complete the sql query. This is the part you didnt insert: INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ( '', 'Bulk Mailer Limit', 'BULKMAILER_LIMIT', '5', 'Defines how many e-mails will be sent at a time', '3', '20', NULL , NOW( ) , NULL , NULL ); INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ( '', 'Bulk Mailer Interval [seconds]', 'BULKMAILER_INTERVAL', '12', 'Defines time between each bulk e-mails send', '3', '20', NULL , NOW( ) , NULL , NULL ); Quote Link to comment Share on other sites More sharing options...
bpmcclure Posted April 6, 2008 Share Posted April 6, 2008 Wondering if it is possible to add an attachment to a newsletter sent out using this contribution? Also wondering if anyone can help with my problem with error messages noted several posts back. Thanks, Bruce Quote Link to comment Share on other sites More sharing options...
bpmcclure Posted April 9, 2008 Share Posted April 9, 2008 Can anyone help with the problem I noted in Post #29 concerning error messages? A new issue has cropped up. My html editor preview and the Newsletter Manager preview look a lot different. The one in OSC shows up with a lot of extra lines between text and especially around tables, and punctuation seems to go out differently than it previews. I got this for don't: don’t. Has anyone figured this out? Thanks, Bruce Quote Link to comment Share on other sites More sharing options...
tsvenkat Posted June 4, 2008 Share Posted June 4, 2008 (edited) ok i solved this problem............... I've got this installed -- thanks for the needed contribution. However, I can't get it to function with Simple Template System (STS). It shows up, but when I enter an email address, it just gives me an empty template with some of the STS codes showing (i.e. $categorybox, $informationbox). When I turn STS off, it works fine. I've added this to sts_user_code.php: $sts->start_capture(); require(DIR_WS_BOXES . 'visitoremail.php'); $sts->stop_capture('visitoremailbox', 'box'); Any ideas? hi how did you solve this problem..? plz help Edited June 4, 2008 by tsvenkat Quote Link to comment Share on other sites More sharing options...
Guest Posted June 4, 2008 Share Posted June 4, 2008 It says in the fix to add some lines to /login.php but the bit you need to find: $messageStack->add('create_account', ENTRY_PASSWORD_ERROR); } elseif ($password != $confirmation) { $error = true; $messageStack->add('create_account', ENTRY_PASSWORD_ERROR_NOT_MATCHING); } if ($error == false) { Isn't in login.php Where do you add the code???? Quote Link to comment Share on other sites More sharing options...
makotoshoto Posted June 6, 2008 Share Posted June 6, 2008 It says in the fix to add some lines to /login.php but the bit you need to find: $messageStack->add('create_account', ENTRY_PASSWORD_ERROR); } elseif ($password != $confirmation) { $error = true; $messageStack->add('create_account', ENTRY_PASSWORD_ERROR_NOT_MATCHING); } if ($error == false) { Isn't in login.php Where do you add the code???? Those lines are in /create_account.php tsvenkat, I'm also having the problem with STS (apparently), but nothing shows up on the site. Admin side seems to be ok, but there is no box (tried different places) on the catalogue pages. I'll try and work that out and post here if I manage a fix. Quote Link to comment Share on other sites More sharing options...
makotoshoto Posted June 8, 2008 Share Posted June 8, 2008 (edited) Couldn't quite fix the STS issue, so I just stuck the box in application_bottom, got annoyed with the format, and removed it. However, now newsletters just aren't being sent. It gives me this message in red: Clients that did not receive this newsletter: 2244 Only small packages will be send, as defined by constant BULKMAILER_LIMIT(5 mails) and interval defined by BULKMAILER_INTERVAL (12 seconds). Wait until the counter reachs 0. ? Nothing happens after I click the send button on that page except the "finished sending emails" which I know it didn't. So I try again, letting the first page just sit there for half an hour. Nothing. I've double-checked my installation, which is fine. Changed the email send settings in Configuration as well. Did I miss something beyond clicking the "send" button? <_< Edited: wait, you mean I have to keep going back and doing this over and over and over to send out the newsletter in small allotments? Fun. I blame this all on AOL users having their finger on the "spam" button. Edited June 8, 2008 by makotoshoto Quote Link to comment Share on other sites More sharing options...
stickypod Posted June 30, 2008 Share Posted June 30, 2008 I have this installed and it appears to be working, but it's very confusing. My questions are: 1) Does the newsletter_bulk module send emails to all my customers or just the subscribers in the visitors database? 2) After the limits are set (number of emails and number of seconds between transmissions) do I need to go back and hit the send button over and over or does it run until all email addresses are exhausted? 3) How can I tell who has received the emails or how many were sent? Thanks for your help in advance. These questions are not clear in the instructions. Quote Anyone can buy a camera... it's what you do with it that counts! Sticky Pod www.stickypod.com Link to comment Share on other sites More sharing options...
anblik Posted July 2, 2008 Share Posted July 2, 2008 (edited) I have a different issue with this contrib. Once you enter an email address and push subscribe, it goes to visitoremail.php?action=process with a blank page. The email address is entered into the database just fine. Then you go to send a newsletter, I get this Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/admin/public_html/admin/includes/functions/database.php on line 99 This is my line 99 return mysql_fetch_array($db_query, MYSQL_ASSOC); As reported by swtnhpy, I am also getting the same error message once I send newsletters. Though the newsletter is being received by the cutomers but the errors message still remains in admin. Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/admin/includes/functions/database.php on line 99 can anyone help with this error ? Edited July 2, 2008 by anblik Quote Link to comment Share on other sites More sharing options...
confusedcart Posted July 8, 2008 Share Posted July 8, 2008 Hi all.. When sending messages, I have quite a few customers so how does one increase the BULKMAILER_LIMIT from 5 to 30 or something?? It says this before sending: Only small packages will be send, as defined by constant BULKMAILER_LIMIT(5 mails) and interval defined by BULKMAILER_INTERVAL (12 seconds). I want to send like 30 mails. It will speed things up.. Please help me do this!!! :) Quote Link to comment Share on other sites More sharing options...
confusedcart Posted July 25, 2008 Share Posted July 25, 2008 Hi all, when using the BULKMAILER -- I press send, I get no errors but Im certain that the newsletters are not being sent.. I changed the setting in Admin - Config. - Email Options to smtp Everytime I click the newsletter it says all the people did not receive the newsletter even though I went through the whole interval process etc... I signed up to the newsletter using 3 different email address, it just does not reach any of them!!! I dont know what to do, because I get no errors?? Also, in Admin - Config - Max Values -- I have the BULKMAILER settings twice.. I dont know why??? Someone please help.. Quote Link to comment Share on other sites More sharing options...
GoAia Posted August 1, 2008 Share Posted August 1, 2008 Hi 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. Can anyone help? Lollo Quote Link to comment Share on other sites More sharing options...
Guest Posted August 18, 2008 Share Posted August 18, 2008 Hi all.. When sending messages, I have quite a few customers so how does one increase the BULKMAILER_LIMIT from 5 to 30 or something?? It says this before sending: Only small packages will be send, as defined by constant BULKMAILER_LIMIT(5 mails) and interval defined by BULKMAILER_INTERVAL (12 seconds). I want to send like 30 mails. It will speed things up.. Please help me do this!!! :) Hi ConfusedCart, You can set the bulkmailer limit and interval in the admin section - Configuration - Maximum Values Quote Link to comment Share on other sites More sharing options...
Guest Posted August 18, 2008 Share Posted August 18, 2008 Has anybody made the changes to allow you to see the visitor list in admin, and select individual visitors to email to? How did you do it? Cheers, Jim Quote Link to comment Share on other sites More sharing options...
Guest Posted August 19, 2008 Share Posted August 19, 2008 i am also having problems i am getting error Fatal error: Cannot instantiate non-existent class: email /admin/includes/modules/newsletters/newsletter.php on line 125 here is my newletter.php file class newsletter { var $show_choose_audience, $title, $content; function newsletter($title, $content) { $this->show_choose_audience = false; $this->title = $title; $this->content = $content; } function choose_audience() { return false; } function confirm() { global $HTTP_GET_VARS; $mail_query = tep_db_query("select count(*) as count from " . TABLE_CUSTOMERS . " where customers_newsletter = '1'"); $mail = tep_db_fetch_array($mail_query); $confirm_string = '<table border="0" cellspacing="0" cellpadding="2">' . "n" . ' <tr>' . "n" . ' <td class="main"><font color="#ff0000"><b>' . sprintf(TEXT_COUNT_CUSTOMERS, $mail['count']) . '</b></font></td>' . "n" . ' </tr>' . "n" . ' <tr>' . "n" . ' <td>' . tep_draw_separator('pixel_trans.gif', '1', '10') . '</td>' . "n" . ' </tr>' . "n" . ' <tr>' . "n" . ' <td class="main"><b>' . $this->title . '</b></td>' . "n" . ' </tr>' . "n" . ' <tr>' . "n" . ' <td>' . tep_draw_separator('pixel_trans.gif', '1', '10') . '</td>' . "n" . ' </tr>' . "n" . ' <tr>' . "n" . ' <td class="main"><tt>' . nl2br($this->content) . '</tt></td>' . "n" . ' </tr>' . "n" . ' <tr>' . "n" . ' <td>' . tep_draw_separator('pixel_trans.gif', '1', '10') . '</td>' . "n" . ' </tr>' . "n" . ' <tr>' . "n" . ' <td align="right"><a href="' . tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $HTTP_GET_VARS['nID'] . '&action=confirm_send') . '">' . tep_image_button('button_send.gif', IMAGE_SEND) . '</a> <a href="' . tep_href_link(FILENAME_NEWSLETTERS, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $HTTP_GET_VARS['nID']) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a></td>' . "n" . ' </tr>' . "n" . '</table>'; return $confirm_string; } function send($newsletter_id) { $mail_query = tep_db_query("select customers_firstname, customers_lastname, customers_email_address from " . TABLE_CUSTOMERS . " where customers_newsletter = '1'"); $visitor_query = tep_db_query("select email from " . TABLE_VISITOR); // Instantiate a new mail object $mimemessage = new email(array('X-Mailer: osC mailer')); // Build the text version $text = strip_tags($text); if (EMAIL_USE_HTML == 'true') { $mimemessage->add_html($this->content); } else { $mimemessage->add_text($this->content); } // Send message $mimemessage->build_message(); while ($mail = tep_db_fetch_array($mail_query)) { $mimemessage->send($mail['customers_firstname'] . ' ' . $mail['customers_lastname'], $mail['customers_email_address'], '', EMAIL_FROM, $this->title); } /////Simple Visitor Newsletter while ($visitor = tep_db_fetch_array($visitor_query)) { $mimemessage->send('Visitor' . ' ' . 'Visitor', $visitor['email'], '', EMAIL_FROM, $this->title); } /////Simple Visitor Newsletter $newsletter_id = tep_db_prepare_input($newsletter_id); tep_db_query("update " . TABLE_NEWSLETTERS . " set date_sent = now(), status = '1' where newsletters_id = '" . tep_db_input($newsletter_id) . "'"); } } ?> any advise Quote Link to comment Share on other sites More sharing options...
jer001 Posted November 27, 2008 Share Posted November 27, 2008 Please help I installed News letter with Bulk Mailer and when I click send newsletter there is an error Fatal error: Cannot redeclare class newsletter_bulk in /admin/includes/modules/newsletters/newsletter_bulk.php on line 10 Please help thank you Quote Link to comment Share on other sites More sharing options...
jer001 Posted November 27, 2008 Share Posted November 27, 2008 I fixed the error apparently in STS classes have to be called above the header. :) But now I have another error. The program is not getting any contacts from the database ... Customers which have not yet received this issue of the newsletter: 0 I have setup a test email and I have not recieved the email please help thank you Please help I installed News letter with Bulk Mailer and when I click send newsletterthere is an error Fatal error: Cannot redeclare class newsletter_bulk in /admin/includes/modules/newsletters/newsletter_bulk.php on line 10 Please help thank you Quote Link to comment Share on other sites More sharing options...
jer001 Posted November 27, 2008 Share Posted November 27, 2008 Fixed it I had to copy some of the script to copy the visitors database aswell. Thanking you in advance jeremy I fixed the error apparently in STS classes have to be called above the header.:) But now I have another error. The program is not getting any contacts from the database ... Customers which have not yet received this issue of the newsletter: 0 I have setup a test email and I have not recieved the email please help thank you Quote Link to comment Share on other sites More sharing options...
swtnhpy Posted December 5, 2008 Share Posted December 5, 2008 What was your fix as I am having the same issue? I am also using newsletter_products....any way to combine these two??? Quote Link to comment Share on other sites More sharing options...
altenter Posted December 9, 2008 Share Posted December 9, 2008 (edited) Great contribution, thanks! Only problem I am facing is that when customer clicks the unsubscribe link in the newsletter, the email address to be unsubscribed is not shown. this is my admin/includes/modules/newsletter_bulk.php unsubscribe part: $text = strip_tags($text); if (EMAIL_USE_HTML == 'true') { $mimemessage->add_html($this->content . TEXT_UNSUBSCRIBE . '<a href="' . HTTP_CATALOG_SERVER . DIR_WS_CATALOG . FILENAME_UNSUBSCRIBE . "?email=" . $mail['customers_email_address'] . '">' . TEXT_LINK_UNSUBSCRIBE . '</a>'); Edited December 9, 2008 by altenter Quote Link to comment Share on other sites More sharing options...
12spiros21 Posted December 20, 2008 Share Posted December 20, 2008 HiJust 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. Can anyone help? Lollo 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. 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.