When on the /invite page - I receive this error in the logs when clicking the link - any ideas? The response on the site is just an error page and it doesn't load anything else..

PDOException: SQLSTATE[42000]: Syntax error or access violation: 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 1: SELECT u.mail AS mail FROM {users} u WHERE (mail IN ()) ; Array ( ) in _invite_filter_registered_emails() (line 1408 of ../sites/all/modules/invite/invite.module).

CommentFileSizeAuthor
#7 invite-1763686-1-sql_error.patch363 bytesKroKroDile
#3 invitefriendtest1.png57.16 KBbreezing65
#3 invitefriendtest2.png58.34 KBbreezing65

Comments

glekli’s picture

glekli commented

Thanks for reporting. I was not able to reproduce this error message. Could you kindly let us know what text you inserted into the email field, and exactly what version of Invite you were running?

Anonymous’s picture

Anonymous (not verified) commented

Right now I'm running 7.x-2.1-beta2+7-dev - not sure if I updated previously or not - been awhile. I recall having no text inserted into the e-mail field (it was blank). Hope that helps.

breezing65’s picture

breezing65 commented
Assigned: Unassigned » breezing65
Category: bug » task
StatusFileSize
new invitefriendtest2.png58.34 KB
new invitefriendtest1.png57.16 KB

Performed the following to reproduce the sql error when clicking the "Show Registration Link" of the Invite module:

1. Downloaded a fresh copy of drupal-7.15 as well as downloading and installing the Invite module (version 7.x-2.x-dev).
2. On the invite page, I clicked on the "show registration link" with a blank "To" field and the response was: "To field is required."
3. Clicked on the "show registration link" again with a valid email address in the "To" field and the response was: "Your invitation has been successfully created" as well as a display of the registration link for the invitees.
4. Checked reports of recent log messages and no errors were found.

Thus, I am unable to reproduce the sql error and further information and/or explanation is needed from initiator. Otherwise, my recommendation is to close this issue as unexplained or no viable solution can be determined. Thank you for your emails and input to this issue.

Kind regards,
Charles Gordon Jr.

glekli’s picture

glekli commented
Status: Active » Closed (cannot reproduce)

Nice summary, thanks, Charles. One explanation might be that the dev version is constantly regenerated as the repo is updated. This makes it hard to identify the code that caused the error (if it was a dev version.)
Closing the issue.

Anonymous’s picture

Anonymous (not verified) commented
Status: Closed (cannot reproduce) » Active

Thanks for testing it - I'm running 7.14.. sorry, not sure what other info to provide - it's happening on all user roles. It might be some obscure module conflict (I have a quite a few running!)? What is the SQL error even talking about anyway?

pjmcghee’s picture

pjmcghee commented

Hello,

I just installed Invite and I am receiving this error as well. I'm running Core 7.21 and Invite 7.x-2.1-beta2.

The error that get is the exact same as above. I get it if the email field is blank or filled with a bad address and i click either the show link or send invite. all the user can do is hit the back button which is less than ideal. This is a great module and I really want to use it.

Thanks!

KroKroDile’s picture

KroKroDile commented
StatusFileSize
new invite-1763686-1-sql_error.patch363 bytes

Hi,

I've got the same problem when I submit the form with the field 'To' empty.
Here, the patch to correct this error.

KroKroDile.

djween’s picture

djween commented

I am running 7.x-2.1-beta2 on core 7.17 and receive same errors when no email is submitted or an incorrectly formatted email address is submitted. Thanks.