Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Newsletters & Subscribers OSC 2.3


Clau123

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.

Link to comment
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.

Link to comment
Share on other sites

  • 4 weeks later...
  • 3 weeks later...

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

Link to comment
Share on other sites

  • 3 weeks later...

@ 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

Link to comment
Share on other sites

  • 2 weeks later...

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?

Link to comment
Share on other sites

  • 3 weeks later...

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
Link to comment
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?

Link to comment
Share on other sites

  • 2 years later...

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

Link to comment
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

Link to comment
Share on other sites

  • 2 weeks later...

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

Anthony David

AllThingsTrendy.com

Link to comment
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

Link to comment
Share on other sites

  • 1 month later...

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

 

Link to comment
Share on other sites

  • 2 years later...
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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...