SQL errors

[setishock]

I have gotten over a dozen of the database error emails. I check the site and it's running smoothly.
Could this be from the exploit for 4.2.2?

[squidsk]

What are the errors?

[setishock]

Database error in vBulletin 4.2.2:

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 < 1415460548 AND child.contenttypeid <> ) 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 = )
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 : 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 ') THEN 1 ELSE 0 END) AS publish_count
FROM cms_node AS node
LEFT JOIN cms_' at line 3
Error Number : 1064
Request Date : Saturday, November 8th 2014 @ 09:29:08 AM
Error Date : Saturday, November 8th 2014 @ 09:29:08 AM
Script : http://multirotorplatforms.com/cron.php?rand=1415460547
Referrer : http://multirotorplatforms.com/forum.php?styleid=11
IP Address : 172.6.17.137
Username : Unregistered
Classname : vB_Database
MySQL Version :

The cron reference goes to a blank page while the style is one I bought a while back. It's called black neon. I haven't done the exploit patch yet. Got to find my log in info first.

[Budget101]

Invalid SQL errors are almost always related to modified code.

To troubleshoot this, first reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. Also be sure to upload the admincp files to whichever directory you have set in your config.php file. Then run 'Suspect File Versions' in Diagnostics to make sure you have all the original files for your version and that none show 'File does not contain expected contents':

Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

[Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]

Next, disable all products (except vB Blog and vB CMS if you are running the Suite.)

Admin CP -> Plugins & Products -> Manage Products -> Disable

Then manually uncheck all plugins that are not for 'vBulletin Blog' and vBulletin CMS' here:

Admin CP -> Plugins & Products -> Plugin Manager

Then if you still have this problem, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it.

Do you have the same problem?

[setishock]

As soon as I have a moment to breathe, I'll check all that out. I manage a hotel so free time is a fleeting thing.
Thanks

[Budget101]

You may be able to bypass that by checking your Scheduled task log and looking up the cron job reference number: cron.php?rand=1415460547 (http://multirotorplatforms.com/cron.php?rand=1415460547) - which might be able to tell you what was running when it crapped the bed, so to speak.

I don't know if that will work, just trying to help...

[kh99]

Do you have the CMS disabled? According to this post: https://vborg.vbsupport.ru/showpost.php?p=2141467&postcount=26 it's a problem that happens when the CMS is disabled. I don't know if the fix that's suggested there is the best one or not.

[setishock]

Never occurred to me to check that. I'll let you know what I find out later this afternoon.

Yes CMS is disabled.

The odd thing is it has been disabled for almost a year. This just started a few days ago.

[kh99]

Did you just install a new mod? Maybe the author of that post meant that it's a known issue with some mods if the cms is disabled.

[alcazarx]

In addition to previous posters, there is a value missing in the statement.
SUM(CASE WHEN (child.setpublish > 0 AND child.publishdate < 1415460548 AND child.contenttypeid <> ) THEN 1 ELSE 0 END)
With what should be "child.contenttypeid" be compared?

[setishock]

I got a few minutes this morning so I'm going to disable the only mods I have installed. I really don't need either one since the place is so dead anyway.
I'll come back later and let you know how that works out.