Announcement

Collapse
No announcement yet.

Invalid SQL: INSERT INTO searchtowords_n

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

  • Jeanius!
    replied
    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!

    Leave a comment:


  • Mark.B
    replied
    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.

    Leave a comment:


  • Jeanius!
    started a topic Invalid SQL: INSERT INTO searchtowords_n

    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: [URL="http://forums/create-content/Text/"]http:///forums/create-content/Text/[/URL]

    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!
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X