[TalkVirginia]

Originally Posted by lazerguy_82

Occasionally I get errors. Is it maybe caused by user names that include the '@' sign?

Database error in vBulletin 4.0.2:

Invalid SQL:
INSERT INTO inactiveuserlog (username,userid,dateline,validemail,email)
VALUES ('Bill 'C'','8323','1270189848','1','someemail@sky.com');

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 'C'','8323','1270189848','1','someemail@sky.com')' at line 2
Error Number : 1064
Request Date : Friday, April 2nd 2010 @ 02:30:48 AM
Error Date : Friday, April 2nd 2010 @ 02:30:48 AM
Script : http://www.
Referrer : http://www.
Username : Unregistered
Classname : vB_Database

Looks like the extra quotes in the username are causing it. There are 2 places to change that should fix it. To fix this manually, do the following:

1. Open the reminderemail.php file in the {forumroot}/includes/cron folder
2. Scroll down and insert the following code after 361, just before the line where $sql = "INSERT INTO " is getting set:

$username = addslashes($username);

3. Save and close the file.

4. Open the inactivitylog.php file in your admincp folder
5. Scroll down to line 133 and replace it with the following line of code.

$username = stripslashes($log['username']);


That should do it. I'll upload a new zip with this fix this weekend.