[Forum] Strange SQL error

[whitey10tc]

I received the following email about an SQL error.

Database error in vBulletin 4.1.3:

Invalid SQL:
INSERT IGNORE INTO tagcontent (tagid, contenttypeid, contentid, userid, dateline) VALUES (431, 2, 1841, whitey10tc, 1316664026);

MySQL Error   : Unknown column 'whitey10tc' in 'field list'
Error Number  : 1054
Request Date  : Thursday, September 22nd 2011 @ 04:00:26 AM
Error Date    : Thursday, September 22nd 2011 @ 04:00:26 AM
Script        : [URL]http://cdmagurus.com/forum/cron.php?rand=1316664025[/URL]
Referrer      : [URL]http://cdmagurus.com/forum/forumdisplay.php/481-Srpint-MVNO-general-discussion[/URL]
IP Address    : 74.243.251.166
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

What would cause this? and what was the unregistered user doing?

[Trevor Hannant]

That's a strange one as that's not a column, that's a data value so not sure why it's flagging it as an unknown column...

Have you only had the one email on this?

[whitey10tc]

That's a strange one as that's not a column, that's a data value so not sure why it's flagging it as an unknown column...

Have you only had the one email on this?

Yup only one. I ran the IP to match against users and a user registered with it 2 minutes after I received the email.

[TheNewOne]

maybe some kind of hack using your admin name could be wrong

[whitey10tc]

maybe some kind of hack using your admin name could be wrong

Could be, I'm monitoring the user, and changed all my logins and passwords due to my paranoia. My first thought was someone trying to hack my admincp. But that password changes every 12 hrs. and is locked down to 3 IP's for access.
The user registered using facebook connect right after he triggered this error.

[Wayne Luke]

whitey10tc is supposed to be a number, not a string. Since it is entered into the query as a string without the single quotes around it, MySQL assumes it is another field in the same table.

Need to determine the calling script to determine if this is a bug or other issue. What scheduled task ran at that time?

[whitey10tc]

It looks like automatic thread tagger ran at that time.

Need to determine the calling script to determine if this is a bug or other issue. What scheduled task ran at that time?

[Wayne Luke]

You would need to get a fixed version from that author.