Announcement

Collapse
No announcement yet.

Update tp 5.0.5 went smooth. But something is not quite right (Database error)

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

  • Update tp 5.0.5 went smooth. But something is not quite right (Database error)

    Updating from 5.0.4 to 5.0.5

    went really smooth.

    For now everything is working but
    we started to get those:

    Code:
    Invalid SQL:
    
    SELECT n.nodeid, n.title FROM closure AS cl
    
    INNER JOIN node AS n ON n.nodeid = cl.child
    
    INNER JOIN groupintopic AS git ON git.nodeid = n.nodeid
    
    WHERE cl.parent = 5 AND git.groupid IN () and git.userid = 0
    
    ORDER BY title
    
    /**getGitCanStartThreads**/;
    
    
    
    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 ') and git.userid = 0
    
    ORDER BY title
    
    /**getGitCanStartThreads**/' at line 4
    
    Error Number : 1064
    
    Request Date : Wednesday, September 25th 2013 @ 06:24:44 PM
    
    Error Date : Wednesday, September 25th 2013 @ 06:24:44 PM
    
    Script : http:///blogs
    
    Referrer : http://discoverxs.com/blogs
    
    IP Address : 91.207.7.50
    
    Username : Guest
    
    Classname : vB_Database_MySQLi
    
    MySQL Version :
    AND that function is already disabled.
    We disabled blogs long time ago.

    www.DiscoverXS.com - Putting the XS back into life™
    The first Pheromone Research community based on vBulletin Verion 5.x

  • #2

    ugh i got files half uploaded hoping i have better luck...
    hope u get is sorted quick

    Comment


    • IggyP
      IggyP commented
      Editing a comment
      things seem all good so far on mine..fingers crossed..lol

    • discoverxs3
      discoverxs3 commented
      Editing a comment
      can you check your blogs secton ?
      /blogs
      do they return any error ?

    • IggyP
      IggyP commented
      Editing a comment
      yes blogs seems fully working on mine....no error logs or mails..best lucks!

  • #3
    Is the site operating properly? How many times has the error occurred?

    You may get some of these. Some of the error reporting wasn't functioning properly in previous releases and it is fixed in vBulletin 5.0.5.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.

    Comment


    • discoverxs3
      discoverxs3 commented
      Editing a comment
      Everything else runs perfectly. Its happening when someone tries to go to blogs.
      We disabled the blogs in 5.0.4 by restricting access. and when someone lands there they get permissions error.
      Now in 5.0.5 they get this error. (well we get it over email)

  • #4
    I've reported this in a bug today: http://tracker.vbulletin.com/browse/VBV-11400

    Comment


    • discoverxs3
      discoverxs3 commented
      Editing a comment
      Thanks for that

  • #5
    Since we dont use the blogs at all
    we made a
    Redirect 301 /blogs to a fake domain
    from the .htaccess
    so that we dont get that sql email every now and then (2-4 times per hour)


    So anyone else having problems with the blogs in 5.0.5?

    www.DiscoverXS.com - Putting the XS back into life™
    The first Pheromone Research community based on vBulletin Verion 5.x

    Comment


    • #6
      I think it has to do something with automated bot scripts trying to make a blog post.
      Before the update in the logs i saw quite some few of those attempts.

      Now in 5.0.5 those attempts are returning this SQL error.

      www.DiscoverXS.com - Putting the XS back into life™
      The first Pheromone Research community based on vBulletin Verion 5.x

      Comment


      • #7
        This is likely an error that was always there, we fixed the way we handle database error emails in 5.0.5, we're expecting some stuff to crop up.

        Comment


        • #8
          In 5.0.4 Blogs ware working for us.
          We set the permissions a few weeks ago to block all (deny all) (for all user groups)
          and removed the link since we did not use them.
          after the update emails started.

          Will monitor VBV-11400 from now on.

          www.DiscoverXS.com - Putting the XS back into life™
          The first Pheromone Research community based on vBulletin Verion 5.x

          Comment

          Related Topics

          Collapse

          • aristor
            Database Errors
            by aristor
            What causes this error?

            Code:
             Database error in vBulletin 5.1.0:  
            Invalid SQL: SELECT DISTINCT node.nodeid, node.contenttypeid FROM vb5_node AS starter INNER JOIN vb5_node AS node
            ...
            Sat 26th Apr '14, 11:24pm
          • z-at-ox
            Error after upded to 5.0.2
            by z-at-ox
            This is the error, when I use the page manager.

            Error: An unexpected error was returned: ' Database error in vBulletin 5.0.2: Invalid SQL: UPDATE node AS node INNER JOIN closure AS cl ON...
            Thu 9th May '13, 12:50pm
          Working...
          X