Question 'Build Sitemap' Database Error

[heyzeus909]

Database error in vBulletin 4.2.0:

Invalid SQL:

			SELECT node.*, nodeinfo.*
			FROM vb_cms_node AS node
			LEFT JOIN  vb_cms_nodeinfo AS nodeinfo ON(nodeinfo.nodeid = node.nodeid)
			WHERE (
					node.nodeid IN() OR (
						node.parentnode IN () AND 
						contenttypeid = '17'
					)
				)
				AND node.nodeid >= 0
			ORDER BY node.nodeid
			LIMIT 2;

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 ') OR (
						node.parentnode IN () AND 
						contenttypeid = '17'
					)
				)
' at line 5
Error Number  : 1064
Request Date  : Saturday, March 22nd 2014 @ 02:41:51 PM
Error Date    : Saturday, March 22nd 2014 @ 02:41:52 PM
Script        : http://www.thefreeradicals.net/forum/dbseocp/index.php?do=buildsitemap
Referrer      : http://www.thefreeradicals.net/forum/dbseocp/index.php?do=buildsitemap
IP Address    : xx.xx.xx.xx
Username      : heyzeus909
Classname     : vB_Database
MySQL Version : 5.5.34-32.0-log

On my first attempt to build a sitemap, it started off fine but soon ended with an error. Then it immediate produced an error. After searching this forum, I reduced the 'URLs Per Page' setting to 1000, still no luck. Not even setting it to 1 would do the trick.

Any help would be appreciated.

 

[Fillip H.]

This will be fixed in the next version. What this means is that you have no CMS sections that guests can read, so you should disable this from your sitemap in the meantime.