Double Opt-in SQL Issue
Okay, so running through one of Ray's tutorials (I really miss him).
We are using the double opt-in as a subscriber double opt rather than a user situation. It is set up the same way but with a few modifications.
I am on Configure the confirm settings where you manually adjust the SQL statement.
This is my SQL Statement
SELECT *
FROM subscribers
WHERE id = colname LIMIT 1 AND subscribers.randomString = paramrandomString AND subscribers.email = paramemail AND subscribers.randomString <> '0'
When I hit okay, I get the error message.
Has anyone experienced this? If so, what was the issue?