Clau123 Posted August 24, 2012 Share Posted August 24, 2012 A new Topic for the Contribution Newsletters & Subscribers for Osc 2.3 I still like this Contrib, but it still buggy. I hope some people with more programming experience will take a look at this Contrib and make it a little more stable. Quote Link to comment Share on other sites More sharing options...
Clau123 Posted August 24, 2012 Author Share Posted August 24, 2012 You can find the Contribution here: http://addons.oscommerce.com/info/8540 Quote Link to comment Share on other sites More sharing options...
Clau123 Posted August 25, 2012 Author Share Posted August 25, 2012 Added advanced Bulkmailer with Bulkmailer limit to the Contrib. You can find it in V057 Quote Link to comment Share on other sites More sharing options...
sammedit Posted August 26, 2012 Share Posted August 26, 2012 @@Clau123 How buggy? Quote Link to comment Share on other sites More sharing options...
Clau123 Posted August 26, 2012 Author Share Posted August 26, 2012 On my website it works now. But I don't know if the code is very well. I'm not a programmer, but I think the code is not the way it should be. A lot of people made changes to the contribution in the past. So it should be good if someone with real programming experience should take a look at this contrib. Quote Link to comment Share on other sites More sharing options...
vigux Posted September 22, 2012 Share Posted September 22, 2012 No se ingles, solo les digo que lo he instalado, y los mails llegan en blanco!! Alguien puede ayudarme?? segui todos los pasos Quote Link to comment Share on other sites More sharing options...
hobievi Posted October 12, 2012 Share Posted October 12, 2012 I have around 8000 customers and 15000 newsletter subscribers (including customers). When i try to update my subscribers table with "Update of the table of the Subscribers" (newsletter_update.php); i get INTERNAL SERVER ERROR after around 30 seconds. This is most probably timeout? How to prevent it? I am not the hosting server owner. Quote Thanks, Yavuz Link to comment Share on other sites More sharing options...
ce7 Posted November 1, 2012 Share Posted November 1, 2012 @ Clau123 Hi Claudia, Thank you for the addon. I had installed this one, and found 2 problems. first on SQL file, need to add , '' to the end of the subscribers_default (3, as # # Dumping data for table `subscribers_default` # INSERT INTO `subscribers_default` VALUES (1, 'Module newsletter_subscribers', '', '2002-11-28 09:31:06', 1, 0, 'You can unsubscribe from our newsletter here :', ''); INSERT INTO `subscribers_default` VALUES (2, 'Module newsletter', '', '2005-01-04 03:51:20', 1, 0, '<DIV>You can unsubscribe from our newsletter here :</DIV>', '<DIV>Thank you</DIV>'); INSERT INTO `subscribers_default` VALUES (3, 'Module product_notification', '', '2005-01-04 03:53:10', 1, 0, '<DIV>To unsubscribe please click the following: </DIV>', ''); 2nd, after I installed this one, on the front page, the right column of my website, just all went to below the center part of webpage, how can i fix it? http://postimage.org/image/8fn6tppi7/ many thanks in advance. Lyn Quote Link to comment Share on other sites More sharing options...
hho Posted November 14, 2012 Share Posted November 14, 2012 I installed the contrib no problem (with the sql-fix). But it seems the sql is messing up the site in IE. Everything is right aligned... Works fine with only the box activated and when the sql is removed. Any ideas? Or does anyone know another way / contrib that allows newsletter signup without account? Quote Link to comment Share on other sites More sharing options...
sunrise99 Posted December 5, 2012 Share Posted December 5, 2012 (edited) for php5.3 fixed on admin: Deprecated: Function ereg_replace() is deprecated in /admin/newsletters.php on line 75 Deprecated: Function ereg_replace() is deprecated in /admin/newsletters.php/newsletters.php on line 76 Deprecated: Function ereg_replace() is deprecated in /admin/newsletters.php/newsletters.php on line 77 Deprecated: Function ereg_replace() is deprecated in /admin/newsletters.php/newsletters.php on line 78 admin/newsletters.php look for: ereg_replace change to: $module_subscribers = preg_replace("/[']/", "/\'/", $nlatest_news->module_subscribers); $header = preg_replace("/[']/", "/\'/", $nlatest_news->header); $unsubscribea = preg_replace("/[']/", "/\'/", $nlatest_news->unsubscribea); $unsubscribeb = preg_replace("/[']/", "/\'/", $nlatest_news->unsubscribeb); Edited December 5, 2012 by sunrise99 Quote Link to comment Share on other sites More sharing options...
sunrise99 Posted December 5, 2012 Share Posted December 5, 2012 Also this module have the following error when select send: /admin/newsletters.php?page=1&nID=1&action=send Parse error: syntax error, unexpected ';', expecting T_FUNCTION in/home/public_html/admin/includes/modules/newsletters/newsletter.php on line 129 Newsletter Manager any suggestion? Quote Link to comment Share on other sites More sharing options...
sembrouille Posted December 5, 2012 Share Posted December 5, 2012 try this module : http://addons.oscommerce.com/info/8472 Quote Link to comment Share on other sites More sharing options...
toyzonline Posted January 18, 2015 Share Posted January 18, 2015 I have installed this contribution as needed separate way to subscribe to newsletter than having to sign up for account. I have followed everything but a fault in the SQL is preventing it from working. When I run the query I get the following: SQL query: # # Base for Newsletters v.50+ # # -------------------------------------------------------- # # Table structure for table `subscribers` # CREATE TABLE `subscribers` ( `subscribers_id` int(11) NOT NULL auto_increment, `customers_id` int(11) NOT NULL default '0', `subscribers_email_address` varchar(80) NOT NULL default '', `subscribers_firstname` varchar(40) default NULL, `subscribers_lastname` varchar(40) default NULL, `language` varchar(30) default NULL, `subscribers_gender` char(1) default NULL, `subscribers_email_type` varchar(5) default NULL, `entry_date` date default '0000-00-00', `undeliverable_count` mediumint(11) default '0', `mail_details_customers_id` int(5) default '0', `list_number` int(5) default '0', `source_import` varchar(70) default NULL, `date_account_created` datetime default '0000-00-00 00:00:00', `date_account_last_modified` datetime default '0000-00-00 00:00:00', `customers_newsletter` int(4) default N[...] MySQL said: #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 'TYPE=MyISAM AUTO_INCREMENT=1' at line 35 Any input would be great Cheers in advance Quote Complete Newbie On The Learn - Not A Programmer But Learning As I Go Link to comment Share on other sites More sharing options...
toyzonline Posted January 18, 2015 Share Posted January 18, 2015 I have installed this contribution as needed separate way to subscribe to newsletter than having to sign up for account. I have followed everything but a fault in the SQL is preventing it from working. When I run the query I get the following: Any input would be great Cheers in advance Forgot to add SQL code incase any one who doesn't use this addon has any idea # # Base for Newsletters v.50+ # # -------------------------------------------------------- # # Table structure for table `subscribers` # CREATE TABLE `subscribers` ( `subscribers_id` int(11) NOT NULL auto_increment, `customers_id` int(11) NOT NULL default '0', `subscribers_email_address` varchar(80) NOT NULL default '', `subscribers_firstname` varchar(40) default NULL, `subscribers_lastname` varchar(40) default NULL, `language` varchar(30) default NULL, `subscribers_gender` char(1) default NULL, `subscribers_email_type` varchar(5) default NULL, `entry_date` date default '0000-00-00', `undeliverable_count` mediumint(11) default '0', `mail_details_customers_id` int(5) default '0', `list_number` int(5) default '0', `source_import` varchar(70) default NULL, `date_account_created` datetime default '0000-00-00 00:00:00', `date_account_last_modified` datetime default '0000-00-00 00:00:00', `customers_newsletter` int(4) default NULL, `subscribers_blacklist` int(2) default '0', `subscription_date` datetime default '0000-00-00 00:00:00', `status_sent1` int(2) default '0', `host_name` varchar(25) default NULL, `hardiness_zone` char(3) default NULL, PRIMARY KEY (`subscribers_id`), KEY `list_number` (`list_number`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # -------------------------------------------------------- # # Table structure for table `subscribers_default` # CREATE TABLE `subscribers_default` ( `news_id` int(11) NOT NULL auto_increment, `module_subscribers` varchar(255) NOT NULL default '', `header` text NOT NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `status` tinyint(1) NOT NULL default '0', `news_order` int(2) NOT NULL default '0', `unsubscribea` longtext NOT NULL, `unsubscribeb` longtext NOT NULL, PRIMARY KEY (`news_id`) ) TYPE=MyISAM AUTO_INCREMENT=4 ; # # Dumping data for table `subscribers_default` # INSERT INTO `subscribers_default` VALUES (1, 'Module newsletter_subscribers', '', '2002-11-28 09:31:06', 1, 0, 'You can unsubscribe from our newsletter here :', ''); INSERT INTO `subscribers_default` VALUES (2, 'Module newsletter', '', '2005-01-04 03:51:20', 1, 0, '<DIV>You can unsubscribe from our newsletter here :</DIV>', '<DIV>Thank you</DIV>'); INSERT INTO `subscribers_default` VALUES (3, 'Module product_notification', '', '2005-01-04 03:53:10', 1, 0, '<DIV>To unsubscribe please click the following: </DIV>', ''); # -------------------------------------------------------- # # Table structure for table `subscribers_infos` # CREATE TABLE `subscribers_infos` ( `news_id` int(11) NOT NULL auto_increment, `newsletters_id` int(11) NOT NULL default '0', `module_subscribers` varchar(255) NOT NULL default '', `header` text NOT NULL, `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `status` tinyint(1) NOT NULL default '0', `news_order` int(2) NOT NULL default '0', `unsubscribea` longtext NOT NULL, `unsubscribeb` longtext NOT NULL, PRIMARY KEY (`news_id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ; # # Dumping data for table `subscribers_infos` # # -------------------------------------------------------- # # Table structure for table `subscribers_update` # CREATE TABLE `subscribers_update` ( `newsletters_id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `content` text NOT NULL, `module` varchar(255) NOT NULL default '', `date_added` datetime NOT NULL default '0000-00-00 00:00:00', `date_sent` datetime default NULL, `status` int(1) default NULL, `locked` int(1) default '0', `action` text NOT NULL, `set_order` int(2) NOT NULL default '0', PRIMARY KEY (`newsletters_id`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; # # Dumping data for table `subscribers_update` # INSERT INTO `subscribers_update` VALUES (1, 'Update of the table of the Subscribers', 'Compare the table of the Members recorded on the site and the table of the anonymities having subscribed to the newsletter.', 'newsletter', '2002-11-27 15:13:25', '2002-11-27 15:13:25', 1, 1, 'update', 1); INSERT INTO `subscribers_update` VALUES (2, 'Update of the Names and First names', 'To update the whole of the data concerning the name and the first name modified by Customer Records', '', '2002-11-29 14:42:20', '2002-11-29 14:42:20', 1, 1, 'update', 2); # # Bulkmailer with interval # CREATE TABLE `customers_temp` ( `customers_id` int(11) NOT NULL auto_increment, `customers_firstname` varchar(32) NOT NULL default '', `customers_lastname` varchar(32) NOT NULL default '', `customers_email_address` varchar(96) NOT NULL default '', `subscribers_firstname` varchar(32) NOT NULL default '', `subscribers_lastname` varchar(32) NOT NULL default '', `subscribers_email_address` varchar(96) NOT NULL default '', PRIMARY KEY (`customers_id`) ) TYPE=MyISAM ; 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 [seconden]', 'BULKMAILER_INTERVAL', '12', 'Defines time between each bulk e-mails send', '3', '20', NULL , NOW( ) , NULL , NULL ); Quote Complete Newbie On The Learn - Not A Programmer But Learning As I Go Link to comment Share on other sites More sharing options...
toyzonline Posted January 19, 2015 Share Posted January 19, 2015 Sorted Thanx Quote Complete Newbie On The Learn - Not A Programmer But Learning As I Go Link to comment Share on other sites More sharing options...
ArtcoInc Posted January 21, 2015 Share Posted January 21, 2015 Sorted Thanx And your solution was? burt 1 Quote Link to comment Share on other sites More sharing options...
toyzonline Posted January 29, 2015 Share Posted January 29, 2015 I am getting a very large gap between the newsletter header and the main content. Has anyone else experienced this? Quote Complete Newbie On The Learn - Not A Programmer But Learning As I Go Link to comment Share on other sites More sharing options...
toyzonline Posted February 5, 2015 Share Posted February 5, 2015 Any one? Quote Complete Newbie On The Learn - Not A Programmer But Learning As I Go Link to comment Share on other sites More sharing options...
AllThingsTrendy Posted February 8, 2015 Share Posted February 8, 2015 I installed this contribution and it is only sending email to a very small percentage of my subscribers. I can see from our server mail logs that a few dozen received the email. After that, nothing. I have the bulk mailer set to limit 8 emails every 12 seconds. Thus there, should be no timeouts. I dug into the emails that were sent an I have discovered that none of them include a return-path and thus, they are all being flagged as being sent from [email protected] . Does anyone have a clue how / were we set the return-path. Sending emails without it is sure to get us thrown onto the spam black list. Thanks for any advice! Dave Quote Anthony David AllThingsTrendy.com Link to comment Share on other sites More sharing options...
AllThingsTrendy Posted February 9, 2015 Share Posted February 9, 2015 RE my previous post... I have discovered that the lack of a return-path on the emails is not the result of the Newsletter and Subscribers or Bulk Email code. It is happening on all of our email. Thus, I have posted that question within the General Support forum. However, I'm still baffled that only a fraction of our recipients are receiving the email. Hopefully someone has encountered and resolved this previously. Thanks, David Quote Anthony David AllThingsTrendy.com Link to comment Share on other sites More sharing options...
AusFiero Posted March 11, 2015 Share Posted March 11, 2015 I have installed this contribution and overcome many bugs but it does not send HTML emails. Anyone having this problem? Quote Link to comment Share on other sites More sharing options...
♥Gyakutsuki Posted March 11, 2015 Share Posted March 11, 2015 You can use the mailchimp contribution, It can be better in this case ? Quote Regards ----------------------------------------- Loïc Contact me by skype for business Contact me @gyakutsuki for an answer on the forum Link to comment Share on other sites More sharing options...
AusFiero Posted March 12, 2015 Share Posted March 12, 2015 I know Mailchimp but customers do not. I want to keep it simple and use the internal newsletter system. Quote Link to comment Share on other sites More sharing options...
Psytanium Posted March 6, 2018 Share Posted March 6, 2018 too much spams, i receive 50 fake subscriber everyday. any solution ? Quote Link to comment Share on other sites More sharing options...
Dan Cole Posted March 6, 2018 Share Posted March 6, 2018 35 minutes ago, Psytanium said: too much spams, i receive 50 fake subscriber everyday. any solution ? With this add-on or MailChimp? What are you looking for a solution to? Dan Quote Need help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC community version (CE Phoenix) here. 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.