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 2
when using this query cited in the tutorial:
SELECT * FROM `membercodes`
WHERE `code`='[value]' AND NOT EXISTS( SELECT * FROM `#__comprofiler` WHERE `cb_memberaccesscode`='[value]')
I'm on Joomla 3.7.5. MySQL version 5.6.36-82.1. Any ideas what might be wrong? I'm setting it exactly as in the tutorial. Thanks.
Last edit: 8 years 4 months ago by krileon. Reason: Added [SOLVED] tag to subject