After upgraded from vBB 4.2.3 to 4.2.5 (successfully) I got this error message (via Email), can some one tell what i should do to resolve this problem? thanks.
Database error in vBulletin 4.2.5:
Invalid SQL:
SELECT node.nodeid, node.contenttypeid, node.hidden, info.title, parentinfo.title AS section,
parent.nodeid AS sectionid, node.setpublish, node.publishdate, node.url FROM cms_node AS node INNER JOIN cms_nodeinfo AS info ON info.nodeid = node.nodeid
INNER JOIN cms_node AS parent ON parent.nodeid = node.parentnode
INNER JOIN cms_nodeinfo AS parentinfo ON parentinfo.nodeid = parent.nodeid
WHERE node.setpublish > 0 AND parent.setpublish > 0 AND parent.publishdate < 1500969989 AND node.publishdate < 1500969989 AND node.permissionsfrom IN (1) AND (node.contenttypeid <> ) ORDER BY parent.nodeleft, info.title LIMIT 0, 30000;
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 ') ORDER BY parent.nodeleft, info.title LIMIT 0, 30000' at line 5
Error Number : 1064
Request Date : Tuesday, July 25th 2017 @ 10:06:29 AM
Error Date : Tuesday, July 25th 2017 @ 10:06:29 AM
Script : http://online.duhoc.de/cron.php?rand=1500969988
Referrer : https://online.duhoc.de/du-hoc-duc.58/
IP Address : 2A02:908:F18:4840:6408:553C:8710:646A
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :
Server :
User Agent :
Stack Trace:
#0 vB_Database->halt() called in [path]/includes/class_core.php on line 1395
#1 vB_Database_MySQLi->execute_query() called in [path]/includes/class_core.php on line 461
#2 vB_Database->query_read() called in [path]/packages/vbcms/contentmanager.php on line 4302
#3 vBCms_ContentManager::getPublicContent() called in [path]/dbtech/dbseo/includes/class_sitemap.php on line 2746
#4 DBSEO_SiteMap_Cms->generate_sitemap() called in [path]/dbtech/dbseo/includes/class_sitemap.php on line 268
#5 DBSEO_SiteMapRunner->generate() called in [path]/dbtech/dbseo/cron/sitemap.php on line 106
#6 include_once([path]/dbtech/dbseo/cron/sitemap.php) called in [path]/includes/functions_cron.php on line 276
#7 exec_cron() called in [path]/cron.php on line 86
I am using:
Database error in vBulletin 4.2.5:
Invalid SQL:
SELECT node.nodeid, node.contenttypeid, node.hidden, info.title, parentinfo.title AS section,
parent.nodeid AS sectionid, node.setpublish, node.publishdate, node.url FROM cms_node AS node INNER JOIN cms_nodeinfo AS info ON info.nodeid = node.nodeid
INNER JOIN cms_node AS parent ON parent.nodeid = node.parentnode
INNER JOIN cms_nodeinfo AS parentinfo ON parentinfo.nodeid = parent.nodeid
WHERE node.setpublish > 0 AND parent.setpublish > 0 AND parent.publishdate < 1500969989 AND node.publishdate < 1500969989 AND node.permissionsfrom IN (1) AND (node.contenttypeid <> ) ORDER BY parent.nodeleft, info.title LIMIT 0, 30000;
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 ') ORDER BY parent.nodeleft, info.title LIMIT 0, 30000' at line 5
Error Number : 1064
Request Date : Tuesday, July 25th 2017 @ 10:06:29 AM
Error Date : Tuesday, July 25th 2017 @ 10:06:29 AM
Script : http://online.duhoc.de/cron.php?rand=1500969988
Referrer : https://online.duhoc.de/du-hoc-duc.58/
IP Address : 2A02:908:F18:4840:6408:553C:8710:646A
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :
Server :
User Agent :
Stack Trace:
#0 vB_Database->halt() called in [path]/includes/class_core.php on line 1395
#1 vB_Database_MySQLi->execute_query() called in [path]/includes/class_core.php on line 461
#2 vB_Database->query_read() called in [path]/packages/vbcms/contentmanager.php on line 4302
#3 vBCms_ContentManager::getPublicContent() called in [path]/dbtech/dbseo/includes/class_sitemap.php on line 2746
#4 DBSEO_SiteMap_Cms->generate_sitemap() called in [path]/dbtech/dbseo/includes/class_sitemap.php on line 268
#5 DBSEO_SiteMapRunner->generate() called in [path]/dbtech/dbseo/cron/sitemap.php on line 106
#6 include_once([path]/dbtech/dbseo/cron/sitemap.php) called in [path]/includes/functions_cron.php on line 276
#7 exec_cron() called in [path]/cron.php on line 86
Server Type | SunOS | ||
Web Server | Apache v2.2.31 (cgi-fcgi) | ||
PHP | 7.0.21 | ||
PHP Max Post Size | 76.00 MB | ||
PHP Maximum Upload Size | 64.00 MB | ||
PHP Memory Limit | 256.00 MB | ||
MySQL Version | 5.6.36-log | ||
MySQL Packet Size | 100.00 MB |
Comment