phpBB • Free and Open Source Forum Software

I have admin authorization for all new accounts turned on. If you register a user and then delete them, then re-register with the same email address that you just "deleted" you get an error message:

General Error
No values specified for SQL IN comparison

The registration works, the end user gets an email, the ACP shows the inactive user awaiting activation, the administrator DOES NOT get an email stating a new account has been created. Activating the account via the ACP or user management activates the user as it is supposed to.

after further testing, it appears that it is related to the username as well as email address. using a different email with the same user name as used before causes the error, as well as using a different username with a previously used email.

more trial and error shows that any user i register, wether they were previously a user or not, as well as any email address used, gives this error now. i believe that it all started when i deleted a user as nothing else changed since i started getting this email.

Could you please provide the full backtrace shown? I do not think this is connected to removing the user since the email address is only checked against the existing users (which is a deleted user not). Anyway, a full backtrace is required here - the full message you get while experiencing the error.

Wait, i was wrong maybe about the backtrace. Is there even one displayed or only the message...

I dont see a backtrace message on the page. the message i put in the original bug report up top is all that i see on the page, there is a link in the upper right hand corner to go back to the forum index and the phpbb logo is on the left, there is also a message telling me that i should notify the administrator with the admin email listed right underneath the error message.

This is strange. Looking at the code i can see where and why this is triggered - if there are no admins with a_user permission available to send the message to. I will try to fix this by also grabbing founder (which may not have this permission set but are able to do this).

	What:	Where:	Country:
vacatures php arbeit php jobs php lavoro php emploi php trabajo php jobs php arbeit php

delete user, sign up again with same email error (fix completed in vcs)

Comments / History

Ticket details

Related SVN changesets

Advertisements