Announcement

Collapse
No announcement yet.

How to identify sql error

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

  • How to identify sql error

    Not sure what to make of this error;

    Invalid SQL:

    INSERT INTO postlog
    (postid, useragent, ipaddress, dateline)
    VALUES
    (280407, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.130 Safari/537.36', '00.000.000.000', 1582767898);

    MySQL Error : Unknown column 'ipaddress' in 'field list'
    Error Number : 1054

  • #2
    This is a blind guess but are you using IPv6 on the server? 3.8 only works with IPv4.

    Comment


    • #3
      We need context. Different errors can mean different things depending on what you were doing when you got the error.
      MARK.B | vBULLETIN SUPPORT

      TalkNewsUK - My vBulletin 5.6.0 Demo
      AdminAmmo - My Cloud Demo

      Comment


      • #4
        Originally posted by Mark.B View Post
        We need context. Different errors can mean different things depending on what you were doing when you got the error.
        Just making a post.

        But here's what happened up to the point;

        The forum was moved to a different host due to the need for a lower php version. The migration went well, did have an issue with an add on that Trevor helped identify. Once that was disabled the forum appeared to be working fine, a few hours later this issue popped up.

        Code:
        Database error in vBulletin 3.8.4:
        
        Invalid SQL:
        
        INSERT INTO postlog
        (postid, useragent, ipaddress, dateline)
        VALUES
        (280414, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.130 Safari/537.36', 123.456.789.012', 1582800525);
        
        MySQL Error : Unknown column 'ipaddress' in 'field list'
        Error Number : 1054
        Request Date : Thursday, February 27th 2020 @ 10:48:45 AM
        Error Date : Thursday, February 27th 2020 @ 10:48:45 AM
        Script : http://www.adkforum.com/newreply.php?do=postreply&t=27533
        Referrer : http://www.adkforum.com/newreply.php?do=newreply&noquote=1&p=280411
        IP Address : 77.164.108.166
        Username : Numnum
        Classname : vB_Database_MySQLi
        MySQL Version : 10.2.31-MariaDB
        Server : 
        User Agent

        Comment

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