Jump to content
Latest News: (loading..)
Clau123

Newsletters & Subscribers OSC 2.3

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

No se ingles, solo les digo que lo he instalado, y los mails llegan en blanco!! Alguien puede ayudarme?? segui todos los pasos

Share this post


Link to post
Share on other sites

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.


Thanks,

Yavuz

Share this post


Link to post
Share on other sites

@ 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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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 by sunrise99

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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: dot.gif

#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


Complete Newbie On The Learn - Not A Programmer

But Learning As I Go

Share this post


Link to post
Share on other sites

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

);

 


Complete Newbie On The Learn - Not A Programmer

But Learning As I Go

Share this post


Link to post
Share on other sites

Sorted Thanx

 

And your solution was?


If you are running the "official" osC 2.3.4 or 2.3.4.1 download, your installation is obsolete! Get the latest community-supported responsive "Edge" release here

Share this post


Link to post
Share on other sites

I am getting a very large gap between the newsletter header and the main content. Has anyone else experienced this?


Complete Newbie On The Learn - Not A Programmer

But Learning As I Go

Share this post


Link to post
Share on other sites

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 anonymous@allthingstrendy.com  .  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


Anthony David

AllThingsTrendy.com

Share this post


Link to post
Share on other sites

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


Anthony David

AllThingsTrendy.com

Share this post


Link to post
Share on other sites

I have installed this contribution and overcome many bugs but it does not send HTML emails. Anyone having this problem? 

Share this post


Link to post
Share on other sites

You can use the mailchimp contribution, It can be better in this case ?



Regards
-----------------------------------------
Loïc

Contact me by skype for business
Contact me @gyakutsuki for an answer on the forum

Tuto for 2.4 :
- How to Display a new page with app
- How to make Header Tags under app APP
- How to make a
boostrap modal with external element
- My fork based on Osc 2.4

 

Share this post


Link to post
Share on other sites

I know Mailchimp but customers do not. I want to keep it simple and use the internal newsletter system.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×