Announcement

Collapse
No announcement yet.

Search failing for thread titles but not for post

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
    cronjob77
    New Member

  • cronjob77
    replied
    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



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

    Leave a comment:

  • Trevor Hannant
    vBulletin Support

  • Trevor Hannant
    replied
    MySQL Error : MySQL server has gone away

    You will need to speak to your host about the above.

    Leave a comment:

  • cronjob77
    New Member

  • cronjob77
    started a topic Search failing for thread titles but not for post

    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,
    
    [I][there are thousands of threadIDs here so I've removed most of them for readability][/I]
    
    ,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.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X