Error i sql syntax

[nordcom]

When a customer try to unsubscribe he get this error: We're sorry, but the email address [email protected] has not been found in any of the lists. Check the address and try again. If you think this is an error please contact us at [email protected].

I recieve 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 ') 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]' )

What is this?

 

[stanbusk]

What version of MLM are you using?

 

[nordcom]

MLM Pro.
Is there a verion number?
anyway, I downloaded it 3 days ago, so it should be the last one.

 

[stanbusk]

The version is inside the lm.php file.

Please send me the unsubscribe URL so I can check it. Also, the error message you receive should include the function where the error happened.

 

[emjayfour]

I have a similar error:

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` = 'no' )' at line 1
DELETE LOW_PRIORITY FROM `tbl_mlm_sub` WHERE ( ) AND ( `fld_email` = 'no' )

 

[stanbusk]

Yes, this happens because no list name were provided to the script command.

 

[stanbusk]

What were you doing to get that error?