Announcement

Collapse
No announcement yet.

MYSQL error

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

  • [Forum] MYSQL error

    I recevied this error 3 time at the day

    PHP Code:
    Database error in vBulletin 4.2.0:

    Invalid SQL:

                            
    SELECT post.*,userfield.*, usertextfield.*,  user.*, IF(displaygroupid=0user.usergroupiddisplaygroupid) AS  displaygroupid,avatar.avatarpathNOT ISNULL(customavatar.userid) AS hascustomavatar,
                                                    
    customavatar.dateline AS  avatardatelinecustomavatar.width AS widthcustomavatar.height AS  height,
                                                     
    customavatar.height_thumb AS height_thumbcustomavatar.width_thumb AS  width_thumbcustomavatar.filedata_thumb
                            FROM post 
    AS post
                                    LEFT JOIN user 
    AS user ON (user.userid post.userid)
    LEFT JOIN userfield AS userfield ON (user.userid userfield.userid)
    LEFT JOIN usertextfield AS usertextfield ON (user.userid usertextfield.userid)
    LEFT JOIN avatar AS avatar ON (avatar.avatarid user.avatarid)
    LEFT JOIN customavatar AS customavatar ON (customavatar.userid post.userid)
                            
    WHERE post.postid IN (.,.,.,.,.,.);

    MySQL Error   You have an error in your SQL syntaxcheck the manual  that corresponds to your MySQL server version for the right syntax to  use near '.,.,.,.,.)' at line 10
    Error Number  
    1064
    Request Date  
    ThursdayNovember 22nd 2012 03:39:13 PM
    Error Date    
    ThursdayNovember 22nd 2012 03:39:13 PM
    Script        
    http://www.mysite.com/vb/search.php?searchid=415575
    Referrer      http://www.mysite.com/vb/search.php?do=process
    IP Address    41.254.2.247
    Username      
    username
    Classname     
    vB_Database
    MySQL Version 

    how to know from where the problem
    and how to solve it

    thanks

  • #2
    Look like there is a postid missing in the query. Are you using third party addons? That could be an explanation.
    No private support, only PM me when I ask for it. Support in the forums only.

    Comment


    • #3
      yes and that is what I use

      Anti Bump old Threads plugin-DE 1.0
      CT second_post_Ads 2.0.8
      Digital Point Analytics 1.1.1
      Forum Runner 4.2.0
      LancerForHire, LLC. - Bot Blocker 1.2
      Links and Downloads Manager 3.0.2
      Links and Downloads Manager Extras 3.0.2
      Make Prefixes Clickable to Filter Forumdisplay 1.1
      No Logout for Banned Users 2.0.0
      Post Thank You Hack 7.82
      Quick Auto Image-Resize (Posts & Signature) 1.0.0
      Recent Thanks 2.6.2
      Separate Sticky and Normal Threads 1.1
      Skimlinks Plugin 4.2.0
      Threads Auto Close advanced (by Usergroup) 0.5
      Threads notifications 3.0
      Usergroup Color Bar 2.1.1
      vBSEO :: Sitemap Generator 3.0
      VSa - Login To User Account
      VSa - Sub-Forum Manager
      [APM] Advanced Product Management
      [CKEditor] MARCO1 Advanced Quick Reply And Edit

      Comment


      • #4
        What happens when you disable all of those addons?

        Comment


        • #5
          I think the error will not appear (because this error happened recently and not happened before)

          But I don't know which one make this error
          because that error happened 2 time per day

          is there any way to know which one make this error ?

          Comment


          • #6
            Disable them all then turn one on at a time until you see which one causes the problem.
            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

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