Announcement

Collapse
No announcement yet.

Database error: SELECT node.nodeid, node.url FROM cms_nodeinfo AS info INNER JOIN cms

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Database error: SELECT node.nodeid, node.url FROM cms_nodeinfo AS info INNER JOIN cms

    Code:
    Database error in vBulletin 4.0.5:
    
    Invalid SQL:
    SELECT node.nodeid, node.url FROM cms_nodeinfo AS info INNER JOIN cms_node AS node ON node.nodeid = info.nodeid
    					WHERE info.associatedthreadid =;
    
    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 '' at line 2
    Error Number  : 1064
    Request Date  : Wednesday, July 21st 2010 @ 09:28:06 AM
    Error Date    : Wednesday, July 21st 2010 @ 09:28:06 AM
    Classname     : vB_Database
    MySQL Version : 5.0.91-community
    Anyone have any ideas what would cause this?

    Thanks

  • #2
    Hi, anyone have an idea on this? I've waited beyond the 24 hour bump limit.

    Thanks.

    Comment


    • #3
      Database error in vBulletin 4.0.5:

      Invalid SQL:
      SELECT node.nodeid, node.url FROM vb_cms_nodeinfo AS info INNER JOIN vb_cms_node AS node ON node.nodeid = info.nodeid
      WHERE info.associatedthreadid =;

      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 '' at line 2
      Error Number : 1064
      Request Date : Thursday, July 29th 2010 @ 01:02:06 PM
      Error Date : Thursday, July 29th 2010 @ 01:02:06 PM

      Classname : vB_Database
      MySQL Version : 5.0.91-community
      I am getting the same error! after upgrading from 4.04 to 4.05, the error goes away when I disable the CMS.
      Looking for help!
      Thanks.
      FIND ME ON
      AndyClift.com
      Etsy
      Facebook
      Google Plus
      Linkedin
      Twitter
      YouTube

      Comment


      • #4
        What page are you on when you get this error?

        Please don't PM or VM me for support - I only help out in the threads.
        vBulletin Manual & vBulletin 4.0 Code Documentation (API)
        Want help modifying your vbulletin forum? Head on over to vbulletin.org
        If I post CSS and you don't know where it goes, throw it into the additional.css template.

        W3Schools <- awesome site for html/css help

        Comment


        • #5
          I am getting this error on most of all my post pages in the forum. For some reason it isn't happening on all of them though.
          FIND ME ON
          AndyClift.com
          Etsy
          Facebook
          Google Plus
          Linkedin
          Twitter
          YouTube

          Comment


          • #6
            seems vbrecipe was causing this error. upgraded to vbrecipe 4.04 and now everything is working.
            FIND ME ON
            AndyClift.com
            Etsy
            Facebook
            Google Plus
            Linkedin
            Twitter
            YouTube

            Comment


            • #7
              isn't that something...i just had the same thing happen.

              disabled vbrecipe and the forum shows all threads now.

              WOW!

              Comment

              Related Topics

              Collapse

              Working...
              X