[BadgerDog]

A heads up ...

I've been using this add-on for a few years, right through from v3 and it's great. Thanks for bringing it forward to v4 of vBulletin.

I've encountered my first SQL error with it... I've substituted X's for security...

Database error in vBulletin 4.0.4:

Invalid SQL:
INSERT INTO inactiveuserlog (username,userid,dateline,validemail,email)
VALUES ('Tester's MFG','xxxxx','1282997017','1','jay@xxxxxx.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 's MFG','xxxxx','1282997017','1','jay@xxxxxx.com')' at line 2
Error Number : 1064
Request Date : Saturday, August 28th 2010 @ 08:03:37 AM
Error Date : Saturday, August 28th 2010 @ 08:03:38 AM
Script : http://www.xxxxxx.com/admincp/cronad...ron&cronid=102
Referrer : http://www.xxxxxx.com/admincp/cronadmin.php?do=modify

I believe the problem is the apostrophe in the user name. I re-ran the cron job after changing the user name, simply eliminating the ' before the S and the cron job ran fine, although I'm not sure it actually processed this record a second time.

Am I correct in my assumptions? Why would vBulletin accept registration from a user with an apostrophe then this mod fail on the SQL insert?

Thanks for any feedback...

Regards,
Badger