Announcement

Collapse
No announcement yet.

v4.1 Error Message

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

  • v4.1 Error Message

    I'm getting the following errors mailed to me. I understand that it's coming from post attempts, but I don't know what's causing it or how to correct it. All help appreciated.
    Thanks-
    Rich
    Database error in vBulletin: Invalid SQL:
    SELECT


    post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,
    attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter


    FROM
    post


    LEFT JOIN user ON user.userid=post.userid
    LEFT JOIN userfield ON userfield.userid=user.userid


    LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid


    WHERE
    post.postid IN ()
    ORDER BY dateline


    mysql error: You have an error in your SQL syntax near ')
    ORDER BY dateline
    ' at line 16
    mysql error number: 1064

  • #2
    Bug fix is listed in the bug tracking thread in the bug forum.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment


    • #3
      Thanks much.
      Rich

      Comment


      • #4
        Nope-
        Not in there. I see a post from Ed or John elsewhere that would indicate it's not yet published? Is this correct or am I missing the fix?
        Rich

        Comment


        • #5
          Still looking for help on this one.
          10Q
          Rich

          Comment


          • #6
            I quote:
            SQL error from showthread pages that don't exist.

            showthread.php, change:


            Code:
            $postids=""; 
             while ($post=$DB_site->fetch_array($getpostids)) {
               $postids.=",".$post[postid]; 
             }
             $postids="post.postid IN (".substr($postids, 1).")";
            to

            Code:
            $postids="post.postid IN (0"; 
             while ($post=$DB_site->fetch_array($getpostids)) { 
               $postids.=",".$post[postid]; 
             } 
             $postids.=")";
            From thread:
            http://www.vbulletin.com/forum/showt...threadid=12971
            Translations provided by Google.

            Wayne Luke
            The Rabid Badger - a vBulletin Cloud demonstration site.
            vBulletin 5 API

            Comment


            • #7

              Thanks again, Wayne.
              I didn't connect that fix with the problem.
              Rich

              Comment

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...
              X