Announcement

Collapse
No announcement yet.

Invalid SQL: INSERT INTO searchtowords_n

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

  • Invalid SQL: INSERT INTO searchtowords_n

    Just received this DB error:

    Code:
    Database error in vBulletin 5.2.2:
    
    Invalid SQL:
    
    INSERT INTO searchtowords_n (`nodeid`,`wordid`,`is_title`,`score`,`position`) VALUES (317139,454,1,10000,2)
    /**searchtowords_n**/;
    
    MySQL Error   : Duplicate entry '454-317139' for key 'wordid'
    Error Number  : 1062
    Request Date  : Monday, August 22nd 2016 @ 07:48:49 PM
    
    Error Date: Monday, August 22nd 2016 @ 07:48:53 PM
    Script: http:///forums/create-content/Text/

    I am due to upgrade to 5.2.3 this week, but just wondering what this is, if I should be worried about it and if it's fixed in the upgrade?

    Thanks!

  • #2
    Have you had this just the once, or multiple times?

    If it's just the once and nothing's happened since, you can ignore it.
    MARK.B | vBULLETIN SUPPORT

    TalkNewsUK - My vBulletin 5.5.6 Demo
    AdminAmmo - My Cloud Demo

    Comment


    • #3
      I've had it a couple of times before but a good while ago.
      Nobody noticed anything, the user that it affected would certainly have let me know if anything went wrong front-end.
      If it's nothing to worry about, then I shan't worry!

      Thanks Mark!

      Comment

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