Hi,

I am unable to delete all the referrals created with the message below:

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 'DELETE FROM uc_referrals WHERE referral_id=2' at line 1 query: DELETE FROM uc_referrals_uses WHERE referral_id=2;DELETE FROM uc_referrals WHERE referral_id=2; in /home7/experii2/public_html/modules/uc_referrals-6.x-1.0-beta4/uc_referrals/uc_referrals.module on line 504.

What causes it to happen?

Thank you.

Comments

ryangroe’s picture

ryangroe commented

Sorry, this was fixed in CVS but no release was made. I will release beta5 right now.

The problem is MySQL does not support multiple semi-colon delimited statements, so this module switched to sending each delete statement individually.