When PT is enabled, some users cannot Activate account.
I'm getting a few users with activation problems for awhile now. This doesn't happen to all new users.
The user registers and then get an activation e-mail with the activation link. They click on the link and instead of being verified, they are welcomed with a database message:
PHP Code:
Database error in vBulletin 4.1.5:
Invalid SQL:
SELECT activationid, usergroupid, emailchange
FROM vb4_useractivation
WHERE activationid = '6251f507e4074f711649a4250c8526537fc161cf'
AND userid =
AND type = 0;
MySQL Error : 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 'AND type = 0' at line 5
Error Number : 1064
Request Date : Sunday, August 7th 2011 @ 07:00:27 PM
Error Date : Sunday, August 7th 2011 @ 07:00:27 PM
Script : http://domain.com/forum/register.php?a=act&u=434475&i=6251f507e4074f711649a4250c8526537fc161cf
Referrer :
IP Address : xx.xx.xx.xx
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :
I have a lot of modifications installed so going through disabling all of them is quite tedious. What I did to troubleshoot was disable a mod, then go and check if the activation link works. I disabled PT as one of my last modifications since I didn't expect it to be the problem.
Anyways, after disabling PT, I was able to successfully activate an account instead of getting the database error.
Right now PT is a pretty important feature on my forum, but new users are important as well. I will be manually activating these new members so I can still use PT.
Hope you can look into this issue. Thanks