priyesi Posted May 21, 2008 Share Posted May 21, 2008 Hi Everyone I need a help to solve newsletters section problem I had download the the newsletter and subscribers file from your contribution site I had done as per the install text file I got a newsletters option coloum left on my admin panel When I click Newsletters Admin then some error shows Newsletter 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 '-6, 6' at line 1 select newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from newsletters order by date_added desc limit -6, 6 [TEP STOP] and when click the Subscriber Admin then this error had shown 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 '-6, 6' at line 1 select c.subscribers_id, c.subscribers_lastname, c.subscribers_firstname, c.subscribers_email_address, c.customers_newsletter, c.subscribers_blacklist, c.subscribers_email_address from subscribers c order by c.subscribers_id DESC limit -6, 6 [TEP STOP] Other menu are working properly. Newsletter default, header footer and update table Could you please help me to solve this problem. Looking forward your earliest response will be highly appreciated. Thank you Priyesi Quote Link to comment Share on other sites More sharing options...
priyesi Posted May 21, 2008 Share Posted May 21, 2008 Hi Everyone I need a help to solve newsletters section problem I had download the the newsletter and subscribers file from your contribution site I had done as per the install text file I got a newsletters option coloum left on my admin panel When I click Newsletters Admin then some error shows Newsletter 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 '-6, 6' at line 1 select newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from newsletters order by date_added desc limit -6, 6 [TEP STOP] and when click the Subscriber Admin then this error had shown 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 '-6, 6' at line 1 select c.subscribers_id, c.subscribers_lastname, c.subscribers_firstname, c.subscribers_email_address, c.customers_newsletter, c.subscribers_blacklist, c.subscribers_email_address from subscribers c order by c.subscribers_id DESC limit -6, 6 [TEP STOP] Other menu are working properly. Newsletter default, header footer and update table Could you please help me to solve this problem. Looking forward your earliest response will be highly appreciated. Thank you Priyesi Quote Link to comment Share on other sites More sharing options...
priyesi Posted May 21, 2008 Share Posted May 21, 2008 Hi Everyone I need a help to solve newsletters section problem I had download the the newsletter and subscribers file from your contribution site I had done as per the install text file I got a newsletters option coloum left on my admin panel When I click Newsletters Admin then some error shows Newsletter 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 '-6, 6' at line 1 select newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from newsletters order by date_added desc limit -6, 6 [TEP STOP] and when click the Subscriber Admin then this error had shown 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 '-6, 6' at line 1 select c.subscribers_id, c.subscribers_lastname, c.subscribers_firstname, c.subscribers_email_address, c.customers_newsletter, c.subscribers_blacklist, c.subscribers_email_address from subscribers c order by c.subscribers_id DESC limit -6, 6 [TEP STOP] Other menu are working properly. Newsletter default, header footer and update table Could you please help me to solve this problem. Looking forward your earliest response will be highly appreciated. Thank you Priyesi Quote Link to comment Share on other sites More sharing options...
LaurenElise Posted July 6, 2008 Share Posted July 6, 2008 I was thinking about installing this contribution because Id like to be able to let customers sign up for the newsletter without registering. But it seems as though everyone is having nothing but trouble with it, after looking at all these posts. Does anyone recommend this contribution or is there a better alternative? Quote Link to comment Share on other sites More sharing options...
pair Posted August 10, 2008 Share Posted August 10, 2008 Hello everyone, I installed the newsletter module v0.53a. It seems like everything is working as it should, however I have one problem and need your help. When a non registered customers enter their email address and name to subscribe via the left column I get the following error: 1146 - Table 'endless_inks4all.TABLE_SUBSCRIBERS' doesn't exist select subscribers_id from TABLE_SUBSCRIBERS where subscribers_email_address = '[email protected]' [TEP STOP] The table subscribers is installed so I have no idea what may be creating the problem. Can anyone please help; I really need to get this fix. Hopefully it will not take weeks before someone answers please. :blink: Quote Link to comment Share on other sites More sharing options...
pure11 Posted November 2, 2008 Share Posted November 2, 2008 (edited) i installed this, but when i go to sign up and enter my email address , the page loads with this url on top and NOT FOUND page error: http://pureg.net/shop/FILENAME_VISITOR_EMAIL/action/process Edited November 2, 2008 by pure11 Quote Link to comment Share on other sites More sharing options...
pure11 Posted November 2, 2008 Share Posted November 2, 2008 i installed this, but when i go to sign up and enter my email address , the page loads with this url on top and NOT FOUND page error: http://pureg.net/shop/FILENAME_VISITOR_EMAIL/action/process ^^ i fixed the error. im not receiving the confirmation email sent out after signing up? Quote Link to comment Share on other sites More sharing options...
Guest Posted November 20, 2008 Share Posted November 20, 2008 Hi all, can some-one explain to me how I can create multilingual alerts, because now they are only in english and I would like to have them in dutch and french as wel. Thanks in advance! Best regards Geeraard Quote Link to comment Share on other sites More sharing options...
Dayclone Posted December 4, 2008 Share Posted December 4, 2008 Hey guys, I'm getting this error Warning: require(includes/column_left.php) [function.require]: failed to open stream: No such file or directory in /home/asptuni/public_html/new/admin/configuration.php on line 53 Warning: require(includes/column_left.php) [function.require]: failed to open stream: No such file or directory in /home/asptuni/public_html/new/admin/configuration.php on line 53 Fatal error: require() [function.require]: Failed opening required 'includes/column_left.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/asptuni/public_html/new/admin/configuration.php on line 53 Quote Link to comment Share on other sites More sharing options...
Guest Posted December 4, 2008 Share Posted December 4, 2008 Hey guys, I'm getting this error Warning: require(includes/column_left.php) [function.require]: failed to open stream: No such file or directory in /home/asptuni/public_html/new/admin/configuration.php on line 53 Warning: require(includes/column_left.php) [function.require]: failed to open stream: No such file or directory in /home/asptuni/public_html/new/admin/configuration.php on line 53 Fatal error: require() [function.require]: Failed opening required 'includes/column_left.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/asptuni/public_html/new/admin/configuration.php on line 53 This message means that you have no includes/column_left.php file on your server. You should place it on there to remove this message. Best regards Small Craft Quote Link to comment Share on other sites More sharing options...
nlee Posted December 5, 2008 Share Posted December 5, 2008 Hi everyone, I installed the 0.53 version (the 0.54 v looked kinda buggy) Eveything displays fine but I have one problem : in the admin panel, I can see on my subscribers list : 5 people (5 test addresses) but when I am ready to send out a letter, it's written it's gonna be sent to 0 people! And of course I don't receive any letter. I was also wondering if it was normal than I could enter the same address as many times as I want to, I always get the "you've now subscribed" message? O_O and also has someone found an idea to avoid spamming? Thank you for your help :) Quote Link to comment Share on other sites More sharing options...
nlee Posted December 9, 2008 Share Posted December 9, 2008 Anyone please? I'm quite in a hurry... Quote Link to comment Share on other sites More sharing options...
Dayclone Posted December 20, 2008 Share Posted December 20, 2008 I get this error: Warning: Missing argument 3 for newsletter_subscribers::newsletter_subscribers(), called in /home/asptuni/public_html/new/admin/newsletters.php on line 261 and defined in /home/asptuni/public_html/new/admin/includes/modules/newsletters/newsletter_subscribers.php on line 17 Warning: Missing argument 4 for newsletter_subscribers::newsletter_subscribers(), called in /home/asptuni/public_html/new/admin/newsletters.php on line 261 and defined in /home/asptuni/public_html/new/admin/includes/modules/newsletters/newsletter_subscribers.php on line 17 Warning: Missing argument 5 for newsletter_subscribers::newsletter_subscribers(), called in /home/asptuni/public_html/new/admin/newsletters.php on line 261 and defined in /home/asptuni/public_html/new/admin/includes/modules/newsletters/newsletter_subscribers.php on line 17 Warning: Missing argument 6 for newsletter_subscribers::newsletter_subscribers(), called in /home/asptuni/public_html/new/admin/newsletters.php on line 261 and defined in /home/asptuni/public_html/new/admin/includes/modules/newsletters/newsletter_subscribers.php on line 17 Warning: Missing argument 7 for newsletter_subscribers::newsletter_subscribers(), called in /home/asptuni/public_html/new/admin/newsletters.php on line 261 and defined in /home/asptuni/public_html/new/admin/includes/modules/newsletters/newsletter_subscribers.php on line 17 Please help... Quote Link to comment Share on other sites More sharing options...
Dayclone Posted December 21, 2008 Share Posted December 21, 2008 (edited) Also, When I subscribe people it doesn't add thier first name and only adds thier last name. I think I messed up something??? Also when I send the news letter it has no subject, and in the email itself only shows the unsubscribe link... Steve Edited June 5, 2009 by Jan Zonjee Quote Link to comment Share on other sites More sharing options...
Dayclone Posted December 21, 2008 Share Posted December 21, 2008 (edited) Nevermind there was a fix on this... ignore my posts. Edited December 21, 2008 by Dayclone Quote Link to comment Share on other sites More sharing options...
jfkafka Posted February 22, 2009 Share Posted February 22, 2009 Hi, The contrib works great cept for 1 snafu. when user clicks on unsubscribe link in their newsletter email, is taken to: https://****.com/~MYdomain/[email protected] fine so far.. however when the unsubscribe button is clicked the url now reads: http://www.MYdomain.com/unsubscribe_done.p...ribehotmail.com Note that the @ is missing from the email address at the end of the URL this causes the email address not to be found in the customers table if i add the @ to the URL the person is unsubscribed the code in catalog/unsubscribe.php that seems to be the culprit is: $email_to_unsubscribe=$_GET['email']; (i modified the original which was $HTTP_GET_VARS- now deprecated) does anyone know why the @ is missing from the email address? thank you for your insight Quote Link to comment Share on other sites More sharing options...
Ariffshah Posted February 25, 2009 Share Posted February 25, 2009 (edited) Hello guys, after installing 'Newsletter & Subscribers v054' i received error in my admin/tools/newletter manager like this 1146 - Table 'xxxxxxxx_osc1.newsletters' doesn't exist select count(*) as total from newsletters [TEP STOP] Do you know why? as I can't sent newsletter now... what i did is deleted my old newsletter SQL and replaced with the one provided in the contribution. Hope to get some info. best regards. Edited February 25, 2009 by Ariffshah Quote Link to comment Share on other sites More sharing options...
Ariffshah Posted February 26, 2009 Share Posted February 26, 2009 Guys, any master can help me with the problem that I have?. Appreciate your comment and idea. Hello guys, after installing 'Newsletter & Subscribers v054' i received error in my admin/tools/newletter manager like this Do you know why? as I can't sent newsletter now... what i did is deleted my old newsletter SQL and replaced with the one provided in the contribution. Hope to get some info. best regards. Quote Link to comment Share on other sites More sharing options...
jfkafka Posted February 26, 2009 Share Posted February 26, 2009 Guys, any master can help me with the problem that I have?. Appreciate your comment and idea. just a wild guess, did you check your database to make sure you have a table called newsletters? i mention this cuz i didn't see a create table newsletters in the sql file for v54 Quote Link to comment Share on other sites More sharing options...
Ariffshah Posted February 27, 2009 Share Posted February 27, 2009 just a wild guess, did you check your database to make sure you have a table called newsletters?i mention this cuz i didn't see a create table newsletters in the sql file for v54 I did checked into my database and there is no table called newletters. As I mention earlier, i've delete it according to the contribution direction. Should I restore back the old newsletter table to my database? Best regards. Quote Link to comment Share on other sites More sharing options...
jfkafka Posted February 27, 2009 Share Posted February 27, 2009 I did checked into my database and there is no table called newletters. As I mention earlier, i've delete it according to the contribution direction. Should I restore back the old newsletter table to my database? Best regards. That would be my first step Quote Link to comment Share on other sites More sharing options...
Ariffshah Posted February 27, 2009 Share Posted February 27, 2009 Now it work normal back!! :D Thanks John for your guidance. Why the contribution telling us to delete the newsletter table? Quote Link to comment Share on other sites More sharing options...
jfkafka Posted February 27, 2009 Share Posted February 27, 2009 Now it work normal back!! :D Thanks John for your guidance. Why the contribution telling us to delete the newsletter table? You're welcome. Not sure why, maybe it just seemed like a good idea at the time. Quote Link to comment Share on other sites More sharing options...
lupole Posted March 27, 2009 Share Posted March 27, 2009 If anyone is having trouble with the welcome email, privacy policy and unsubscribe links. the following information will fix it. In catalog/includes/lanquages/english/newsletter.php find this line: define('CLOSING_BLOCK3', "\n\n" . 'View our privacy policy at: ' . HTTP_SERVER . DIR_WS_CATALOG . 'privacy.php' . '.'); Change to: define('CLOSING_BLOCK3', 'View our privacy policy at: ' . HTTP_SERVER . DIR_WS_CATALOG . 'privacy.php' . '.'); Hope this helps Quote Link to comment Share on other sites More sharing options...
eleos Posted June 1, 2009 Share Posted June 1, 2009 hello hello very good newsletter but if somebody add the same email nonstop the newsletter will continue welcome him can it be to check the db and if find the user's email to post "u are allready registerd blah blah blah" ? 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.