Jump to content
Sign in to follow this  
Gyakutsuki

Newsletter & Subscribtion for MS2

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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 = 'test@test.com'

 

[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:

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


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

Share this post


Link to post
Share on other sites

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 :)

Share this post


Link to post
Share on other sites

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...

Share this post


Link to post
Share on other sites

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 by Jan Zonjee

Share this post


Link to post
Share on other sites

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/unsubscribe.php?email=emailTOunsubscribe@hotmail.com

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


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

Share this post


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

Share this post


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

Share this post


Link to post
Share on other sites

Now it work normal back!! :D

 

Thanks John for your guidance.

 

Why the contribution telling us to delete the newsletter table?

Share this post


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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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" ?

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
Sign in to follow this  

×