Database error in vBulletin 4.2.5 (Error Number : 1064)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • quachvu
    New Member
    • Oct 2004
    • 15
    • 3.0.3

    Database error in vBulletin 4.2.5 (Error Number : 1064)

    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:

    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
  • Mark.B
    vBulletin Support
    • Feb 2004
    • 24286
    • 6.0.X

    #2
    This is related to the DBSEO addon.

    Please contact them for support.. chances are you'll need to update DBSEO as well.
    MARK.B
    vBulletin Support
    ------------
    My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
    My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

    Comment

    Related Topics

    Collapse

    Working...