vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Database error (https://vborg.vbsupport.ru/showthread.php?t=312306)

setishock 06-20-2014 04:15 PM
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?

setishock 06-24-2014 07:39 AM
I'm getting these every day now. Sure could use some help figuring out what's going on.

Dave 06-24-2014 08:29 AM
Maybe this will help you out: http://www.vbulletin.com/forum/forum...database-error

Paul M 06-24-2014 10:13 AM
That query is definiteky a CMS query (its actually from the function getSections()).

You have a cron job running that is referencing the CMS, hard to tell which from the above message, but my guess would be sitemap.


All times are GMT. The time now is 10:36 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01496 seconds
  • Memory Usage 1,717KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete