[Forum] Rebuild Search Index Error

[dadoc]

Hello,

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,
n.new
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 : http://www.crimecasefiles.com/forum/...0&indextypes=0
Referrer : http://www.crimecasefiles.com/forum/...0&indextypes=0
IP Address : 110.32.172.xxx
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

Ryan

[dadoc]

Is this because I am not using cms_article

[we_are_borg]

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

[Zachery]

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

[dadoc]

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

[Zachery]

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

[we_are_borg]

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