Database Error while searching the threads

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jerit2012
    Member
    • May 2012
    • 50

    Database Error while searching the threads

    After today's scheduled backup, Forum receiving database Error when searching the threads or post. Below is the error:

    Code:
    Database error in vBulletin 4.1.12:
     Invalid SQL:
                                                     SELECT searchlog.*
                                                    FROM searchlog AS searchlog
                                                    WHERE searchhash = '34e19207620699233a83cac718eb84e3' AND
                                                                    sortby =  'relevance' AND
                                                                    sortorder =  'desc' AND
                                                                    dateline > 1522123293 AND
                                                                    userid = 1 AND
                                                                    completed = 1
                                                    ORDER BY dateline DESC
                                                    LIMIT 1;
    
    MySQL Error   : Table './xxxxxx_xxx/searchlog' is marked as crashed and last (automatic?) repair failed
    Error Number  : 144
    Request Date  : Tuesday, March 27th 2018 @ 05:01:33 AM
    Error Date    : Tuesday, March 27th 2018 @ 05:01:33 AM
    Script        : http://xxxxxx.xxxx/search.php?do=process
    Referrer      : https://xxxxx.xxxx/search.php
    IP Address    : 
    Username      :
    Classname     : vB_Database_MySQLi
    MySQL Version : 5.6.38

    Kindly advise how this issue can fix?
  • Mark.B
    vBulletin Support
    • Feb 2004
    • 24288
    • 6.0.X

    #2
    Run the following query on the database:

    Code:
    REPAIR TABLE searchlog
    MARK.B
    vBulletin Support
    ------------
    My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
    My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

    Comment

    • jerit2012
      Member
      • May 2012
      • 50

      #3
      The above issue has been fixed by Mr. Set3sh



      Comment

      • Mark.B
        vBulletin Support
        • Feb 2004
        • 24288
        • 6.0.X

        #4
        Glad you got it sorted, the fix is, however, what I posted above, in case anyone else runs into it. It's a crashed table.
        MARK.B
        vBulletin Support
        ------------
        My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
        My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

        Comment

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