[fxwoody]

Originally Posted by rolfw1

Well done, that should help a lot of people.

Tks rolfw1 Tho now i made a doodoo in my database with the script trying to get all the thumbnails to show! lolll

ohhh well, when it's not one thing it's another!

By the way, i got this from the error:

Database error in vBulletin 4.0.6:

Invalid SQL:
SELECT node.nodeid, node.url, node.parentnode, node.nodeleft, node.noderight,
			node.setpublish, node.publishdate, info.title, node.permissionsfrom, node.hidden, COUNT(child.nodeid) AS children,
  			SUM(CASE WHEN (child.setpublish > 0 AND child.publishdate < 1282347755 AND child.contenttypeid <> 17) THEN 1 ELSE 0 END) AS publish_count
			FROM cms_node AS node
			LEFT JOIN cms_node AS child ON child.parentnode = node.nodeid AND child.new != 1
			LEFT JOIN cms_nodeinfo AS info ON info.nodeid = node.nodeid
			WHERE (node.contenttypeid = 17)
			GROUP BY node.nodeid, node.url, node.parentnode, node.nodeleft, node.noderight,
			node.setpublish, node.publishdate, info.title, node.permissionsfrom, node.hidden  HAVING COUNT(child.nodeid) > 0 
			ORDER by node.nodeleft;;

MySQL Error   : Got error 28 from storage engine
Error Number  : 1030
Request Date  : Saturday, August 21st 2010 @ 01:42:35 AM
Error Date    : Saturday, August 21st 2010 @ 01:42:35 AM
Script        : http://wood
Referrer      : 
IP Address    : 
Username      : woody
Classname     : vB_Database
MySQL Version : 5.0.91-community