Hello,
After I updated sSimplenews to 6.x-1.0-beta1 I get the following error:

user warning: 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 ')' at line 1 query: UPDATE simplenews_subscriptions SET activated = 1 WHERE snid IN() in /home/topplcro/public_html/sites/all/modules/simplenews/simplenews.admin.inc on line 796.

Please help me to resolve this error because since I get this error nobody can subscript to my newsletter.

Thank you in adnavce!!!

CommentFileSizeAuthor
#3 simplenews.268748.patch1.33 KBsutharsan

Comments

sutharsan’s picture

sutharsan commented

1. Update to the latest 6.x-1.x-dev version.
2. Check the Newsletter taxonomy setting at admin/content/newsletters/settings - General settings (new in the latest version)
3. Describe the steps preceding the error.

vmira27’s picture

vmira27 commented

Hello Sutharsan,

The ansewrs to your questions:
1) I have the last version of Simplenews (2008 May 04) and Drupal 6.2. I have tried to use Simplenews dev from 2008 Jun 10 but I have the same error.

2) I can't find taxonomy settings on Simplenews settings, and I don't use taxonomy on my site.

3) The error appear only when I choose "Inactive" from update options and I press the update button.

Please let me know if you need more information.

THANK YOU FOR YOUR SUPPORT!

sutharsan’s picture

sutharsan commented
Status: Active » Fixed
StatusFileSize
new simplenews.268748.patch1.33 KB

Thanks you for reporting. The attached patch fixes this problem. The patch is now committed.
You have not selected any subscription to perform the action (Activate, Inactivate, Delete) upon.

You do not need this to subscribe people to your newsletter.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.