Announcement

Collapse
No announcement yet.

Error in 3.8.2 seem like a cron error

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

  • Error in 3.8.2 seem like a cron error

    Hi Guys, i'm getting everyday error at 2.00AM. As follows:

    Database error in vBulletin 3.8.2:

    Invalid SQL:

    SELECT COUNT(*) as cnt,max(lastpost) as lastupdate
    FROM forum_thread AS thread
    INNER JOIN forum_tagthread AS tagthread ON
    (tagthread.tagid = 3 AND tagthread.threadid = thread.threadid)
    WHERE thread.forumid IN()
    AND thread.visible = 1
    AND thread.sticky IN (0, 1)
    AND thread.open <> 10
    GROUP BY tagthread.tagid;

    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 thread.visible = 1
    AND thread.sticky IN (0, 1)' at line 5 Error Number : 1064 Request Date : Tuesday, May 15th 2012 @ 02:00:07 AM
    Error Date : Tuesday, May 15th 2012 @ 02:00:07 AM
    Script : XXXXXXXXXXXXXXXXX
    Referrer : XXXXXXXXXXXXXXXXXXX
    IP Address : 124.150.57.112
    Username : Незарегистрированный
    Classname : vB_Database
    MySQL Version :


    This error started to happen after I moved to a new server.

    Thank you for your input.

  • #2
    Thats not a default query, you have any third party addons?

    Comment


    • #3
      Vbseo

      Comment


      • #4
        Originally posted by megroup View Post
        Vbseo
        What was here: Script : XXXXXXXXXXXXXXXXX

        ^ We need to know what page, you can edit out the main url i.e. https://www.removed.com/index.php?styleid=9 yet leave the rest as shown in my example left.


        Former vBulletin Support Staff
        Hacked recently? See my blog post "Recovering a Hacked vBulletin Site".
        Thinking outside the box? Need modification support? Visit www.vBulletin.org and have at it!

        Comment


        • #5
          If you look at your Scheduled Task log, which ones run at 2am?
          My Live vB5 Site - NZEating.com
          vBulletin Hosting | vBulletin Services - Need hosting for your vB? Need it installed? Something else? Let me take that hassle off your hands.

          Comment


          • #6
            This one runs everyday at 2.00 am

            vBSEO Search Engine XML Sitemap

            Comment


            • #7
              Originally posted by megroup View Post
              This one runs everyday at 2.00 am

              vBSEO Search Engine XML Sitemap
              Are you certain that you are running the most recent version of that modification?
              My Live vB5 Site - NZEating.com
              vBulletin Hosting | vBulletin Services - Need hosting for your vB? Need it installed? Something else? Let me take that hassle off your hands.

              Comment


              • #8
                Yep. The latest - 3.0 PL1

                Comment


                • #9
                  If the error is coming from that mod, you need to take that up with the authors.
                  Vote for:

                  - *Admin Settable Paid Subscription Reminder Timeframe*
                  -
                  *PM - Add ability to reply to originator only*
                  - Add Admin ability to auto-subscribe users to specific channel(s)
                  - "Quick Route" Interface...

                  Comment

                  Related Topics

                  Collapse

                  Working...
                  X