Error subscribe from all lists

gdvmb · **Joined:** Mon Jul 19, 2010 11:18 am **Posts:** 9

Hello,

When calling lm from php, I'm not sending any list name to make sure the unsubscription runs on all lists:

lm.php?cmd=unsubscribe&email=test@fiveseasons.be

But I'm getting:

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 ') AND ( `fld_email` = 'test@fiveseasons.be' )' at line 1
DELETE LOW_PRIORITY FROM `tbl_mlm_sub` WHERE ( ) AND ( `fld_email` = 'support@fiveseasons.be' )

The WHERE ( ) causes the problem.

Is this the way to force unsubscription from ALL lists?

Thx.

stanbusk · **Joined:** Wed Dec 28, 2005 9:13 pm **Posts:** 6732

Are you using MLM 3.0.7?

gdvmb · **Joined:** Mon Jul 19, 2010 11:18 am **Posts:** 9

No I'm using several previous versions. Can I simply overwrite the files in the /lm folder with the new version and update lm_settings?

Thx

stanbusk · **Joined:** Wed Dec 28, 2005 9:13 pm **Posts:** 6732

Yes, there are lots of posts in this forum explaining that. It is just as simple as replacing those files except the lm_settings.php file!

gdvmb · **Joined:** Mon Jul 19, 2010 11:18 am **Posts:** 9

Many thanks!

digitalomni · **Joined:** Wed Oct 03, 2012 1:19 am **Posts:** 1

Just got this message.

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 '' at line 1
DELETE LOW_PRIORITY FROM `tbl_mlm_sub` WHERE

I am using 3.0.8

stanbusk · **Joined:** Wed Dec 28, 2005 9:13 pm **Posts:** 6732

What were you doing when you get that error?

Error subscribe from all lists

Who is online