Announcement

Collapse
No announcement yet.

Search failing for thread titles but not for post

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

  • Search failing for thread titles but not for post


    When users are logged in, they have permission to search my forum. They can search through posts but not thread titles. It results in this error being thrown:

    Note there are thousands of threadIDs but I've removed them here for readability

    Code:
    Database error in vBulletin 3.8.10:
    
    Invalid SQL:
    
    Invalid SQL:
    
    SELECT
    thread.threadid, thread.forumid, post.userid
    FROM thread AS thread
    
    INNER JOIN post AS post ON(thread.threadid = post.threadid )
    WHERE post.postid IN(670139,668155,668130,660115,665406,
    
    [there are thousands of threadIDs here so I've removed most of them for readability]
    
    ,6564158,6564206);
    
    
    MySQL Error : MySQL server has gone away
    Error Number : 2006
    Request Date : Friday, January 17th 2020 @ 05:05:46 PM
    Error Date : Friday, January 17th 2020 @ 05:05:47 PM
    Script : http://www.mysite.com/forums/search.php?do=process
    Referrer : https://www.mysite.com/forums/search.php
    
    Classname : vB_Database_MySQLia

    VBulletin 3.8.10
    CentOS dedicated server
    Web Server: Apache v2.2.15 (cgi-fcgi)
    PHP 5.5.8
    MySQL 5.5.62
    MySQL Packet Size: 1MBWeb Server: Apache v2.2.15 (cgi-fcgi)
    PHP 5.5.8
    MySQL 5.5.62
    MySQL Packet Size: 1MB


    Any suggestions greatly appreciated.

  • #3
    The answer was to increase max_allowed_packet on the server as the query size was beyond the 1MB limit. I increased mine to 2MB and it will perform the search now.

    On a centOS box do this:

    To change the "max_allowed_packet" using Webmin navigate to "Servers > MySQL Database Server > MySQL Server Configuration > Maximum packet size": X MB Click on "Save and Restart MySQL" button



    Last edited by cronjob77; Tue 28th Jan '20, 5:02am.

    Comment

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