Announcement

Collapse
No announcement yet.

Strange SQL error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Strange SQL error

    I received the following email about an SQL error.
    Code:
    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?
    www.cdmagurus.com
    www.cellphone-gurus.com

  • #2
    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?
    Vote for:

    - *Admin Settable Paid Subscription Reminder Timeframe*
    -
    *PM - Add ability to reply to originator only*
    - Add Admin ability to auto-subscribe users to specific channel(s)
    - "Quick Route" Interface...

    Comment


    • #3
      Originally posted by Trevor Hannant View Post
      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.
      www.cdmagurus.com
      www.cellphone-gurus.com

      Comment


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

        Comment


        • #5
          Originally posted by TheNewOne View Post
          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.
          www.cdmagurus.com
          www.cellphone-gurus.com

          Comment


          • #6
            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?
            Translations provided by Google.

            Wayne Luke
            The Rabid Badger - a vBulletin Cloud demonstration site.
            vBulletin 5 API

            Comment


            • #7
              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?
              www.cdmagurus.com
              www.cellphone-gurus.com

              Comment


              • #8
                You would need to get a fixed version from that author.
                Translations provided by Google.

                Wayne Luke
                The Rabid Badger - a vBulletin Cloud demonstration site.
                vBulletin 5 API

                Comment

                widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                Working...
                X