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?
![](/forums/attachments/237493/cache/var/www/vhosts/webassist.com/user_uploads/forums/attachments/237493/proportion/dw-double-error1_w360_h100/dw-double-error1_03030937.jpg)
![](/forums/attachments/237493/cache/var/www/vhosts/webassist.com/user_uploads/forums/attachments/237493/proportion/dw-double-error2_w171_h100/dw-double-error2_03030937.jpg)
![](/forums/attachments/237493/cache/var/www/vhosts/webassist.com/user_uploads/forums/attachments/237493/proportion/dw-double-error3_w171_h100/dw-double-error3_03030937.jpg)
![](/forums/attachments/237493/cache/var/www/vhosts/webassist.com/user_uploads/forums/attachments/237493/proportion/dw-double-error4_w181_h100/dw-double-error4_03030937.jpg)