06-20-2014, 05:15 PM
|
|
|
Join Date: Feb 2008
Location: Houma, La.
Posts: 1,177
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Database error
4.2.2
CMS and Blog disabled.
I have gotten 6 notices of a database error over the last 5 days.
Quote:
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 < 1403279553 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 : Friday, June 20th 2014 @ 10:52:33 AM
Error Date : Friday, June 20th 2014 @ 10:52:33 AM
Script : http://multirotorplatforms.com/cron.php?rand=1403279552
Referrer : http://multirotorplatforms.com/forum.php
IP Address : REMOVED > Personal IP address.
Username : Unregistered
Classname : vB_Database
MySQL Version :
|
It's a small site. I do get a lot of views from guests and search bots. But as far as members, it's a ghost town.
A couple of things in the error message jump out. One is the ref to a cron php and the other is the ref to the CMS which is disabled.
Any ideas?
|