Error subscribe from all lists

[gdvmb]

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 protected]

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` = [email='[email protected]]'[email protected][/email]' )' at line 1
DELETE LOW_PRIORITY FROM `tbl_mlm_sub` WHERE ( ) AND ( `fld_email` = [email='[email protected]]'[email protected][/email]' )

The WHERE ( ) causes the problem.

Is this the way to force unsubscription from ALL lists?

Thx.

 

[stanbusk]

Are you using MLM 3.0.7?

 

[gdvmb]

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]

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]

Many thanks!

 

[digitalomni]

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]

What were you doing when you get that error?