No announcement yet.

Rebuild Search Index Error

  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Rebuild Search Index Error


    I have recently upgraded the forum from 3.7.0 to 4.1.11.

    Due to search function not displaying all content I have run the Rebuild Search Index

    The settings were

    Content type to index All

    Number of items to process per batch 250

    Item id to start at 0

    Total number of items to process (0 to process till end, 1 to just index that item) 0

    Include automatic JavaScript redirect to next page? yes

    I realise the rebuild would take quite a while, it ran for about 10 to 15 minutes and stopped
    and produced the following error:

    Database error in vBulletin 4.1.11:

    Invalid SQL:
    SELECT u.username, n.userid, a.contentid,
    a.pagetext, i.title, n.publishdate, i.creationdate, i.html_title, n.nosearch,
    FROM cms_article a
    LEFT JOIN cms_node n on n.contentid = a.contentid
    LEFT JOIN cms_nodeinfo i on i.nodeid = n.nodeid
    LEFT JOIN user u on u.userid = n.userid
    WHERE a.contentid = 0 AND n.contenttypeid =;

    MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 8
    Error Number : 1064
    Request Date : Wednesday, April 4th 2012 @ 10:14:42 PM
    Error Date : Wednesday, April 4th 2012 @ 10:14:42 PM
    Script :
    Referrer :
    IP Address :
    Username : DADOCTOR
    Classname : vB_Database
    MySQL Version : 5.1.61-cll
    I am not sure what this error is

    I do not have CMS active, it only has its default contents.

    Any help is appreciated.

    Thank you

    Crime case files

  • #2
    Is this because I am not using cms_article
    Crime case files


    • #3
      If you uninstalled the CMS add-on you can get errors you should have disabled it to get the same effect.


      • #4
        I would suggest also uninstalling the cms, then re-running the upgrade. Then try to rebuild the searchindex again.


        • #5
          Originally posted by Zachery View Post
          I would suggest also uninstalling the cms, then re-running the upgrade. Then try to rebuild the searchindex again.
          can I just do the cms re-run upgrade that wont change or effect any part of the forum or Blog?

          Is it possible that if there is lots to reindex in search it might time out or stop, and can I find out what has or has not been reindexed ?

          Thankyou for your reply Zac
          Last edited by dadoc; Sat 7th Apr '12, 7:56pm.
          Crime case files


          • #6
            The upgrade script only does what it needs to, it won't mess with anything.


            • #7
              Remember always backup before atempting a upgrade never take a risk with the database. There is no excuse not to backup first.


              Related Topics