[Forum] Database errors after upgrade to 4.03

[djbaxter]

I'm getting several notifications exactly like this one since upgrading from 4.02 PL4 to 4.03 about an hour ago:

Database error in vBulletin 4.0.3:

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 = 146 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 : Thursday, April 8th 2010 @ 11:40:06 PM
Error Date : Thursday, April 8th 2010 @ 11:40:11 PM
Script : http://{forum}/cron.php?rand=1270784404
Referrer : http://{forum}/search.php?searchid=108782
IP Address : {varies}
Username : Unregistered <== it ALWAYS says Unregistered
Classname : vB_Database
MySQL Version :

Note: At present, I have both the CMS and the Blog disabled, which makes the references to cms in the error message particularly puzzling.

[Lynne]

It's a cron job that is giving the error. Perhaps you still have some of the Scheduled Tasks running for the CMS even though it is off?

[djbaxter]

No. I just checked now. All are disabled, I think that would have occurred automatically when I disabled the CMS.

Also, I was not getting any of these errors until just after I upgraded. The CMS has been disabled almost from the time I upgraded from 3.84.

[djbaxter]

For the benefit of others who may experience this, I resolved it by turning off another unused cron job:

Search Queue Updates
Queue updates for search? This MUST be enabled if updates are queued in Settings > Options > Message Searching Options. Otherwise search will find only old information.

Again, I am not using the queued updates option so I'm not sure why this was disabled, but disableing it stopped the error messages.